|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/29/2007 11:08:21 PM
Posts: 6,
Visits: 2
|
|
Hi,
I have requirement - signal a pager if there is any "Aplication Error Table"(mload "Aplication Error Table" say E2 table) created by mload script. Can we force mload to check the E2 table that is created by it in case of any error occured during application phase,... please advice... I express my thanks in anticipation of your prompt reply.
Regards,
meet_as
|
|
|
|
|
Forum Guru
Group: Forum Members
Last Login: 5/30/2008 6:49:12 AM
Posts: 57,
Visits: 2
|
|
Hi,
If you are trying to perform a check on the Application Error table, then it is not possible to fire a BTEQ script from within a Multi Load script. Alternatively, you can schedule the BTEQ immediately after the Multi Load and check the application error table for error qualifiers and loop in the script for appropriate action items. You can use the UNIX environment to fire action items on request from within BTEQ.
Strive to success. Arun.
|
|
|
|
|
Supreme Being
Group: PAC and SFT Members
Last Login: Today @ 6:11:07 PM
Posts: 331,
Visits: 533
|
|
|
Certainly. Use .IF statements testing built-in variables such as &SYSETCNT1 to check for rows in the error table, and use .SYSTEM to execute some external command to send the page. See the manual for details.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/29/2007 11:08:21 PM
Posts: 6,
Visits: 2
|
|
yes, I have already completed this. I did it like this--
.IF &SYSUVCNT1 > 0 THEN;
.SYSTEM 'c:\Paging.pl any_argument';
.ENDIF;
Its better if we place the above statement after the .END MLOAD Command.
also, take care this 'c:\Paging.pl any_argument' is string. You can pass any argument.
Regards,
Ajit
|
|
|
|