Re: Embedded SQL Precompiler

As I recall, RPG was, sometimes, but I see it is not there now. I also see that Print is not in the 7.4 list but it is in one of the earlier ones. Maybe things are put here as they're available.

So at this time there doesn't seem to be anything directly related to the SQL pre-compiler. Sigh!

On 3/25/2020 12:34 PM, Rob Berendt wrote:

Database and Base OS are not part of the "recommended" PTFs
https://www.ibm.com/support/pages/node/667303

Rob Berendt
-- IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive Garrett, IN 46738 Ship to: Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com -----Original Message----- From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Vernon Hamberg Sent: Tuesday, March 24, 2020 5:44 PM To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx> Subject: Re: Embedded SQL Precompiler CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe. Some time ago I would look at the "Recommended" PTFs - there were often some that were not in a cume or group, IIRC. This would be another trail to follow, along with what has already been suggested. And this is also useful for other kinds of PTFs. Vern On 3/24/2020 3:12 PM, Francois Lavoie wrote:

Dunno if right/best was but HTH

You can search for RPG or SQL in the text field on the Fix Central web site then filter by release and click on Show fix Detail
https://www.ibm.com/support/fixcentral/ibmi/selectFixes?function=textSearch&text=rpg

Abstract/Description aint not much descriptive but im sure you can decipher some of them


-----Original Message-----
From: RPG400-L<rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Scott Klement
Sent: Tuesday, March 24, 2020 15:47
To:rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: Embedded SQL Precompiler

Hi All,

Does anyone know the right/best way to get the latest PTFs for the embedded SQL precompiler for RPG?

I'm already up-to-date on the latest group and cume PTFs for IBM i 7.4. (Including the ST1 group)

The problem I'm having is that the precompiler is inserting code in the wrong place in the program. It'll insert definitions, for example, after the main procedure and before subprocedures, where they aren't allowed. It makes it really hard to use this precompiler for anything.

I'm hoping the latest PTFs will fix it...?

-SK


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

Please contactsupport@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link:https://amazon.midrange.com

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

Please contactsupport@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link:https://amazon.midrange.com
-- This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: https://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx Before posting, please take a moment to review the archives at https://archive.midrange.com/rpg400-l. Please contact support@xxxxxxxxxxxx for any subscription related questions. Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com