Reading Surrogate Keys from SDKSequences

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
adamski
Charter Member
Charter Member
Posts: 54
Joined: Thu Mar 20, 2003 5:02 pm

Reading Surrogate Keys from SDKSequences

Post by adamski »

Hi

Can anyone tell me why when I follow the steps the the second post of the linked topic, the ID values are visible when performing a "right click, view data" on the source hash stage, but are not present in the sequenctial file output when the job is run.

viewtopic.php?t=104296

All the data apears to shift one column to the left, so the values end up in the ID column, and the VALUE column is empty.

Thanks
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

That would happen if you failed to mark a Key field as a Key.
-craig

"You can never have too many knives" -- Logan Nine Fingers
adamski
Charter Member
Charter Member
Posts: 54
Joined: Thu Mar 20, 2003 5:02 pm

Post by adamski »

Thanks, that did it.

Too easy to miss the obvious sometimes.
Post Reply