|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/29/2007 11:08:21 PM
Posts: 6,
Visits: 2
|
|
Hi,
Can we call bteq script in mload script.
Please advice. Thanks
|
|
|
|
|
Forum Guru
Group: Forum Members
Last Login: 5/30/2008 6:49:12 AM
Posts: 57,
Visits: 2
|
|
Hi,
It is not possible to call a BTEQ script from within an MLoad script. What specifically are you trying to do here? If i understand you correctly, you are trying to use conditional flow control. If that is what you are trying, then it is not possible from within MLoad scripting. On the other hand, if you want features like flow control, then use BTEQ itself as the loading tool and you can branch to other section of scripts correspondingly based on your requirements.
Strive to success. Arun.
|
|
|
|
|
Supreme Being
Group: PAC and SFT Members
Last Login: Today @ 6:11:07 PM
Posts: 331,
Visits: 533
|
|
|
At least in a network attached environment you can use .SYSTEM to invoke any command line including BTEQ or something that calls BTEQ. On the mainframe you'd probably have to write your own "shell" program that could be called by .SYSTEM and would then call BTEQ. But why bother when you can check for errors directly within MLOAD's support environment?
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 10/7/2008 6:20:30 PM
Posts: 136,
Visits: 11
|
|
you can use .OS command MLOAD utility within a BTEQ.
You will have to ensure that MLOAD executable path is set.
Here's a sample
.LOGON TDPID/UID,*****;
.export report file = rep.txt;
select * from DBC.COLUMNS SAMPLE 10;
.os mload < mload.txt;
.export reset;
.logoff;
.quit;
Hope this helps.
Vinay
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/29/2007 11:08:21 PM
Posts: 6,
Visits: 2
|
|
Yes, I did it with the same way..
Thanks for your response..
Regards
|
|
|
|