can you explain me how to call shell script in datastagejob

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
siva.k82
Participant
Posts: 7
Joined: Thu Sep 14, 2006 10:57 pm
Location: marthalli
Contact:

can you explain me how to call shell script in datastagejob

Post by siva.k82 »

can you provide the details of shell scripting how to call datastage job
sivaram
kunal1101
Participant
Posts: 8
Joined: Mon Dec 03, 2007 11:50 pm
Location: Pune

Post by kunal1101 »

You can use before job/after job subroutine in job properties to call shell script.Scroll down to 'ExecSH' and input your command in 'input value'
Kunal_devil!!!
kunal1101
Participant
Posts: 8
Joined: Mon Dec 03, 2007 11:50 pm
Location: Pune

Post by kunal1101 »

The other option is using execute command activity in sequence.
Kunal_devil!!!
swapnilverma
Participant
Posts: 135
Joined: Tue Aug 14, 2007 4:27 am
Location: Mumbai

Re: can you explain me how to call shell script in datastag

Post by swapnilverma »

siva.k82 wrote:can you provide the details of shell scripting how to
call datastage job
You can use after/before job script as indecated by Kunal.
In case you are preparing the input file of script in the ds job itself and requires the o/p file of script to use in ds job you can have after/before STAGE job script.

Hope it helps...

:idea:
Thanks
Swapnil

"Whenever you find whole world against you just turn around and Lead the world"
siva.k82
Participant
Posts: 7
Joined: Thu Sep 14, 2006 10:57 pm
Location: marthalli
Contact:

Post by siva.k82 »

kunal1101 wrote:You can use before job/after job subroutine in job properties to call shell script.Scroll down to 'ExecSH' and input your command in 'input value'
Thanks a ton
sivaram
siva.k82
Participant
Posts: 7
Joined: Thu Sep 14, 2006 10:57 pm
Location: marthalli
Contact:

Re: can you explain me how to call shell script in datastag

Post by siva.k82 »

Thanks for sharing knowledge
swapnilverma wrote:
siva.k82 wrote:can you provide the details of shell scripting how to
call datastage job
You can use after/before job script as indecated by Kunal.
In case you are preparing the input file of script in the ds job itself and requires the o/p file of script to use in ds job you can have after/before STAGE job script.

Hope it helps...

:idea:
sivaram
jdmiceli
Premium Member
Premium Member
Posts: 309
Joined: Wed Feb 22, 2006 10:03 am
Location: Urbandale, IA

Post by jdmiceli »

Also, just FYI in case you don't already know this:

You can reference DataStage parameters when calling the shell scripts. So, if you needed to pass job specific information to the script, you can reference parameters just like elsewhere in the job (standard #param# notation).

Hope that helps!
Bestest!

John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services


"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
jdmiceli
Premium Member
Premium Member
Posts: 309
Joined: Wed Feb 22, 2006 10:03 am
Location: Urbandale, IA

Post by jdmiceli »

Also, just FYI in case you don't already know this:

You can reference DataStage parameters when calling the shell scripts. So, if you needed to pass job specific information to the script, you can reference parameters just like elsewhere in the job (standard #param# notation).

Hope that helps!
Bestest!

John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services


"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
Post Reply