Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

capture BTQMAIN/FASTLOAD(teradata) return code in JCL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
v v vimal nair

New User


Joined: 27 Nov 2006
Posts: 4
Location: India

PostPosted: Tue Jan 13, 2009 7:50 pm    Post subject: capture BTQMAIN/FASTLOAD(teradata) return code in JCL
Reply with quote

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
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7997
Location: Bellevue, IA

PostPosted: Tue Jan 13, 2009 8:03 pm    Post subject:
Reply with quote

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
View user's profile Send private message
v v vimal nair

New User


Joined: 27 Nov 2006
Posts: 4
Location: India

PostPosted: Tue Jan 13, 2009 8:17 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7997
Location: Bellevue, IA

PostPosted: Tue Jan 13, 2009 8:23 pm    Post subject:
Reply with quote

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
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4648
Location: Raleigh, NC, USA

PostPosted: Tue Jan 13, 2009 8:27 pm    Post subject: Reply to: capture BTQMAIN/FASTLOAD(teradata) return code in
Reply with quote

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
View user's profile Send private message
v v vimal nair

New User


Joined: 27 Nov 2006
Posts: 4
Location: India

PostPosted: Tue Jan 13, 2009 8:32 pm    Post subject:
Reply with quote

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!!
icon_biggrin.gif
Back to top
View user's profile Send private message
v v vimal nair

New User


Joined: 27 Nov 2006
Posts: 4
Location: India

PostPosted: Tue Jan 13, 2009 8:40 pm    Post subject:
Reply with quote

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 icon_biggrin.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts CA Workload Automation event code help vinu78 CA Products 10 Wed Mar 01, 2017 10:05 am
No new posts MAX-RC 88 and Return code 606 in DFH0... lind sh CICS 2 Tue Jan 24, 2017 1:23 pm
No new posts How to Capture the Max return code of... anilkumar922 All Other Mainframe Topics 2 Thu Jan 12, 2017 12:02 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us