Re: Sometime you need multiple members in a table.

Hi Darryl

I'm not sure why you can't use CPYF - a table is actually a PF with an additional attribute that marks it as an SQL table.

If you have a PF with the same structure, your should be able to CPYF into it from the table - just use the short name, also known as the system name - so it's the 10-character name you can use just like any non-SQL PF.

Another idea is to add a column that identifies the data set - whatever you are naming the members with can be used as the value in that column.

You could also have a PF defined only with a record length, with multiple members. Have a program with a data structure that maps the columns in a program when you need to read it.

HTH
Vern

On 1/17/2019 7:13 AM, a4g atl 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