DSXchange

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

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.