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!!
Load SQL from file at run-time
Moderators: chulett, rschirm, roy
Load SQL from file at run-time
Datastage Developer cum ETL designer.