Help with iSeries CRTLF command

15 pts.
Tags:
IBM iSeries
Logical Files
Physical File
I need to create a logical file over a physical file. Can someone help me understand what I am doing wrong. The physical file is in library IDSDAYA and is called OOIORDDP. It has 6 members and I am interested in creating a file where I can access the data in three of the members at one time. I tired the following command: CRTLF FILE(IDSDATA/OOIORDDPZ) DTAMBRS((IDSDATA/OOIORDDP (ORDER BATCH POS))) I get the following error: Member OOIORDDPZ file QDDSSRC in library *LIBL not found. Plus a message saying the OOIORDDPZ was not created.

Software/Hardware used:
iSeries

Answer Wiki

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

Member OOIORDDPZ file QDDSSRC in library *LIBL not found

This error is happening because when you are running the CRTLF command, it is looking for a source member that defines the LF. So, either you have not created it or wherever you put it it is not in your current *LIBL.

The source member will have all the specs for the LF: PF name. Fields if not selecting all or doing CONCAT, Select/Omit criteria if any, and Key information

Discuss This Question: 1  Reply

 
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
  • RegnadKcin57
    The CRTLF command has both a SRCFILE (Source File) and a SRCMBR (Source Member) parameter.  Both parameters are optionally specified because they have default values.  The defaults are SRCFILE(*LIBL/QDDSSRC) SRCMBR(*FILE).  Because the shown CRTLF request specified neither of those parameters, the default values were in effect.  The error message CPF9815 "Member OOIORDDPZ file QDDSSRC in library *LIBL not found." and then the CPF7302 "File OOIORDDPZ not created in library IDSDATA." diagnose that the defaulted parameter specifications were unable to satisfy the requirements to Create the Logical File.

    As already alluded in the "Answer" to the question, the DDS (Data Description Specifications) that define the LF (Logical File) must exist and be found in the Source File Member that is specified or assumed\defaulted on the CRTLF.  And of course the LF DDS must be capable of being compiled successfully by the DDS processor.

      The following link may be of interest [navigation and a snippet of the doc are included]:
    http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/rzakb/ldef.htm

    "Defining a logical file using DDS

    A logical file determines how data records are selected and defined when read by an application program. A logical file can be a simple, multiple format, or join logical file.

    A simple logical file contains one record format and has one file specified on the PFILE keyword. A multiple format logical file either contains more than one record format or has more than one file specified on the PFILE keyword. A join logical file contains one record format and has up to 256 files specified on the JFILE keyword.

     ..."


    95 pointsBadges:
    report

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