2 Providing the details of my task.
source | link

EDIT

Scope: To create a small distribution system on the iSeries platform. Create a series of libraries that includes code for the following:

  • Customer Information File (CIF) Functionality
  • Order Entry Functionality
  • Purchasing Functionality
  • Inventory Functionality

My requirements:

  • Create 4 DDS Specifications for each of the 4 file groups based on the information specified.
  • Create 4 DFU programs for each of the 4 files you set up with DDS specifications.
  • Create 4 CL programs to run the DFU programs you have created.

Include some comments as well as a message that will appear on the screen once the menu option has been chosen. For example, if you chose Option # 1 to Enter CIF data, a message should initially appear such as - 'CIF DATA ENTRY PROGRAM IS NOW EXECUTING'

  • Create 3 Menus for each of the 3 departments(Order Entry/Inventory /Purchasing) with appropriate titles on each menu.

  • Create a main menu called MAINMENU to access the 3 department menus.

  • Create a Query/400 report based on the CIF file and add it to the main menu as an option.

Ensure that you have followed the 3 requirements as follows:

Create the Query as a report by choosing the 'Print' option. Format the CIF # to eliminate the ‘,’ from the number on the report. Place a Page heading on the report.

  • The Main menu should include the following menu options:

Go to the 3 various ‘department’ menus Run the CIF Query program Access the Spool file Sign off

  • Set up the CLP programs on the menus you have created.

The CIF Master File must only exist in one place, but all departments must be able to access the same file.

The Database:

Customer Information File =>

Customer Number (5 digit numeric field) – KEY

Company Name

Contact Name

City

Phone number

Total Customer Order amount ($)

Order Entry File =>

Order Entry Number (6 digit numeric field) – KEY

Customer Number

Item Number Ordered (10 char.)

Date Ordered Quantity Ordered

Ordered By (Person's Name)

Total amount of Order ($)

Inventory File =>

Part Number (6 digit numeric field) – KEY

Part description

Quantity on hand

Unit Cost

Out of Stock Indicator (1 byte Alpha)

Purchase File =>

Purchase Order Number (4 digit numeric field) – KEY

Part number

Quantity Purchased

Quantity Back-ordered

Purchase Date

Total Purchase Order Amount ($)

EDIT

Scope: To create a small distribution system on the iSeries platform. Create a series of libraries that includes code for the following:

  • Customer Information File (CIF) Functionality
  • Order Entry Functionality
  • Purchasing Functionality
  • Inventory Functionality

My requirements:

  • Create 4 DDS Specifications for each of the 4 file groups based on the information specified.
  • Create 4 DFU programs for each of the 4 files you set up with DDS specifications.
  • Create 4 CL programs to run the DFU programs you have created.

Include some comments as well as a message that will appear on the screen once the menu option has been chosen. For example, if you chose Option # 1 to Enter CIF data, a message should initially appear such as - 'CIF DATA ENTRY PROGRAM IS NOW EXECUTING'

  • Create 3 Menus for each of the 3 departments(Order Entry/Inventory /Purchasing) with appropriate titles on each menu.

  • Create a main menu called MAINMENU to access the 3 department menus.

  • Create a Query/400 report based on the CIF file and add it to the main menu as an option.

Ensure that you have followed the 3 requirements as follows:

Create the Query as a report by choosing the 'Print' option. Format the CIF # to eliminate the ‘,’ from the number on the report. Place a Page heading on the report.

  • The Main menu should include the following menu options:

Go to the 3 various ‘department’ menus Run the CIF Query program Access the Spool file Sign off

  • Set up the CLP programs on the menus you have created.

The CIF Master File must only exist in one place, but all departments must be able to access the same file.

The Database:

Customer Information File =>

Customer Number (5 digit numeric field) – KEY

Company Name

Contact Name

City

Phone number

Total Customer Order amount ($)

Order Entry File =>

Order Entry Number (6 digit numeric field) – KEY

Customer Number

Item Number Ordered (10 char.)

Date Ordered Quantity Ordered

Ordered By (Person's Name)

Total amount of Order ($)

Inventory File =>

Part Number (6 digit numeric field) – KEY

Part description

Quantity on hand

Unit Cost

Out of Stock Indicator (1 byte Alpha)

Purchase File =>

Purchase Order Number (4 digit numeric field) – KEY

Part number

Quantity Purchased

Quantity Back-ordered

Purchase Date

Total Purchase Order Amount ($)

1
source | link

How to correctly use PFILE keyword in DDS Logical File? (AS400)

I'm having trouble wording this question right (also not sure if I'm in the right stack section)

My issue is that I have a logical file ORDFILE located in the ORDRENTLB library, that is suppose have access to the physical file data of CIFFILE located in the CUSTINFOLB library.

When compiling, all I get for the program is the error "ended abnormally".

However, when I remove PFILE(CUSTINFOLB/CIFFILE), and change the type to PF, it compiles perfectly.

The CIFFILE has compiled successfully as its only a PF.

what I have tried: Moving ORDFILE to the same library as CIFFILE (abnormal ending error) Tried stating CUSTOMER as a foreign key by placing an F next to CUSTOMER in ORDFILE (got an error) Tried placing single quotes around 'CUSTINFOLB/CIFFILE', (error)

what am I doing wrong?

thanks for your time. CIFFILE

ordfile