RE: Reality check on PFs created as SQL TABLEs

This may be an oversimplification, but anything DDS PFs & LFs support, SQL does as well.

If I'm not sure how SQL "replicates" a DDS feature, I'll use the Generate SQL function in Run SQL Scripts to generate the converted SQL source for DDS PF & LF objects.

- Dan Bale

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of James H. H. Lampert via MIDRANGE-L
Sent: Wednesday, June 10, 2026 1:23 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: James H. H. Lampert <jamesl@xxxxxxxxxxxxxxxxx>
Subject: Reality check on PFs created as SQL TABLEs

Just to be sure:

There isn't some oddball extension to SQL that I'm not aware of, such that you can create a keyed PF via an SQL CREATE TABLE statement, right?

--
JHHL

(I just experienced what I'd thought was a weird asymmetry when attempting to a LF as an SQL INDEX with a descending key; it turned out that I'd misspelled "DESC," and SQL was treating "DSC" as a field rename. You learn something new every day. This has been a fun week so far.)

*** CONFIDENTIALITY NOTICE: The information contained in this communication may be confidential, and is intended only for the use of the recipients named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please return it to the sender immediately and delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. ***