MVSFORUMS.com

ravikumar_sri2001 · Posted: Wed Apr 06, 2005 9:40 am Post subject: Comparision mismatches - Help

Hi Gurus,

I have a table which has only a unique index defined on it. (NO Primary key and foreign keys) The unique index consists of 3 columns.
Given below the result of query

select * from sysibm.SYSKEYS where IXNAME = 'EFPROCX1'
order by COLSEQ

kolusu · Posted: Wed Apr 06, 2005 10:07 am Post subject:

ravikumar,

How are you creating the datasets in step 2 and 5 ? are you unloading the data from the table?

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

coolman · Posted: Wed Apr 06, 2005 2:15 pm Post subject:

Ravikumar,

The steps in which you are copying records from table to temp. datasets need not be in the same order. Hence, the mismatch.

But I have another question. You said the modified program, you are adding some extra columns-to the VIEW and running the Production program. Is this correct?
Should you just run the PRODUCTION version with your old view and run your beta with the new view and even though the records added in both cases would be the same, a file-aid compare of the 2 files, would highlight the newly added columns for the beta version which would be justifiable
Cheers,
Coolman
________
[URL=http://www.dodge-wiki.com/wiki/Dodge_Charger_(1999_concept)]Dodge Charger (1999 concept)[/URL]

ravikumar_sri2001 · Posted: Thu Apr 07, 2005 3:00 am Post subject:

I am unloading the rows from VIEW to datasets using utility DSNTIAUL. In production run, i getting spaces in newly introduced fields. In Beta run, i am supplying values to newly introduced fields. So, i can justify my testing.

Thanks,
Ravikumar.

kolusu · Posted: Thu Apr 07, 2005 5:40 am Post subject:

Ravikumar,

When unloading the rows from a table using DSNTIAUL you are not guranteed the order of the records unless you specify the ORDER BY clause. When you insert rows into the table, it inserts into the available free page . Unless you re-org after a mass insert you are not guranteed to have the inserted records in order.

So add a ORDER BY the index columns in your unload step for both production and test run to avoid the sequence errors.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

ravikumar_sri2001 · Posted: Wed Apr 13, 2005 7:41 am Post subject:

Thanks a lot for your replies.

Thanks,
Ravikumar.