Update table directly from a routine

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
vijay.barani
Participant
Posts: 78
Joined: Wed Jun 04, 2008 2:59 am

Update table directly from a routine

Post by vijay.barani »

Dear Friends,
Could any body help me regarding this.I have a requirement like i have to update a table directly from a routine.My routine gives a value which should be updated in a table directly.
Warm Regards,
Vijay
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

We've responded a lot to this question but you are ignoring us. Connecting to a database from a routine requires you to do things not natively supported in the tool. The easiest way to do gain unsupported functionality of communicating with a database is to use the command line gateway ExecSH/ExecDOS and connect using the command line interface to your database (isql, osql, sqlplus, dbaccess, etc).
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Different poster but a remarkably similar question.

viewtopic.php?p=323634
-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:

Re: Update table directly from a routine

Post by ray.wurlod »

vijay.barani wrote:I have a requirement like i have to update a table directly from a routine.
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