Passing null while importing storedprocedure

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
ajithaselvan
Participant
Posts: 75
Joined: Mon Jul 12, 2010 4:11 am
Location: Chennai

Passing null while importing storedprocedure

Post by ajithaselvan »

Hi experts,
I'm trying to import SQL server stored procedure. I dont have any input parameters but I have 7 output parameters. All are NVarchar datatype.
While importing, it is asking for Arguments list. I need to assign null as default values for above parameters.
How can I pass it while importing?


Regards
Ajitha S
ajithaselvan
Participant
Posts: 75
Joined: Mon Jul 12, 2010 4:11 am
Location: Chennai

Re: Passing null while importing storedprocedure

Post by ajithaselvan »

Can anybody help me?

Regards
Ajitha S
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

On import it just wants metadata, to know what the arguments to the procedure are - there's no "assignment" as part of this process. All of the assignment action happens when you call the procedure.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply