I want to thank everyone for their insight into this. It would be so much easier if I could change the mid of the dinosaur. :)
I did want to add as a follow-up, that there is a potential issue with change management that needs to be researched before you attempt this. I found that when you create the file via CRTPF and then do the SQL rename, the file is available via SQL with both names as expected. However, if you do a subsequent CRTPF like most CM packages, the long file name from the rename is GONE.
I did find that I can do a CREATE ALIAS for the file and it basically works the same way from the SQL perspective. If someone knows different, please let me know. With the CREATE ALIAS, doing a CRTPF or CHGPF does not affect the alias and it is still available. The downside that I can see to this is if you delete the PF, the alias remains out there and if the file is recreated later via CRTPF, the link is still intact. I see this as potentially causing some weird results if a file is deleted and the file name is reused somewhere down the road and something tries to hit the old version of the file via the alias.
All that said, I'll have to see if I can sneak a CREATE ALIAS past the dinosaur at least until IBM adds a way of doing the long file name to the DDS (is there a way to request this as a future enhancement...assuming IBM is still enhancing DDS?).
As an Amazon Associate we earn from qualifying purchases.
This thread ...
Re: Can I use DDS to create an SQL table name, (continued)
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.