RE: EXTNAME(DSPF) and SQLRPGLE

You beat me to it.  Thanks Matt.   You are right that it is
a small bit of text.  On v5r3 and v5r4, the precompile should
only fail if you had tried to use the data structure or
subfields of the data structure in an SQL statement.  Although
the failure wouldn't have been as descriptive as saying the
third parameter is not supported. I haven't looked at what
was going on with it in v5r2.  I'm waiting on the
recreates from Rob.


Since I'm writing to the list, I thought that I should mention
that I am going to be starting a year leave of absence starting
in about 5 weeks.

Thanks,
Gina

----------------------------------
Fri, 24 Feb 2006 08:51:17 -0700
from: "Tyler, Matt" <mattt@xxxxxxxxxxxxxx>
subject: RE: EXTNAME(DSPF) and SQLRPGLE

Sorry I forgot that part. Look on page 98 of the PDF version of the book
for V5.4. or at this link
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/r
zajp/rzajpdeclaringrpg.htm

It would have been better to be titled "What not to use with Embedded
SQL".

Thanks, Matt



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Friday, February 24, 2006 8:33 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: EXTNAME(DSPF) and SQLRPGLE

Where did you find this limitation?  Link please.

Rob Berendt
--

Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Tyler, Matt" <mattt@xxxxxxxxxxxxxx>
Sent by: rpg400-l-bounces+rob=dekko.com@xxxxxxxxxxxx
02/24/2006 10:16 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
cc

Fax to

Subject
RE: EXTNAME(DSPF) and SQLRPGLE






Rob, thanks for taking the lead on this issue.

I did a search on book "Embedded SQL Programming" at all three versions
(5.2, 5.3 & 5.4) and only 5.2 does not mention this limitation.
However, I cannot see why I would have looked for this small bit of text
when using the EXTNAME() keyword.  The pre-compiler should state
explicitly that the third parameter is not supported when the compile
fails.


Thanks, Matt



-----Original Message-----
From: rpg400-l-bounces+mattt=wincofoods.com@xxxxxxxxxxxx
[mailto:rpg400-l-bounces+mattt=wincofoods.com@xxxxxxxxxxxx] On Behalf Of
rob@xxxxxxxxx
Sent: Friday, February 24, 2006 6:00 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: EXTNAME(DSPF) and SQLRPGLE

I've opened a pmr with IBM.  Their reply to me:
The precompiler does not support the third parameter of EXTNAME but we
shouldn't error.  Can you send in recreates?
I'll go from here.  But, I wonder where that is documented?

Rob Berendt
--

Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Tyler, Matt" <mattt@xxxxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
02/23/2006 04:58 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
cc

Fax to

Subject
RE: EXTNAME(DSPF) and SQLRPGLE






I have no clue.  V5.2 kept giving me UTT66KFM as an external file name
it could not find (after the first error which reported the correct DSPF
name).

Thanks, Matt



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Thursday, February 23, 2006 2:51 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: EXTNAME(DSPF) and SQLRPGLE

No, but YOU did find a bug in the V5R4 precompiler.

     facr100fm  CF   E             WORKSTN

     D E_DSA         E DS
EXTNAME(ACR100FM:ACR10001:*INPUT)
SQL1001: External file definition for INPUT0FM not found.
     D                                     QUALIFIED
     D E_DSB         E DS
EXTNAME(ACR100FM:ACR10001:*INPUT)
SQL1001: External file definition for INPUT0FM not found.
     D                                     QUALIFIED
What is this "INPUT0FM"?

Rob Berendt
--

Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Tyler, Matt" <mattt@xxxxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
02/23/2006 04:14 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
cc

Fax to

Subject
EXTNAME(DSPF) and SQLRPGLE






Will/does the following sample code work at v5.3 or v5.4?
We are at V5.2 and I am attempting to compile SQLRPGLE code.  The data
structures E_DSA and E_DSB have nothing to do with any of the SQL
statements.  I am using it to identify changes between the original
screen data, the data base and any potential changes to screen data.

     FRET66KFM  CF   E             WORKSTN
                                 ...
     D E_DSA         E DS
EXTNAME(RET66KFM:ENTRY:*INPUT)
     D                                     INZ

     D E_DSB         E DS
EXTNAME(RET66KFM:ENTRY:*INPUT)
     D                                     INZ PREFIX(B_)
                                 ...


Thanks, Matt


--

This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.