Re: MCH0601 on SQL Insert

[CRPence <CRPbottle@xxxxxxxxx>]

  A cursor opened and fetches logged?  Those messages do not seem 
to apply to the code that is shown in the quoted message; i.e. the 
INSERT INTO SELECT FROM statement does not implement as a cursor 
from which a FETCH statement would be performed.

  Also, a copy\paste of joblog messages from an interactive joblog 
omits significant amount of details.  Although we know the error is 
MCH0601 [because it is both stated and the message text matches], 
the other message details are missing.  Sure we can see that the 
error condition is for writing past a limit on a variable in the 
automatic storage or adjusting a pointer outside its limit in job 
336523/APALHC/MSRL3G343, but we have no idea what program.  Knowing 
for instance, if the program name were a trigger program or a 
program that is different than the one expect, would probably help 
the programmer better able to see what is wrong... but it also helps 
someone else ask better questions or better infer a cause if perhaps 
the program were an OS program name.

Regards, Chuck

hockchai Lim wrote:
> I'm getting a MCH0601 error on a sql insert statement. Does
> anybody know  what I did wrong?
> Below is the clip of my code:
>  exec sql
>     drop table QTEMP/SVEMLTMP;
>  exec sql
>     create table QTEMP/SVEMLTMP
>        (TEXT VARCHAR (1000 ) NOT NULL WITH DEFAULT);
>
>  //copy the EMAILMSG member to a temp work file
>  //-------------------------------------------------------
>  myCmd = 'OVRDBF FILE(EMAILMSG) TOFILE(EMAILMSG) MBR(' +
>          %trim(piMbr) + ') OVRSCOPE(*CALLLVL)';
>  qcmdexc(myCmd :%len(%trimr(myCmd)));
>  exec sql insert into QTEMP/SVEMLTMP
>                select rtrim(SRCDTA) FROM EMAILMSG;
>
>
> Below is the error I see in joblog when running in DEBUG mode.
> Cursor SQLCURSOR000000003 opened.
> 1 rows fetched from cursor SQLCURSOR000000003.
> 1 rows fetched from cursor SQLCURSOR000000003.
> 1 rows fetched from cursor SQLCURSOR000000003.
> 1 rows fetched from cursor SQLCURSOR000000003.
> 1 rows fetched from cursor SQLCURSOR000000003.
> Space offset X'0003F1D3' or X'0000000000000000' is outside
> current limit for object MSRL3G343APALHC     336523.
> Space offset X'0003F1D2' or X'0000000000000000' is outside
> current limit for object MSRL3G343APALHC     336523.
> Space offset X'FFFFEF37' or X'0000000000000000' is outside
> current limit for object MSRL3G343APALHC     336523.
> 1 rows fetched from cursor SQLCURSOR000000003.
> <<SNIP three mch0601 & 1 rows fetched>>
> Space offset X'0003B3D6' or X'0000000000000000' is outside
> current limit