Re: Using long names

[Alan Campin <alan0307d@xxxxxxxxx>]

Make sure that when you create your table create meaningful short and long
names. Same rules, first two or three characters id, use full 10 characters
if you need them for short name. When you use a long table name, make sure
you put a comment with the short name next to the SQL. Remember that a lot
of tools like DBU and otherwise don't use long names and everyone who use
the table may not want to use the long names.

On Thu, Jul 25, 2019 at 8:57 AM Rob Berendt <rob@xxxxxxxxx> wrote:

> That will work.
>
> 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
> Birgitta Hauser
> Sent: Thursday, July 25, 2019 11:46 AM
> To: 'RPG programming on IBM i' <rpg400-l@xxxxxxxxxxxxxxxxxx>
> Subject: RE: Using long names
>
> 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.
>
>
> Using long File Names and long field names is possible, you have to
> specify the short name with the ExtDesc Keyword and for compiling also add
> ExtFile(*ExtDesc) to your F-spec.
> After you can use the long file names.
> For using the long column/field names just add Alias to the F-specs
>
> DCL-F Your_Long_Table_Name
>                            ExtDesc('SHORTNAME') ExtFile(*ExtDesc) Keyed
> Alias;
>
> Chain (Key1, Key2) Your_Long_Table_Name;
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok) "What is
> worse than training your staff and losing them? Not training them and
> keeping them!"
> "Train people well enough so they can leave, treat them well enough so
> they don't want to." (Richard Branson)
>
>
> -----Original Message-----
> From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob
> Berendt
> Sent: Donnerstag, 25. Juli 2019 15:40
> To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
> Subject: Using long names
>
> Let's say you created a table like this:
> Create table I_like_long_names for system name shortname ( My_column_name
> for column C01 varchar(100),
> ...)
>
> And you want to use just the long names in RPG, can this be done with
> dcl-f I_like_long_names disk keyed usage(*update) alias; // alias says to
> use the long column names
>
> Or do you have to do something like this to use the long table name too?
> dcl-f file1 disk keyed usage(*update) alias extdesc(i_like_long_names);
>
> 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
>
> --
> 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
>
> --
> 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
> --
> 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