writing data from a routine

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sasidhar_kari
Premium Member
Premium Member
Posts: 62
Joined: Wed Dec 08, 2004 2:26 am

writing data from a routine

Post by sasidhar_kari »

Hi
Can some one help me on how to write data to a table from a basic routine. Its a kind of requirement where in i had to update a table from a routine.

How to connect to a database from a routine.

How to write the update statement in a routine means can i directly use the update statement or is there any workaround


thanks
sasi
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Server or ll routine ?
sasidhar_kari
Premium Member
Premium Member
Posts: 62
Joined: Wed Dec 08, 2004 2:26 am

Post by sasidhar_kari »

Its a Basic Transform Routine in Parallel jobs
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

DSExecute() ?
sasidhar_kari
Premium Member
Premium Member
Posts: 62
Joined: Wed Dec 08, 2004 2:26 am

Post by sasidhar_kari »

Hi
Can anyone share some idea on this as i tried to find relevent information in the forum using the keyword BCI but i didn't able to find the relevent post related to my issue.

Kindly suggest

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

Post by chulett »

Jeez, popular subject all of a sudden. You've already posted in the thread most relevant to this, anything we could say on the subject is there. And pretty much any post that mentions BCI is "relevant" to your issue.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

... including "resist stupid requirements".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply