hi All,
i got to do a look up on a file using the same file as i have to concatenate data becos it got split. so i have to reject data which has duplicate key columns data. how and what constraint should i use. kindly suggest.
thanks
reject rows
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Read the sequential file as source and lookup the key values into an empty hash-file - key being same as your seq file and additional col which is to hold the concatenated values.
Concatenate the 'split description'
Write the result into the same hash-file.
Disable the 'preload to memory' option.
By this way, each record will insert / update and form a full record of concatenated values.
There is no need for any constraint.
Concatenate the 'split description'
Write the result into the same hash-file.
Disable the 'preload to memory' option.
By this way, each record will insert / update and form a full record of concatenated values.
There is no need for any constraint.