Mload не работает, несмотря на синтаксическую ошибку
Я вижу странную вещь в одной из самых тяжелых работ. Он не завершается ошибкой, несмотря на синтаксическую ошибку в коде. Между оператором отбрасывания и словом 'TELE_PHONE_UV1' отсутствует точка с запятой. Пожалуйста, проверьте фрагмент журнала в последней части. Это же задание при выполнении вручную завершается с ошибкой без нулевой код возврата. Ниже работа и журнал:
BEGIN TRANSACTION;
**** 20:20:18 UTY0817 MultiLoad submitting the following request:
INS DP_LOG.TELE_PHONE_LOG1 (LogType, Seq, MLoadSeq)VALUES(125, 1,
3)
**** 20:20:18 UTY0817 MultiLoad submitting the following request:
DROP TABLE DP_WRK.TELE_PHONE_WRK1;
**** 20:20:18 UTY0817 MultiLoad submitting the following request:
END TRANSACTION;
**** 20:20:19 UTY0817 MultiLoad submitting the following request:
SELECT CAST(COUNT(*) AS BIGINT) FROM DP_LOG.TELE_PHONE_ERR2;
**** 20:20:19 UTY0821 Error table DP_LOG.TELE_PHONE_ERR2 is EMPTY,
dropping table.
**** 20:20:19 UTY0817 MultiLoad submitting the following request:
BEGIN TRANSACTION;
**** 20:20:19 UTY0817 MultiLoad submitting the following request:
INS DP_LOG.TELE_PHONE_LOG1 (LogType, Seq, MLoadSeq)VALUES(125, 1,
4)
**** 20:20:19 UTY0817 MultiLoad submitting the following request:
DROP TABLE DP_LOG.TELE_PHONE_ERR2;
**** 20:20:22 UTY0817 MultiLoad submitting the following request:
END TRANSACTION;
**** 20:20:22 UTY0817 MultiLoad submitting the following request:
SELECT CAST(COUNT(*) AS BIGINT) FROM DP_LOG.TELE_PHONE_UV2;
**** 20:20:22 UTY0821 Error table DP_LOG.TELE_PHONE_UV2 is EMPTY,
dropping table.
**** 20:20:22 UTY0817 MultiLoad submitting the following request:
BEGIN TRANSACTION;
**** 20:20:22 UTY0817 MultiLoad submitting the following request:
INS DP_LOG.TELE_PHONE_LOG1 (LogType, Seq, MLoadSeq)VALUES(125, 1,
5)
**** 20:20:22 UTY0817 MultiLoad submitting the following request:
DROP TABLE DP_LOG.TELE_PHONE_UV2;
**** 20:20:23 UTY0817 MultiLoad submitting the following request:
END TRANSACTION;
**** 20:20:23 UTY0817 MultiLoad submitting the following request:
BEGIN TRANSACTION;
**** 20:20:23 UTY0817 MultiLoad submitting the following request:
INS DP_LOG.TELE_PHONE_LOG1 (LogType, Seq, MLoadSeq)VALUES(125, 1,
6)
**** 20:20:23 UTY0817 MultiLoad submitting the following request:
DROP TABLE DP_WRK.TL_NM_PRT_EVNT_DUP_WK;
**** 20:20:24 UTY0817 MultiLoad submitting the following request:
END TRANSACTION;
**** 20:20:24 UTY0825 Error table statistics for:
Target table 1: DP_TAB.TELE_PHONE
Number of Rows Error Table Name
==================== ==================================================
0 DP_LOG.TELE_PHONE_ERR1
0 DP_LOG.TELE_PHONE_UV1
Target table 2: DP_DUP.TELE_PHONE
Number of Rows Error Table Name
==================== ==================================================
0 DP_LOG.TELE_PHONE_ERR2
0 DP_LOG.TELE_PHONE_UV2
**** 20:20:24 UTY0817 MultiLoad submitting the following request:
BEGIN TRANSACTION;
**** 20:20:24 UTY0817 MultiLoad submitting the following request:
USING Ckpt(VARBYTE(1024)) INS DP_LOG.TELE_PHONE_LOG1 (LogType, Seq,
MLoadCkpt)VALUES(140, 1, :Ckpt);
**** 20:20:24 UTY0817 MultiLoad submitting the following request:
INS DP_LOG.TELE_PHONE_LOG1 (LogType, Seq) VALUES (125, 1)
**** 20:20:24 UTY0817 MultiLoad submitting the following request:
END TRANSACTION;
**** 20:20:25 UTY0822 MultiLoad processing complete for this MultiLoad import
task.
========================================================================
= =
= MultiLoad Task Complete =
= =
========================================================================
**** 20:20:26 UTY1024 Session modal request, 'SET
QUERY_BAND='UTILITYNAME=MULTLOAD;' UPDATE FOR SESSION;', re-executed.
========================================================================
= =
= Processing Control Statements =
= =
========================================================================
0030 Insert into DP_ERR.TELE_PHONE1
SELECT
ErrorCode,
ErrorField,
Current_timestamp(0)
FROM
DP_LOG.TELE_PHONE1
;
**** 20:20:26 UTY1008 RDBMS failure: 3807, Object 'DP_LOG.TELE_PHONE1'
does not exist.
0031 Drop table DP_LOG.TELE_PHONE_ERR1;
**** 20:20:26 UTY1008 RDBMS failure: 3807, Object
'DP_LOG.TELE_PHONE_ERR1' does not exist.
0032 Insert into DP_ERR.TELE_PHONE2
SELECT
Channel_Party_Start_Tm
,Event_Id
,Port_Request_Num
,Port_Record_Num
,Tel_Num_Port_Type_Cd
,Processing_Agent_Party_Id
,Channel_Id ,Party_Id
,Channel_Party_Start_Dt
,Channel_Party_Role_Cd
,Event_Info_Source_Type_Cd
,PORT_REQUEST_COMPLETION_DTTM
,REQUESTOR_ID_NUM
,REQUESTOR_ID_TYPE
,CONNECTION_SERVICE_TYPE
,DATA_SOURCE_TYPE_CD
,DBCErrorCode
,Ctimestamp
,ErrorFieldName
FROM
DP_LOG.TELE_PHONE_UV1
drop table DP_LOG.TELE_PHONE_ERR1
;
**** 20:20:26 UTY1008 RDBMS failure: 3707, Syntax error, expected something like
';' between the word 'TELE_PHONE_UV1' and the 'drop' keyword.*
0033 drop table DP_LOG.TELE_PHONE_UV1 ;
**** 20:20:26 UTY1008 RDBMS failure: 3807, Object
'DP_LOG.TELE_PHONE_UV1' does not exist.
0034 drop table DP_LOG.TELE_PHONE_ERR2 ;
**** 20:20:26 UTY1008 RDBMS failure: 3807, Object
'DP_LOG.TELE_PHONE_ERR2' does not exist.
0035 drop table DP_LOG.TELE_PHONE_UV2 ;
**** 20:20:26 UTY1008 RDBMS failure: 3807, Object
'DP_LOG.TELE_PHONE_UV2' does not exist.
0036 .logoff;
========================================================================
= =
= Logoff/Disconnect =
= =
========================================================================
**** 20:20:29 UTY6216 The restart log table has been dropped.
**** 20:20:29 UTY6212 A successful disconnect was made from the RDBMS.
**** 20:20:29 UTY2410 Total processor time used = '2.03 Seconds'
. Start : 20:19:50 - TUE SEP 12, 2017
. End : 20:20:29 - TUE SEP 12, 2017
. Highest return code encountered = '0'.
Это из-за каких-то экологических условий?
Спасибо амит