Initiating a unix script
Moderators: chulett, rschirm, roy
Initiating a unix script
This question goes along with the e-mail from RStone posted March 3, 2005. Is there a way for Datastage to communicate with Unix to initiate a script?
Re: Initiating a unix script
Read about\search for DSExecute in help pdfs or this forum. There are other ways too, but this is a good starting point.
- Sachin
- Sachin
DawnT wrote:This question goes along with the e-mail from RStone posted March 3, 2005. Is there a way for Datastage to communicate with Unix to initiate a script?
Re: Initiating a unix script
Yes. There are a number of methods that you could use (before job, after job, ExecSH, execute command, et cetera) to call scripts.DawnT wrote:This question goes along with the e-mail from RStone posted March 3, 2005. Is there a way for Datastage to communicate with Unix to initiate a script?
Please feel free to use the search tool to find out more about what I mentioned above, or scan your pdf manuals.
We can be much more helpful if you can be a bit more specific on what you need to have done.
Initiating or calling a shell script
I need to have the "set integrity" script run. To initiate or call a shell script in Datastage, would I have to have DBA privilege to do this?
Hi,
ask your DBAs about required privilages for the script (it depend on what it runs and who better then them to ask?.
you got some good answers regarding invoking an OS command from with in DS.
on top of them, basicly you can run the script with a user having the required privilages, or have sysadins make the script run as a user having them and so on; on top of that if you need some sql run you can do it directly via the user defined sql or stored procedure stage and so on.
IHTH,
ask your DBAs about required privilages for the script (it depend on what it runs and who better then them to ask?.
you got some good answers regarding invoking an OS command from with in DS.
on top of them, basicly you can run the script with a user having the required privilages, or have sysadins make the script run as a user having them and so on; on top of that if you need some sql run you can do it directly via the user defined sql or stored procedure stage and so on.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
-
- Participant
- Posts: 75
- Joined: Tue May 13, 2003 4:14 am
- Location: California
- Contact:
IMHO:gh_amitava wrote:T42,
Please try to give your answer politely. Somebody may ask some basic question and if you have problem with those, then simply avoid them.
:D
Regards
~Amitava
I don't think T42 ment anything offending there, just some simple facts which obviously were interpreted by you as not polite.
In any case messages like theese are best sent as a private message not a post.
(hmm does this mean I should have sent this via a private message not a post?! - yes it does if ou get my drift )
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
-
- Participant
- Posts: 34
- Joined: Tue Jan 30, 2007 6:13 pm
- Location: Central Florida
Here is the issue:
DataStage allows you to run the DB2 LOAD command with full knowledge that tables can go into a check pending state because of the command. Yet, apparently DataStage does not provide a solution to this common issue. There should be a simple method of running a set integrity command without having to jump through any hoops.
If a job has the authority to load a table, then it has the authority to process a set integrity command against that table. If other tables are involved, then it is a matter of giving the user permissions to run the command.
To have to go outside of DataStage to provide this basic database functionality seems out of line to me (being a DBA). There is a hole in the product that needs to be fixed.
DataStage allows you to run the DB2 LOAD command with full knowledge that tables can go into a check pending state because of the command. Yet, apparently DataStage does not provide a solution to this common issue. There should be a simple method of running a set integrity command without having to jump through any hoops.
If a job has the authority to load a table, then it has the authority to process a set integrity command against that table. If other tables are involved, then it is a matter of giving the user permissions to run the command.
To have to go outside of DataStage to provide this basic database functionality seems out of line to me (being a DBA). There is a hole in the product that needs to be fixed.
Doug
AAA Auto Club Group
Listen to:
Porcupine Tree
Nosound
Days Between Stations
AAA Auto Club Group
Listen to:
Porcupine Tree
Nosound
Days Between Stations
-
- Participant
- Posts: 15
- Joined: Tue Nov 21, 2006 3:45 am
- Location: WhiteField, Bangalore
-
- Participant
- Posts: 34
- Joined: Tue Jan 30, 2007 6:13 pm
- Location: Central Florida
Set Integrity
Added to the wish list. Tanks for pointing that out - I adminster the Ascential product line but don't develop DataStage jobs, so I am rarely in here. I design, implement, and maintain databases - and help the DS Developers.
Doug
AAA Auto Club Group
Listen to:
Porcupine Tree
Nosound
Days Between Stations
AAA Auto Club Group
Listen to:
Porcupine Tree
Nosound
Days Between Stations
-
- Participant
- Posts: 15
- Joined: Tue Nov 21, 2006 3:45 am
- Location: WhiteField, Bangalore