ODBC Stage Positional ? Substitution

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
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Welcome aboard. In server jobs all you have in the ODBC stage is positional parameters - in this case row numbers within the Columns grid.
The columns that end up in the SET clause are not marked as Key. The columns that end up in the WHERE clause are marked as Key in the Columns grid.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
arunpramanik
Participant
Posts: 63
Joined: Fri Jun 22, 2007 7:27 am
Location: Kolkata

Post by arunpramanik »

Is it necessary to position the key fields at the first column grids when you are using ODBC stage for update?

As far as I know in MS OLEDB which also use the positional parameters, I had place the key fields at first of column grids for Update
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

People typically adopt that as a convention, but no it's not required.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”