5.3.1 Step 1. Create the New LANSA File Definition

1.  Start from the Main System Menu.


 PppSYSMENU                 Main System Menu                           


 Enter number of function or place cursor on same line and press Enter.


  4  1. Use a process                                  

     2. Submit a process to batch                                      

     3. Field control menu                                             

    4. File control menu                                              

     5. Process control menu                                           

     6. Housekeeping menu                                              

     7. Display submitted jobs - workstation                           

     8. Display submitted jobs - user                                  

     9. Display workstation message queue                              

    10. Exit from LANSA                                    



 F1=Help  F3=Exit   F12=Cancel  F14=Messages          



2.  Select the File Control menu option.

     Notify LANSA of the initial details of the file.

3.  From the File Control Menu select the Create a new file definition option.


 PppFILMENU                  File Control Menu                         


 Enter number of function or place cursor on same line and press Enter.


  1  1. Create a new file definition                                

     2. Review or change a file definition                             

     3. Delete a file definition                                       

     4. Make new or amended file definition operational                

     5. Print file definitions                                         

     6. Bulk Load of OTHER files                                       

     7. Exit from LANSA                                                





 F1=Help  F3=Exit  F12=Cancel  F14=Messages           



4.  Press Enter and the Create New File Definition screen is displayed.


CRTFILE                  Create New File Definition                    


 New file name . . . . . . . __________                                

 Library of residence  . . . __________                                

 Description . . . . . . . . ________________________________________  

 Initial public access . . . NORMAL    NORMAL, ALL, NONE               

 To be maintained by . . . . LANSA     LANSA,  OTHER                   


 Copy file definition  . . . __________                                

   Residing in library . . . __________                                



 F1=Help  F3=Exit  F12=Cancel  F14=Messages           



5.  Enter the new File's Name, the Library and Description. The file name must be unique.

     Initial public access specifies the access other users are to be given to the file. NORMAL allows other users to add, change and delete records but not modify the file's definition. ALL allows other users to add, change and delete records as well as modify or delete the file's definition. NONE prevents other users any access to records in this file.

     Specify LANSA in the To be maintained by . . option, to indicate that the file will be maintained by LANSA.

     The Copy file definition option allows you to create a new LANSA file definition from another LANSA file definition. It does not allow you to copy files defined outside of LANSA.

     When you copy from an existing file definition, the following will be copied: fields (including virtual fields), file level validations & triggers, batch control and access routes. Logical views will not be copied.

6.  When you have specified your entries, press Enter to start the creation of the new file definition.

Commit Amendments

     Whenever you create or make modifications to a file definition, you will be prompted to commit the amendments.


 COMMITAMD                  Commit File Amendment(s)                   



 Commit amendment(s) . . . . . . . . . YES   YES, NO                   




 Fnn=Help  Fnn=Exit  Fnn=Cancel  Fnn=Messages                          




     Enter YES and Enter, to save the new file's definition. The File Definition Menu (Create) screen is displayed.

     Note: If you are using Task Ids, then the relevant Task Identifier is displayed on this screen.

For further details about these entries, refer to Creating a New File Definition in the LANSA for i User Guide.

Go to 5.3.2 Step 2. Select the fields for the File.