RE: Sometime you need multiple members in a table.

+1
I haven't tried this, but if that works then that is most excellent.


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Brian Johnson
Sent: Thursday, January 17, 2019 5:08 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Sometime you need multiple members in a table.

If you want to stick with multi-member PF, DDS is a one-liner...

A R TABLEFMT FORMAT(TABLE)




On Thu, Jan 17, 2019 at 7:13 AM a4g atl <a4ginatl2@xxxxxxxxx> wrote:

I have a situation where I have a table defined. In the past I used PFs.
The table has a long and short name. This prevents me from using CPYF
or CRTDUPOBJ. I have used RUNSQL to do a Create Table ... as
(select..) with no data. This creates a table not a PF, okay.

I need a PF with Multiple members that is identical to the table. I
use the member to store copies of file we send to external systems as an archive.
The member functionality has been great for this and I do not want to
have hundreds of files in the library.

I do not have DDS but I could create DDS but would prefer not to. That
makes it 2 different objects to maintain.

Is there a way to create a PF from a table?

TIA

Darryl Freinkel
--
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@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
Brian Johnson
brian.johnson.mn@xxxxxxxxx
--
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@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com