RC in bteq

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

RC in bteq

Rate Topic

Display Mode

Topic Options

Author

Message

shanthuj

Posted 4/10/2008 9:53:46 AM

Junior Member

Group: Forum Members
Last Login: 6/26/2008 5:12:11 AM
Posts: 15, Visits: 24

Hi,

Is it possible to manually set a return code(RC) in a bteq.
I need to restart the JCL based on a condition like .IF ACTIVITYCOUNT<>0(present in my BTEQ script) then restart jcl else quit.
The JCL should be automatically restarted based on the activitycount. Is there any way to achieve it?

Any suggestions would be useful...

Thanks

Post #11198

Posted 4/25/2008 2:59:34 PM

Supreme Being

Group: Forum Members
Last Login: 11/23/2008 11:25:35 PM
Posts: 76, Visits: 148

hi,

you can set an error code based on the activitycount.

have the below stmt right after your DML stmt:

.IF ACTIVITYCOUNT<>0 THEN .QUIT 50;

this will make your parm and in turn your JOB STEP fail(i.e errorcode or returncode<>0) and you can have a condition stmt in your PROC STEP to restart from a STEP in the jcl by checking this return code in the PROC.

hope this helps!

-SN

Post #11306

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 4:09pm