Short answer: NO
Reference Tables are not SQL Standard, so I suspect there will not be any
improvements or enhancements in near future.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
Modernization ? Education ? Consulting on IBM i
Database and Software Architect
IBM Champion since 2020
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
"Train people well enough so they can leave, treat them well enough so they
don't want to. " (Richard Branson)
"Learning is experience ? everything else is only information!" (Albert
Einstein)
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Brian
Garland via MIDRANGE-L
Sent: Tuesday, 2 April 2024 13:53
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: Brian Garland <Brian.Garland@xxxxxxxxxx>
Subject: SQL reference file
I found an old thread in the archives about replicating DDS reference file
functionality.
CREATE TABLE xxxx AS (SELECT col1, col2, ... FROM ref_table)...
I have done this in the past but I was never fond of it because I felt the
code was complicated and not always clear for a couple of reasons:
a) "One-off" fields had to be defined with a CAST statement or all fields
needed to be in your reference table
b) Constraints (including primary key) had to be done as an ALTER TABLE.
Have any improvements been made around this topic? Is there any tooling
that helps with creating table definitions based on reference columns?
Thanks,
Brian
--
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or company to whom they are addressed.
Do not disclose, distribute, or copy this email to others outside your
company. If you have received this email in error, please notify the sender
immediately and delete this email from your system.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
As an Amazon Associate we earn from qualifying purchases.