JDE Help

[itp]

I am taking on a role in supporting JDE (8.1). I took the technical foundation course a few years ago, but the course notes are short on programmer details. I am looking for notes on special JDE subroutines and coding standards, date handling, customizing reports, screens. Can anyone help?

Anyone know if coding RPG/ILE or RPG/free is feasable with JDE within its development framework? Did JDE add "email report" or "save as word/Excel" in its later green screen versions?

[longjo73]

Re: JDE Help

The best source of information is Knowledge Garden. Call JDE help desk and ask for user id and password to Knowledge Garden. Then go to JDE website and select Knowledge Garden. You can search for items there.


For JDE messages use:
JDE messages
Menu G9362

To set up sleeper jobs use:
Menu JDE Operations/Sleeper
G96

To enter HELP instructions for your pgm:
JDE program HELP instructions
G9361

To move objects:
Move JDE objects
1. DreamWriter = Menu G81
2. Menus = Menu G901
3. Move anything = Menu G9362

To see the Process Options behind a program on a menu:
Process Option Display
Key in option of program want to execute in command line and press F18

To edit Process options:
Enter PO on command line.

To go to DreamWriter versions:
Enter VL for version list on command line.

To see the OpenQry file statement behind a dreamwriter, From VL (version list) enter a 7 in option next to program.

To review a few of the routines for dates etc. :
In JDE go to command line.
Key in SVR and press enter.
In Program Name enter P03305 (this is a vanilla JDE report. Comes with the system)

Use edit option. If you can't edit then copy the program to your library in PDM.
Note the Source File and Library from SVR and then enter STRPDM on command line. Take option 3 for members and enter the source file information. THen copy the program to your library. NExt go back to SVR in JDE and bring program back up, do a Change and enter your information into detail portion of screen. Then you should be able to use SVR to edit.

When in edit you can use F4 on any line to see details of command.
Look for a few of these items:
1. /COPY JDE uses a lot of copy members. They are always in JDECPY file and then in whatever library you keep your code. You will see this in SVR if you pull up the copy member name in SVR.

2. S999 is always housekeeping and S998 always loads the Data Dictionary parms.

3. Position on C00RSC. Look above this copy and below. This is softcoded heading the program uses. This prints the heading you enter in the Dreamwriter version headings.

4. position on C81DRPT. This retreives the processing options you entered into the DreamWriter version. If you enter PO on command line you will see these. And the Option Number in the PO will corelate to the index number of the field in the RPG. In the RPG they always name the Process Options OP, so postion on "OP," to see the process option and index.

5. Position on X0028. This is date conversion. You can see this source in SVR also. X programs are usually called server programs in JDE.

6. position on X9800E. This pulls in the data dictionary attributes of the fields you will send to the server to convert like dates and numbers. JDE holds all dates as julian and all numeric fields as 15.0. So data dictionary attributes converts numeric data to correct decimals.

7. Position on C00161. This moves data to correct format for output using data dictionary attributes.

IN SVR bring up the CL. J03305 (In JDE RPG is always P, CL a J, Display files V and reports R).
CL J03305.
Position on OPNQRYF. This part of CL is building your OPNQRY FILE from the data selection you made in DreamWriter version. Remember put a 7 next to the Dreamwriter to see the openqry statement it will build.

DreamWriters:
Process Options are entered in DreamWriter and processed in the RPG.
Data Selection options are entered in DreamWriter and used to create openqry file in the CL.

To go to the Dreamwriter for this program go to command line in JDE.
Enter VL.
This is for Version List.
After enter VL, enter P03305 in form. (Form is program rpg name).
You will get a list. X or Z versions come with the system and should be used as models and not changed. Copy one of those to you by doing an Add option 3.
Give it a name and press enter.
1st screen is headings. The optional report titles are the softcoded report headings we talked about earlier in the RPG.
2nd screen gives file name the data selection (open qry file) is going to use. You do not have to have a file here. If no file then this should say *NONE.
Do f1 on fields to see help.

3rd screen. These are the process options the RPG program will process. To see the set up these do a PO on a command line in JDE. Do a f1 on fields to see help.

4th screen. Data selection. For open qry file. F4 to unfold, F16 to see all fields available. (Sometimes JDE will have a data selection but not use the openqry file. A good example is P09800 posting programs. If you look at CL they do not build the open qry file, but the program does use data selection, so beware).

5th screen is data sequence. Sorting. You must have at least one sort sequence if this screen is displayed or you will get error when you run the DW.

Dreamwriter can be run from a Menu or by going to the VL (version list). Option son the 2nd screen determine if user will see process options, data selection, if run automatically etc. PF1 on those fields to see help.

If you enter VO on command line this takes you to Vocabulary Overrides. JDE uses this to softcode headings in reports and screens. Not all programs use this.

To see the report to this program go to SVR and enter R03305.
You can compile from SVR or from STRPDM depending on your set up.

Best way to see what a JDE program is doing is run it thru DBG. to do this enter JDEDBG on command line and F4. Enter the program info. When you CALL the program (if a batch call the program RPG and enter the parms required --- Look under *ENTRY in RPG. Normally it only requires Program Name and version. Version is the version you added in DreamWriter Version List. , then can use blanks for rest. Options are listed in JDEDBG.

More FYI:

Index of Menus
F16 on command line to window of menus
Change level of detail to 6 to see all.

Search in PDM
STRPDM
25 in option
F13 to copy 25 to all pgms. (Search all)

Where Used
Enter Field in Data Dictionary (DD on command line). Enter item. F15.

Hidden Selections.
On Menu (example G09) key HS in command line for window.
Advanced = Batch header, etc.
Tech = Setup.

Find in JDE
F24 on command line to window.
Select Menu Word Search
there are alot of options in this window. Fast Path commands etc.

I hope this helps a little. May just be more confusing. Best thing is to get a program and go thru all the pieces. CL, RPG, RPT, DreamWriter etc. to see how they interconnect. usually anything you want to do JDE has a routine for. All thier cpy routines are in File JDECPY in the library where you keep your source. Good Luck. Joyce