Categories: 01a - RPG (EN)

Alternative to OVRDBF in F specifications (dcl-f free)

It is not new to RPG but every now and then it is useful to remember that if we want to use, within our RPG programs, some fancy file names that “point” to a different file (for example when we have the same file open in INPUT and in UPDATE-ADD with two different names), we can use the EXTFILE and EXTDESC keywords and avoid OVRDBFs in the CL or at compile time.

Let’s take this example from John B in Midrange.com discussions: https://archive.midrange.com/rpg400-l/202208/msg00115.html

- >> EXTFILE eliminates the need to do a RUN-TIME OVRDBF.
--- >> EXTDESC eliminates the need of a COMPILE-TIME OVRDBF.

       dcl-f bar542d workstn infds (ScrDS) extfile ('GLOBAL / BAR542D') extdesc ('GLOBAL / BAR542D');

Simon Hutchinson already told us about it in 2013: Useful keywords for your F-specs

Related Posts
DB2 for i SQL – String Manipulation – POSSTR-LOCATE-LOCATE_IN_STRING (EN)

Introduction Often, in our applications, we need to work with text strings, and DB2 SQL can come in very useful Read more

DB2 for i – FAQ & Howtos (EN)

DB2 Database and SQL ... maybe the most important things on IBM i platform: here's a collection of FAQs, tips Read more

IBM i 7.4 Announcement (En)

Comes directly with the Easter egg this IBM announcement for the news of the IBM i 7.4 version, iNext version Read more

Generated Always Columns (EN)

Introduction "Generated Always Column": are columns, table fields, filled by DB2 engine: something like columns with a default value but Read more

--- Roberto De Pedrini Faq400.com

View Comments

  • Even simpler is to use extfile(*ExtDesc). Eg.
    dcl-f bar542d workstn infds(ScrDS)
    extdesc('GLOBAL/BAR542D')
    extfile(*ExtDesc);

Recent Posts

Code for IBM i 2.10.0 – Debug IBM i App with Visual Studio Code

Debugging functions with Visual Studio Code have been available for some time but this new version 2.10.0 simplifies the handling…

2 days ago

ObjectConnect over TCP/IP

Two and a half years after my post Transferring objects with ObjectConnect and Enterprise Extender, I finally got around to…

3 days ago

SQL: SELECT with “superpowers”

With a little trick even a simple SELECT statement can execute any system command! Let's see how to do that...

5 months ago

NetServer for everyone – part 5

A mini-serial guide to configuring, managing, using, and troubleshooting the IBM i NetServer

1 year ago

NetServer for everyone – part 4

A mini-serial guide to configuring, managing, using, and troubleshooting the IBM i NetServer

1 year ago

NetServer for everyone – part 3

A mini-serial guide to configuring, managing, using, and troubleshooting the IBM i NetServer

1 year ago