hi I am calling script A from routine
content of Sript A
bteq <<EOF>
.logon uDFGFD/GFG,hkj;
Select Date;
.exit
EOF
Script connects to teradata and execute the query
Routine command is Call DSExecute('UNIX',Script A,Output,Error)
My Question is will Output will contain Only result of Select Date or complete result with messages also and how can I capture status of only SQL statement in routine.
Accessing Teradata from Routine
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Try it first to answer your first question.
If what you want to happen actually happens, then you will have nothing else to do.
Otherwise you may have a minor parsing task to undertake.
Either way, it can be done.
If what you want to happen actually happens, then you will have nothing else to do.
Otherwise you may have a minor parsing task to undertake.
Either way, it can be done.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 26
- Joined: Tue Dec 18, 2007 6:31 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I don't believe U is working on a site where they have Teradata. Therefore it is unlikely that U will be able to tell you how to achieve this.
The second person personal pronoun in English is spelled "you", not "u". Please strive for a professional standard of written English on DSXchange, to help those whose first language is not English.
The second person personal pronoun in English is spelled "you", not "u". Please strive for a professional standard of written English on DSXchange, to help those whose first language is not English.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ray.wurlod wrote:I don't believe U is working on a site where they have Teradata. Therefore it is unlikely that U will be able to tell you how to achieve this.
The second person personal pronoun in English is spelled "you", not "u". Please strive for a professional standard of written English on DSXchange, to help those whose first language is not English.
![Laughing :lol:](./images/smilies/icon_lol.gif)
the thing actually not related with teradata, it is universal issue, how to capture error and output in datastage route
this bother me long time, I search forum everywhere, no answer until I read datastage help documents。
in documents, it say, datastage don't check the status in the routine, but if it is a before routine, it would fail datastage job when before routine fail
so solution,
1.put your shell script in before routine, log into log file
2.modify routine, let it check the status, open default after routine in manager
kdkboy