TheHeck   165 pts.  |   Jun 9 2009  4:34PM GMT

The AS400 does not function like an access database. What you are trying to do requires more thought in terms of design. What are you trying to do??? What data elements need to be included in my file or files??? What is the relationship between them and other files on your system. What is my report going to look like???, etc.

Only once this has been defined can you even begin to think about creating “shortcuts” for users to use to create reports on their own…

McSick   30 pts.  |   Jun 12 2009  5:25PM GMT

Here’s my response to your very vague request.

Create a Table,
To create a Physical File, you will need to create Physical File source (DDS) using STRPDM (Programming Development Manager) (option 3-Work with members) and then SEU (Source Edit Utility) (option 2-Edit) to type it in and then CRTPF (option 14-Compile) to create the object.

Enter Record Data
You can use STRDFU (AS/400 Data File Utility) to add data to fhe Physicla file you created

Report Menu
Create Display File source using STRPDM and then SDA (Screen Design Aid) (option 17), then use CRTDSPF (option 14) to create the object. You will need one I/O field defined to hold the menu option desired by the user.

Then create CL program, STRPDM, SEU, use SNDRCVF to write and read your display file and interogate the option entered to determine what report to run.

Create a Report
If the report is simple, you can use WRKQRY command to create a Query/400 report.

Run Savings or Budget Report
Use RUNQRY command to run query (Add this to the CL program above for the Menu Option that specifies this report)

Return to DataBase Menu.
CALL <CLProgram> which will display the menu, check reply value and execute appropiate commands to run reports. You can opt to submit the RUNQRY command to batch or run it interactively.
Use F3 to exit your CL program.

Yorkshireman   3200 pts.  |   Jun 16 2009  7:02AM GMT

well, actually, you don’t need DDS to create a file

CRTPF will function without source

- or you could use SQL

or you could drop a file into the IFS area from windows, or use a proper operating system like OSX or linux, or my much loved OS2

That’s the thing about iSeries, it does everything and more, so specific questions are needed.

you could visit the IBM website - gazillions of manuals and redbooks there.