Re: Sometime you need multiple members in a table.

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

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