Can we invoke a BTEQ script from a BTEQ script?

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.

Can we invoke a BTEQ script from a BTEQ...

Rate Topic

Display Mode

Topic Options

Author

Message

atadaret

Posted 8/13/2008 12:05:35 AM

Forum Newbie

Group: Forum Members
Last Login: 8/17/2008 6:46:55 PM
Posts: 9, Visits: 14

Can we invoke a BTEQ script from a BTEQ script?

Thanks,
atadaret

Post #12563

Adeel.Chaudhry

Posted 8/13/2008 12:17:11 AM

Supreme Being

Group: Forum Members
Last Login: Today @ 7:30:07 AM
Posts: 197, Visits: 611

Hello,

Yes you can using ".RUN FILE = ;". Following is an example:

Script-1: "S1.bteq"

.LOGON dbc,dbc;

SELECT DATABASE;

.RUN FILE = S2.bteq;

.LOGOFF;

Script-2: "S2.bteq"

Script-1: "S1.bteq"

.LOGON dbc,dbc;

SELECT * FROM Table1;

.LOGOFF;

HTH.

Regards,

Adeel

Post #12564

atadaret

Posted 8/13/2008 12:51:21 AM

Forum Newbie

Group: Forum Members
Last Login: 8/17/2008 6:46:55 PM
Posts: 9, Visits: 14

Thanks for the quick response

Thanks,
atadaret

Post #12565

Jim Chapman

Posted 8/14/2008 2:15:16 PM

Supreme Being

Group: Forum Members
Last Login: 2 days ago @ 3:54:26 PM
Posts: 225, Visits: 541

In addition to .RUN, you can use the .OS command to execute bteq or any other shell command. For example:

.os bteq < my_bteq_script

.os arcmain < my_archive_script

Post #12602

« 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 11:21pm