Why can’t create a physical file has more than one record format ?

pts.
Tags:
AS/400
RPG
After I coded 'A' spec for multiple record format physical file like this R REC1 MBRID 9A REV 41A R REC2 MBRNM1 50A The joblog (after compiled) said ID Severity Number * CPD7914 30 1 Message . . . . : File contains more than one record format Could you please investigate and let's me know how to solve this situation ?

Answer Wiki

Thanks. We'll let you know when a new response is added.

You could create 2 physical files, each with 1 format, then create a logical file over the 2 physical files. When you access the logical file you can read both record formats from the 2 physical files.
Kevin

A physical file or a join logical file can only have one format.

Hard to tell by your code what you are trying to accomplish.

=======================================================

You can’t create a physical file with more than one format because physical files are defined as having only one record format.

If you need multiple record layouts, use program described files.

This is a fundamental aspect of essentially all relational tables. Do you know of <i>any</i> relational DBMS that supports CREATE TABLE with multiple row definitions?

Tom

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following