RE: How to copy an SQL table with a long name into the same library

I don't use long names but I just save to a SAVF and restore as needed.




Sent from my T-Mobile 4G LTE Device



-------- Original message --------
From: Dean Eshleman <Dean.Eshleman@xxxxxxxxxxxx>
Date: 11/3/21 11:48 AM (GMT-08:00)
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: How to copy an SQL table with a long name into the same library

Quite often when I'm testing, I will make a backup copy of a database file with data so that I can restore the data back to the original state after I run my test. I normally put the backup copy in the same library and add a SV or X extension. I'm trying to do this with a SQL table that has a long name (AGREEMENT_RECORDS) as well as the 10 character name (AGRMT) and it won't let me. I'm trying to do it with the CPYF statement specifying AGRMTSV as the target file and it fails. I assume it is because the long name is not unique in my library. Apparently, you would need to specify a new long name as well as a new short name when making the copy. However I haven't found a way to do that. Is there an SQL command that would do the rename and copy of the data in one step? How have others dealt with this issue?

Dean Eshleman
Software Development Architect
Everence

1110 North Main Street
PO Box 483
Goshen, IN 46527
(800) 348-7468 ext. 3528
(574) 533-9515 ext. 3528
[Join our Talent Network]<https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.everence.com%2Fcareers&amp;data=04%7C01%7C%7C7f3519b9a3ad4f64d23008d99efa81b0%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637715621020062834%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=0sRbhW%2FSiZZ6cUk81hIELbIi3Xc6MftFHzfxBeYBWA8%3D&amp;reserved=0>

Confidentiality Notice: This information is intended only for the individual or entity named. If you are not the intended recipient, do not use or disclose this information. If you received this e-mail in error, please delete or otherwise destroy it and contact us at (800) 348-7468 so we can take steps to avoid such transmission errors in the future. Thank you.
--
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://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&amp;data=04%7C01%7C%7C7f3519b9a3ad4f64d23008d99efa81b0%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637715621020062834%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=S7A8YdIskEIpTpuZRQY2%2FaJNWYHV6A19MbEF9DoKJzQ%3D&amp;reserved=0
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fmidrange-l&amp;data=04%7C01%7C%7C7f3519b9a3ad4f64d23008d99efa81b0%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637715621020062834%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=Z3WP8dEU9QrjwugX8SCJE2dLKU2uDDWaqSwY4U7r75U%3D&amp;reserved=0.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Famazon.midrange.com%2F&amp;data=04%7C01%7C%7C7f3519b9a3ad4f64d23008d99efa81b0%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637715621020062834%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=KsIKoOxDzlWWPq39VFF0ehEA8yek00SrMRokfoFqrpE%3D&amp;reserved=0