Re: accessing QS3F data by utilities and 4GLs - where do they see the field layout ?

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

Steven,

I think Jerry is saying that the QS36F library is the same as any other 
library.  While it may be traditionally used with file created by the 
S/36 BLDFILE procedure (and similar tools) that's just a convention, not 
a requirement of that library.

You can use DDS and CRTPF, or SQL and CREATE TABLE to generate files in 
QS36F as well.  And when you do, they work exactly the same in QS36F as 
they do elsewhere.

Likewise, you can use the S/36 FLIB procedure together with the BLDFILE 
procedure to create S/36-style files in /any/ library on the system.

So when you refer to SQL (or 4GLs like EGL) accessing data in QS36F, you 
aren't being totally accurate.  What you're really asking about is SQL 
accessing flat files, or files created via the S/36 commands. Whether it 
is in QS36F is not germaine to the questions you're asking.

We all know what you mean.  I think Jerry was just pointing that 
technicality out.



On 3/16/2012 1:33 PM, Steven Spencer wrote:
> HI Folks,
>
> Jerry C. Adams,
> > Just a note about QS36F data.  QS36F is no different from any other
> > library.The ease of accessing the data depends solely upon whether
> > or not it is externally defined (SQL-compatible).  ....There's
> > nothing really "strange" about QS36F.