Re: MCH0601 on SQL Insert

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