Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett, rschirm, roy
-
daramanoj
- Participant
- Posts: 20
- Joined: Wed Jul 29, 2009 4:01 am
Post
by daramanoj »
Hi,
I have 2 procedures included in a package and i want to call a package from datastage.Can any one plz help me out.
Thanks in advance.
Manoj.
-
chulett
- Charter Member
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
Stored Procedure stage.
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
daramanoj
- Participant
- Posts: 20
- Joined: Wed Jul 29, 2009 4:01 am
Post
by daramanoj »
Are you sure that we can call a procedure inside a package from a stored procedure stage
Thanks ,
Manoj
-
chulett
- Charter Member
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
I don't see why not, a proc is a proc, package or otherwise. Have you tried it? Had issues? Have a more specific question?
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
daramanoj
- Participant
- Posts: 20
- Joined: Wed Jul 29, 2009 4:01 am
Post
by daramanoj »
normally when i want to call a procedure i will use before after tabs in the oci stage .
if the package name is xxx
and procedure name is yyy
i have tried calling like
call xxx.yyy();
but it is giving an error saying "invalid sql statement"
Thanks ,
Manoj
-
chulett
- Charter Member
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
Try without the semicolon. I have called packages from the SP stage without issue in the past, any reason not to use it?
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
arunkumarmm
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
-
Contact:
Post
by arunkumarmm »
We are using a lot of SP stage to call pakages and they just work fine. Never had any issues.
Arun
-
daramanoj
- Participant
- Posts: 20
- Joined: Wed Jul 29, 2009 4:01 am
Post
by daramanoj »
normally when i want to call a procedure i will use before after tabs in the oci stage .
if the package name is xxx
and procedure name is yyy
i have tried calling like
call xxx.yyy();
but it is giving an error saying "invalid sql statement"
Thanks ,
Manoj
-
chulett
- Charter Member
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
There seems to be an echo in here.
So, is this truly resolved or not? If so, can you share that resolution with us please?
-craig
"You can never have too many knives" -- Logan Nine Fingers