|
View previous topic :: View next topic
|
| Author |
Message |
v v vimal nair
New User
Joined: 27 Nov 2006
Posts: 4
Location: India
|
|
|
|
Hi every body,
New Year Greetings!!
i want to know is there any way in JCL by which we can capture or track the any return codes or failure in execution of BTQMAIN or FASTLOAD on teradata base through JCL.
i.e. how to abend a JCL if any operation on teradata fails or any error occurs during the process.
I tried to search about this, however couldn't find much on topics related to teradata.
Apologize if i break any rules and regulation of this forum.
Thanks in advance!! |
|
| Back to top |
|
 |
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8697
Location: Dubuque, Iowa, USA
|
|
|
|
| Quote: |
i.e. how to abend a JCL if any operation on teradata fails or any error occurs during the process. |
How would this work? JCL does nothing but execute programs. You would have to create the JCL to run a program that monitors the processes and sets an abend code where necessary. What would be the communication method? What does the API look like? Will you have to write this program or are you planning on using an existing program? |
|
| Back to top |
|
|
v v vimal nair
New User
Joined: 27 Nov 2006
Posts: 4
Location: India
|
|
|
|
Robert,
Yes that's true that we use JCL to execute programs, however my intention was to know if is there any IBM utility or program if any which can help here. |
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8697
Location: Dubuque, Iowa, USA
|
|
|
|
| Wouldn't it make more sense to check with Teradata? IBM utilities and programs generally tend to run on the mainframe and while they can interact with external data sources and sinks (via FTP and SMTP for example) for which there's defined interfaces, the utilities process mainframe data. |
|
| Back to top |
|
|
superk
Global Moderator
Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA
|
|
|
|
| This previous topic deals with a similar issue of trapping the return codes of specific job steps as the job is running. |
|
| Back to top |
|
|
v v vimal nair
New User
Joined: 27 Nov 2006
Posts: 4
Location: India
|
|
|
|
Robert,
Thanks for your prompt reply.
I have this on mainframes i have a batch job interacting with TERADATA database and its working fine however i was trying to do this as the JOB will complete successfully without any abend even if some thing goes wrong while process(upload data etc.) to teradata.
Meanwhile i am trying to find out from teradata side however i am getting information related to unix and teradata nothing relevant to mainframe side.
There are some other alternatives which i was thinking like having a rexx code to capture spool data and check for the same, however was looking for something if its available to use and try.
any ways thanks a lot for your help.
cheers!!
 |
|
| Back to top |
|
|
v v vimal nair
New User
Joined: 27 Nov 2006
Posts: 4
Location: India
|
|
|
|
Hi Kevin (superK),
Nice to see your reply, as i have read many of your posts/replies.
Thanks very much, your link seems to be very useful as that is something i am going to try.
Thanks again |
|
| Back to top |
|
|
|
|
