Page 1 of 1

Selecting from an image copy using HPU INFUTILB

PostPosted: Thu Oct 21, 2010 8:54 am
by ITConsultant
HI, I have image copy of a very large table on tape.

I am using INFUTILB utility to write out few of the millions of records that I am interested in.

I am selecting as following:

Select * from Table_A where
(column_A = value_A1 and column_B = value_B1) or
(column_A = value_A2 and column_B = value_B2) or
(column_A = value_A3 and column_B = value_B3) or
.
.
.
(column_A = value_A100 and column_B = value_B100) ;

Values in column_A are various dates while the Column_B values are numeric.

I am writing the output to a file. The resulting records that I get have gaps. For example, it will write M number of matching records and then skip N records before writing the matching records again. If I submit the job again after changing query to only select the records it missed the first time, it finds some but still misses a lot of them.

why would this be the case?

Re: Selecting from an image copy using HPU INFUTILB

PostPosted: Thu Oct 21, 2010 11:15 am
by dick scherrer
Hello,

What informational messages are created by the run?

It may help if you post these. . .

Re: Selecting from an image copy using HPU INFUTILB

PostPosted: Thu Oct 21, 2010 11:47 pm
by ITConsultant
There were no errors or unusual messages in the log. Despite client's assurances that they provided me accurate selection data, that is not the case. The account rows they wanted retrieved are not there on the image copy and now they tell me that they may be stored under a different account number.