MVSFORUMS.com

[satyenderd]

Hi all,

Herein I am having a doubt while loading the data in the tables which have SEQ_NO as Identity column.
I am able to load the table, but, I have to synchronize the tables data in all test regions. while doing this, I am getting the seq no different.
For example, I am unloading the data from TEST1 region and loading in TEST2 region.
In the TEST1 region the values of SEQ_NO are somewhat like 1, 3, 4
when I am loading the data in TEST2 region the value are loading in it as 1, 2, 3

And, this does not make the tables in sync in the regions.

Please suggest me how to make them in sync.


DDL:

[NASCAR9]

Define the second TEST region as an Integer and unload TEST1 and load results in TEST2.

or set the identity column up something like this :

[satyenderd]

Thanks a lot NASCAR9 for your suggestion.
_________________
Satya

[haatvedt]

Satya,

you may want to check those values. I've always set the RESTART value to the max from select query + 1.

also you probably want to alter the identity column to be "GENERATE ALWAYS" as that was the original definition. This would need to be done after the table is loaded.

I had to alter the Load control cards generated during the unload as it generated a non-existent column name for the identity column. This may be dependent upon the particular software / version that I was using at the time.

good luck,
_________________
Chuck Haatvedt

email --> clastnameatcharterdotnet

(replace lastname, at, dot with appropriate
characters)