Re: REXX here we go

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

Can you just add the 'WITH NC' clause to the INSERT statement?

On Mon, Apr 21, 2008 at 10:44 AM, Pete Helgren <Pete@xxxxxxxxxx> wrote:
> 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.
>  >
>  >
>  --
>  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.