subquery from file in oci stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 41
- Joined: Sun Mar 09, 2008 8:12 pm
subquery from file in oci stage
Hi,
I want to run the following query in OCI stage.
select a1.idx,a1.namex,a1.creationdatex,a1.specialhandlingx,
a1.CONFIDENTIALX,b.codex from accountjdox a1,
brokeragencyjdox b
where a1.defaultbroker_fkx=b.idx and a1.idx in(#Dir#/Accountfile.txt)
I opt for read sql query from file as NO.
I have query to select Accountnumbers in Accountfile which is in UNIX and it will change frequenty.
when I test for it it is giving the error - missing expression.
Could somebody please help
Thanks,
Sridhar
I want to run the following query in OCI stage.
select a1.idx,a1.namex,a1.creationdatex,a1.specialhandlingx,
a1.CONFIDENTIALX,b.codex from accountjdox a1,
brokeragencyjdox b
where a1.defaultbroker_fkx=b.idx and a1.idx in(#Dir#/Accountfile.txt)
I opt for read sql query from file as NO.
I have query to select Accountnumbers in Accountfile which is in UNIX and it will change frequenty.
when I test for it it is giving the error - missing expression.
Could somebody please help
Thanks,
Sridhar
k.v.sreedhar
In cases like this the only way to get a good answer is to cut-and-paste the entire error message, those two words "missing expression" aren't quite enough information.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 41
- Joined: Sun Mar 09, 2008 8:12 pm
Yes, you are - hence my answer.bobbysridhar wrote:I am not using parameter in file.
Code: Select all
in(#Dir#/Accountfile.txt)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 41
- Joined: Sun Mar 09, 2008 8:12 pm
Then back to my request for the full error message.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 41
- Joined: Sun Mar 09, 2008 8:12 pm
-
- Premium Member
- Posts: 41
- Joined: Sun Mar 09, 2008 8:12 pm
As I said, pass it in as a job parameter. Use something in a Sequence job to read the file and craft the string that needs to be passed - a routine can be used or it may be as simple as an Execute Command stage that does a 'cat' and passes the result to the parameter. All depends on the structure of the data in the file.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers