Test Data Manager

Expand all | Collapse all

Table Count when using View

Jump to Best Answer
  • 1.  Table Count when using View

    Posted 03-26-2018 09:22 AM

    If I use SEQLOV from an Oracle view,  what can O use in Table Count to make sure I grab all the rows?  The view is parameterized.  What is the best way to do this?  Alternatives?  Thanks



  • 2.  Re: Table Count when using View

    Posted 03-26-2018 11:51 AM

    I'm using execsqlcount to get # of rows, but that requires a second call to the backend.  Is there another way?



  • 3.  Re: Table Count when using View
    Best Answer

    Posted 04-02-2018 01:33 PM

    Yes you will need the second call. You could set it to a variable and then use that for all the table counts.