For tables going into QTEMP, I would have an empty version (along with any needed indexes) in the appropriate file library and do a CRTDUPOBJ if it didn't already exist in QTEMP.
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark Murphy/STAR BASE Consulting Inc.
Sent: Friday, November 6, 2015 3:40 PM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries <wdsci-l@xxxxxxxxxxxx>
Subject: Re: [WDSCI-L] Compiling SQLRPGLE programs in RDi
I knew that SQL would compile without definitions, but LikeRec? I expect that to fail.
Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx
-----Matthew Qualls <MQualls@xxxxxxxxxxxxxxx> wrote: -----
To: "Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries" <wdsci-l@xxxxxxxxxxxx>
From: Matthew Qualls <MQualls@xxxxxxxxxxxxxxx>
Date: 11/06/2015 03:32PM
Subject: Re: [WDSCI-L] Compiling SQLRPGLE programs in RDi
Jon,
I had the same concerns, but noticed that I was only getting warnings on my compiles. It will create the program, but won't verify the columns in the tables.
HTH,
Matt Qualls
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Jon Paris
Sent: Thursday, November 5, 2015 5:36 PM
To: Wdsci-L <wdsci-l@xxxxxxxxxxxx>
Subject: [WDSCI-L] Compiling SQLRPGLE programs in RDi
This is a first for me so I’m hoping someone else has experienced this.
I have a number of SQLRPGLE programs that utilize tables in QTEMP. Compiling them in the green screen is OK because I can create the tables as needed. Not quite so simple to create them in the RDi server job though.
I can think of a number of possible solutions but figured I’d see if anyone else has experienced this. And if so, how do you handle it?
Jon Paris
www.partner400.com
www.SystemiDeveloper.com
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
midrange.com
