|
I'll put in a requirement. The create table already has a rcdfmt option so no need to do below option if you remember about the record format name. The alter table rename however does not know about rcdfmt, but should.
Now I am stuck with creating new table, changing journaling properties, setting up permissions, copying data from old table into new table, deleting old table.
...(snip)...
> On 2/15/2017 11:24 AM, Matt Olson wrote:
All,
What is the rename command to change a record format name?
We have this SQL available to change the SQL Long Name, SQL Short Name (System Name), but I don't see RCDFMT name.
Example:
RENAME TABLE LongName TO LongTableName FOR SYSTEM NAME LongName;
But what about changing record format names?
Thanks
As an Amazon Associate we earn from qualifying purchases.
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.