Hi
I did some googling and searched this forum as well, but couldn't find it.
I'm trying to execute multiple sql's in oracle stage using the "Load SQL from file at run time"
option, seperating each sql with a ";" , but datastage is taking all the sql as a
single SQL and trying to run and its getting aborted, is there
any way i can use multiple sql in the "Load SQL from file at run time" option.
cheers
MJ
Multiple SQL in "Load SQL from file at run time"
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 139
- Joined: Fri Apr 11, 2008 1:02 pm
-
- Premium Member
- Posts: 139
- Joined: Fri Apr 11, 2008 1:02 pm
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
These must be source SQLs, as in ones that provide data to the job so I'm assuming they are not appropriate for using before/after. If you don't want to go the 'union' route then perhaps the job can be 'looped' via a Sequence job that replaces the sql file each iteration.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 139
- Joined: Fri Apr 11, 2008 1:02 pm
Hi thanks for responding..
the queries are dynamically generated... and i want to use those data in the job.
I think by somehow i have to generate the columns of the sql queris as a single concatenated columns and separate them with commas andand as craig said i should then union them all, before passing it to the sequential files
the queries are dynamically generated... and i want to use those data in the job.
I think by somehow i have to generate the columns of the sql queris as a single concatenated columns and separate them with commas andand as craig said i should then union them all, before passing it to the sequential files
-
- Participant
- Posts: 34
- Joined: Tue Feb 26, 2013 9:36 am
- Location: Chicago