Load SQL from file at run-time

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
sam paul
Premium Member
Premium Member
Posts: 19
Joined: Mon Jan 26, 2009 1:31 pm
Location: Minneapolis, USA

Load SQL from file at run-time

Post by sam paul »

Hi,

I am trying to load AQL from a file which is created from another job.
I am using Oracle OCI stage. In the Stage Tab, i have given the correct credentials.
In the Output tab, in General Tab, i have selected "Load SQL from file at Runtime". In Columns under Output, i have given the output columns.
In the SQL tab under Output, i have selected "Load SQL from file at Runtime".
In the place where the custom sql is present, i have given "sqlfile.sql/#SQLFILE#" where sqlfile.sql is the sql filename and #SQLFILE# is the parameter which contains the path of the sqlfile.

When i execute, i am getting the below error.

"Can not open the file that contains the SQL statement".

Can someone point out as what iam doing wrong.

Thanks !! Cheers!!
Datastage Developer cum ETL designer.
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

Put the path before the file name.
Choose a job you love, and you will never have to work a day in your life. - Confucius
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Right, you seem to have the two parts backwards.
-craig

"You can never have too many knives" -- Logan Nine Fingers
MrBlack
Participant
Posts: 125
Joined: Wed Aug 08, 2012 8:57 am

Post by MrBlack »

Then just as a FYI, the OCI is deprecated and you'll want to get on the new Oracle Connector and migrate your old jobs to use this. We're experiencing some pain ourselves having delayed this code update and we're now being forced into updating before we can continue upgrading the environment.
Post Reply