teradata stored procedure

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
lucianopolinari
Participant
Posts: 11
Joined: Wed Apr 23, 2003 2:54 am

teradata stored procedure

Post by lucianopolinari »

Hi,

I'm working with DataStage on Teradata for designing job mainframe and job server. Now I have a problem: I can't launch a stored procedure, created in Teradata, with the teradata plug-in.

In DS Teradata plug-in I can't launch a delete, select, update and insert but not this expression:

CALL DXDBA.ANAGRAFE('....')

How can I do ???[?][?][?]


Thank you !!
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
not familiar with teradata but from my experiance:
did you try to use execute or exec instead of Call?

Good luck,

Roy R.
Post Reply