DS - 7.5.1 (DB2 API and EE stages)
Is there any know issue with the sequence of primary keys for a DB2 table (DB2 API or EE stages) ?
i.e. say we have a table T1 with following structure:
Collumn Primary Key
C1 Y
C2 N
C3 N
A datastage job is created for this table structure. After this now the table structure is changed and a new collumn and key is added.
Collumn Primary Key
C1 Y
C2 N
C3 N
C4 Y
Here, is there any known issue with the primary key defined at the end of the table, instead of the start with other primary keys ?
Cheers,
BA
Issue with order of primary keys
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 7
- Joined: Thu Sep 30, 2004 5:22 am
-
- Participant
- Posts: 7
- Joined: Thu Sep 30, 2004 5:22 am
Thanks
[quote="chulett"]No, there's no rule as to where or in what order they need to be declared in the table. That's a people thing. ...[/quote]
Thanks for your reply, just one more thing, will it impact the job (if we don't add this key) in any way i.e. will it require job change or anything of that sort ? I think the issue is seen with the hash file i.e. the keys have to be in same order and all of them shud be there, but was not sure if this holds for the EE stage as well..
Thanks for your reply, just one more thing, will it impact the job (if we don't add this key) in any way i.e. will it require job change or anything of that sort ? I think the issue is seen with the hash file i.e. the keys have to be in same order and all of them shud be there, but was not sure if this holds for the EE stage as well..