Re: Autogenerate Variables for SQL Usage

If I understand correctly you want to be able to use the field names from
the file without actually opening the file?

I think you can use the EXTNAME keyword for this.

EXTNAME(file-name{:format-name}{:*ALL| *INPUT|*OUTPUT|*KEY|*NULL}) - IBM
Documentation <https://www.ibm.com/docs/en/ssw_ibm_i_75/rzasd/dextnam.htm>

Hope this helps.

Regards,

Peter
--

Peter Colpaert

Peter.Colpaert@xxxxxxxxx


Op do 27 mrt 2025 om 11:23 schreef Patrik Schindler <poc@xxxxxxxxxx>:

Hello,

when using classic file I/O routines, files are referenced with F-specs to
automatically generate variables from the external file descriptions at
compile time.

When using SQL, it's somewhat redundant to reference files in this way,
because on program start, they'll be opened in addition to being referenced
by embedded SQL.

Is there a way to reference a file in positional RPG IV (!) only for the
sake of automatically generating variables at compile time, and with no
further handling of the file at runtime? If yes, what are possible keywords
to search for?

Thank you!

:wq! PoC

--
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@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.