Routine Of DB2 AS/400

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
snassimr
Premium Member
Premium Member
Posts: 281
Joined: Tue May 17, 2005 5:27 am

Routine Of DB2 AS/400

Post by snassimr »

I want to call routine of DB2 AS/400 and get output into DS

Any body can help me ?
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
what do you mean by routine?
(a rpg routine?)

Your limited to the DB syntax you connect to,
so is there any syntax to run this routine using a sql statement?

i.e. In MSSqlServer you can invoke a bulk load using a sql statement you issue via user defined sql in an ODBC/OLEDB stage.

IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
Post Reply