Re: Compiling SQLRPGLE programs in RDi

On Nov 6, 2015, at 4:38 PM, Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

For some reason I hadn’t thought of doing a CRTDUP… Matthew - that might actually be a better solution than keep creating them … hmmmm. Thanks for that thought.

On Nov 6, 2015, at 3:57 PM, Matthew Qualls <MQualls@xxxxxxxxxxxxxxx> wrote:

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&#8217;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&#8217;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.
--
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.

Jon Paris

www.partner400.com
www.SystemiDeveloper.com