sqlrpgle select into extname using freeform

  • Home
  • /
  • Blog
  • /
  • sqlrpgle select into extname using freeform

June 17, 2017

sqlrpgle select into extname using freeform

By NickLitten

June 17, 2017

SQLRPGLE, RDi, SEU, snippet, SQL

AKA – Why does this compile fail using SQLRPGLE and QUALIFIED data structures?

Sometimes I find a problem and scratch my head and just cannot figure it out. I swear a lot. Then I discover the solution by climbing out of my little box, turning my head at a funny angle, squinting and thinking a bit differently. Then I swear even more.


I converted a column based piece of SQLRPGLE from this:

d S21uservalues... 
d e ds qualified 
d extname('APG05PHY') 

to this:

dcl-ds S21uservalues qualified extname('APG05PHY') end-ds; 

The SQL to read this looks like this:

exec SQL fetch next from cursorAPG05 into :S21uservalues;

and then it just will not compile!

Compile error is: SQL0312 30 798 Position 52 Variable S21STOCKROOMNAME not defined or not usable.

“But that is completely valid new free format RPG syntax” I scream at the compiler. /me then goes on to waste more time than I am prepared to admit trying every combination of code to figure out whats going on


The bloody DCL-DS statement is just too long and over-runs the available area into the //text area of this source member. Because I am using SEU (this client does not use any modern code editors and have blocked the ports to use RDi, Mi Workplace or even good old WDSC) the line is highlighted as in error – but I incorrectly assumed it was an error because SEU doesn’t know about modern freeformat commands.

So, change it to a shorter and s neater layout like this:

dcl-ds S21uservalues

and boom it compiles and works.

Annoying — but obvious — once I figured it out anyway.

This wouldn’t have been a problem if I had been coding correctly using **FREE


  • Aaaaggghhhh!!!
    My mistake, I forgot to define a variable in the dcl-pr for the program that was used later in the code.
    For some reason this caused the errors with the data structures.
    All fixed now though 🙂

    Hi Nick,

    Finally I found a post where someone (you!) are experiencing exactly the same problem as I am, however your solution doesn’t work for me for some reason. I’m wondering if it’s because we are on 7.1 and maybe we need a PTF applying.

    The relevant sections of the code I have (generated in RDI) is as below:

    Data structure definition from external file

    // Stock master data structure
    dcl-ds stkmstpfDS extname(stkmstpf) qualified;

    Note: Unlike your code, mine compiles without quotes around the external file name, but fails if I add them.

    SQL select

    exec sql
    select * into :stkmstpfDS
    from stkmstpf
    where skmno = :pStkItem;

    SQL insert

    exec sql
    insert into stkmstpf
    with NC;

    I am using this to retrieve a record from this file. I then want to create a new record, updating and resetting a number of the fields (including the key) before doing the insert.

    On both the select and insert statements I get this error:

    SQL0312: Position 18 Variable STKMSTPFDS not defined or not usable.

    I wondered if you or anyone else who reads this has any thoughts.

    Thanks in advance.
    Tony Payne

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    Join the IBM i Community for FREE Presentations, Lessons, Hints and Tips