how to create group enable transaction in ODBC STAGE.

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
chvenkat.v
Participant
Posts: 94
Joined: Fri Dec 14, 2007 3:22 am

how to create group enable transaction in ODBC STAGE.

Post by chvenkat.v »

HI

how to create group enable transaction in ODBC STAGE in server jobs.

THANKS
VENKAT
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The ODBC stage must have multiple inputs. Once that has been done a check box should become enabled allowing you to specify grouped transaction (if I recall correctly).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chvenkat.v
Participant
Posts: 94
Joined: Fri Dec 14, 2007 3:22 am

Post by chvenkat.v »

hi,

i have give 3 updated statements to the ODBC stage.But the trascation grouping was not enabled. any properties we have set this stage.

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

Post by chulett »

I'm not sure it's supported but if it is, you'd need multiple input links to a single ODBC stage to enable it - is that what you tried?
-craig

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