Page 1 of 1
Load SQL from a file
Posted: Tue Oct 24, 2006 12:43 pm
by dasari
I am trying to use Load SQL from a file option in DSDB2 stage.
I gave the path name of the file. But for some reason DS is still expecting a SQL there and gives an error message "An unexpected token /xxx/xxx was found.
Thanks in advance for any information regarding this.
Posted: Tue Oct 24, 2006 1:15 pm
by DSguru2B
Welcome Aboard,
Specify the keyword {FILE} before giving the fully qualified path for the sql file. That should do the trick.
Thanks
Posted: Tue Oct 24, 2006 1:40 pm
by dasari
[quote="DSguru2B"]Welcome Aboard,
Specify the keyword {FILE} before giving the fully qualified path for the sql file. That should do the trick.[/quote]
I tried prefixing with {File} . I also tried File. I get the following message.
src_codetables_edw_codevalues..Copy_of_db2blU1IAA02_s: [IBM][CLI Driver] CLI0118E Invalid SQL syntax. SQLSTATE=37000
SQLExecDirect: Error executing statement '{File}/home/a136940/sqlstringU1IAA01'. See following DB2 message for details.
src_codetables_edw_codevalues..Copy_of_db2blU1IAA02_s.DSLink1: DSP.Open GCI $DSP.Open error -100.
Posted: Tue Oct 24, 2006 1:55 pm
by DSguru2B
This is right out of dsbooks -> Plugin Documentation -> DB2/UDB API Stage (page 14)
If the property value begins with {FILE}, the remaining text is
interpreted as a pathname, and the contents of the file supplies
the property value.
Provided you have 7.5.1A. If you have any other version then i am not too sure.