update statement

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
waitnsee
Participant
Posts: 23
Joined: Tue Jul 06, 2004 10:20 am

update statement

Post by waitnsee »

Please let me know what this update statement means.

UPDATE
PSMGR.PS_VZ_STG_ETTP
SET
TLEVEL= :2
WHERE
VZ_LISTINGID= :1

iF you say set TLEVEL = :2 what does it mean?
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

The colon-number goodies are parameter markers. The number is the column number defined in the stage. So... :2 gets substituted with the value of the second column when the update runs.
-craig

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

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