Re: REXX here we go

[Pete Helgren <Pete@xxxxxxxxxx>]

David,

I am not a REXX programmer but the message may be eliminated by setting 
commitment control to *NONE  but I am unfamiliar with how to do that in 
REXX.

Pete


David FOXWELL wrote:
> Hi Joe,
>
> I'm just doing a DSPMSGD RANGE(SQL7008) MSGF(QSQLMSG). The code reason is 3 which tells me the file isn't journalised, etc.
>
> -----Message d'origine-----
> De : midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Joe Pluta
> Envoyé : lundi 21 avril 2008 15:55
> À : Midrange Systems Technical Discussion
> Objet : Re: REXX here we go
>
> David FOXWELL wrote:
>   
> > I probably should never have read Joe's introduction to REXX, as it's been there longer than me and I've got by up till now without it. But I did and so now come the problems.
> >
> > What's wrong with my first ever REXX procedure ? :
> >
> >
> > ADDRESS EXECSQL,
> >
> > "EXECSQL",
> >
> > " INSERT INTO QTEMP/ADHRBT ",
> >
> > " SELECT ADHRBT.* FROM ADHRBT JOIN PAFMT00 ON PA0COP =RRDTID ",
> >
> > " AND PA0TYP = 'INITIA' ORDER BY SUBSTR(PA0LIB, 68, 4)"
> >
> > IF RC < 0 THEN SAY SQLCODE
> >
> >
> >
> >
> >
> > I was getting SQLCODE -206 so I put up double quotes, now  I'm getting SQLCODE -7008.
> >
> > Have checked the corresponding SQL0206 and SQL7008 messages.
> >
> >     
> It sounds like you're getting there, David.  You fixed the -206 error, now you're trying to figure out the -7008 error.  What's the second-level text for the SQL7008 error?
>
> Joe
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.
>
>