can we invoke bteq script from mload script
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
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 bteq script from mload script Expand / Collapse
Author
Message
Posted 5/25/2006 5:34:55 AM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 1/25/2007 11:21:00 AM
Posts: 25, Visits: 1
I need to run a bteq/stored procedure script from a a mload script..I know i can use the .SYSTEM command to run a os command..

My Requirement :

Actually Mload application error table is creating problem for us. I am using mload script to load data. If the error table is created by mload with any reason such duplicate rows, etc..And when the job runs next time it fails the job because of the existance of this error table.

Please let me know can we force mload script to check the existance of Application error table in the same script and signal a message or something like that. I think it checks in the next run whether there is any Application error table exists or not.

I deeply appreciate your assistance.
Post #4240
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
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 3:35am

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.047. 7 queries. Compression Disabled.