User-defined Sql File -- Update action in DRS

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
madhavi_gopaladasu
Participant
Posts: 1
Joined: Mon Dec 08, 2003 5:01 pm

User-defined Sql File -- Update action in DRS

Post by madhavi_gopaladasu »

Hi,

I am using "User-defined Sql File" update action in DRS stage.
I have a file with the sql scripts to be run.

I gave the sql file path in the User-defined text area. Its not working that way. Can anyone suggest where/how to give the sql file name.

Thanks for your help.
Top
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Welcome aboard! :D

Although it's not intuitive, try putting the pathname of the file in the Table Names field on the General tab.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”