Re: Referencing SQL Table Alternative Names in a RPG module

Sorry I didn't explain that well.

I was trying to reference the SQL Table 'alternative field name' in the RPG
module and because of that I got a compile error as the alternative field
name is not found in the record format. This is at V5R4.

When I reference the field name (short name) and not the alternative field
name I do not get an error as it is found in the record format.

Thanks


On Fri, Oct 7, 2011 at 1:55 PM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

Also,

You shouldn't be getting any compile errors...I use tables with long
names in RPG IV all the time..

The system automatically defines (or you can explicitly define) a
short name for the column...prior to the ALIAS support added in 7.1,
the short name would be used by RPG.

Can you post an example showing your problem?

Charles

On Fri, Oct 7, 2011 at 1:19 PM, Andy Hautamaki
<ahautamaki@xxxxxxxxxxxxxxx> wrote:

In an SQL Table we have descriptive alternative field names that from

what I

can see from prior posts you can't refer to them in an RPG module. (Not
using embedded SQL)

In the compile listing for the externally defined file I notice it

doesn't

bring them in for the record format so I get the fields not defined

compile

error.

Is this just how things are and not something that is even on the radar

to

change?

Thanks
Andy Hautamaki



--
This is the RPG programming on the IBM i / System i (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.

--
This is the RPG programming on the IBM i / System i (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.