Missing records in LH tables (AREV Specific)
At 07 MAY 2002 06:06:23AM Adil Yalcin wrote:
Dear all,
We have been extracting LH data by using LIST command and loading into Oracle for datawarehouse purposes.
While extracting a huge LH table, we have noticed that, some records are missing in the extracted text file. ( There is not any selection criteria in LIST statement )
I have tested this and I observed that,
COUNTROWS gives 4,226,540 records but
LIST command gives 4,225,792 records in total.
Then I started run COUNTROWS and it still gives 4,226,540.
Have you encountered this type of problem before ?
Many thanks.
At 07 MAY 2002 06:29AM [url=http://www.sprezzatura.com" onMouseOver=window.status= Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Adil, long time no see! Hope the weather is nicer there than it is here at the moment.
This can be something as simple as the header not being completely up to date - not uncommon in a large table. You can FORCE the header to be up to date by making a call to Get.RecCount and in the third parameter passing True$ to FORCE a select on the file rather than a read of the header. This will take a while and it is recommended that noone else be logged in whilst you do this.
[i]Celebrate CeBIT with Sprezz Local![/i]
