× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.