DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
sam paul



Group memberships:
Premium Members

Joined: 26 Jan 2009
Posts: 19
Location: Minneapolis, USA
Points: 185

Post Posted: Wed Mar 16, 2016 2:46 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Server
OS: Unix
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



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2786
Location: USA
Points: 21018

Post Posted: Wed Mar 16, 2016 6:43 am Reply with quote    Back to top    

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
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42613
Location: Denver, CO
Points: 219385

Post Posted: Wed Mar 16, 2016 7:09 am Reply with quote    Back to top    

Right, you seem to have the two parts backwards.

_________________
-craig

And I'm hovering like a fly, waiting for the windshield on the freeway...
Rate this response:  
Not yet rated
MrBlack
Participant



Joined: 08 Aug 2012
Posts: 125

Points: 1546

Post Posted: Thu Mar 24, 2016 11:01 am Reply with quote    Back to top    

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.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours