JDE World Writer Guide
JDE World Writer Guide
JDE World Writer Guide
April 2013
JD Edwards World World Writer Guide, Release A9.3
E21961-02
This software and related documentation are provided under a license agreement containing restrictions on
use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your
license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,
transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse
engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is
prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If
you find any errors, please report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it
on behalf of the U.S. Government, the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software,
any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users
are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and
agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and
adaptation of the programs, including any operating system, integrated software, any programs installed on
the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to
the programs. No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management
applications. It is not developed or intended for use in any inherently dangerous applications, including
applications that may create a risk of personal injury. If you use this software or hardware in dangerous
applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other
measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages
caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of
their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks
are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD,
Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced
Micro Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information on content, products,
and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly
disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle
Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your
access to or use of third-party content, products, or services.
Contents
iii
4 Find Files and Fields
4.1 Finding Files and Fields ............................................................................................................. 4-1
4.2 Determining What Files to Use ................................................................................................. 4-1
4.3 Version Layout Worksheet ........................................................................................................ 4-2
4.4 Version Layout Worksheet ........................................................................................................ 4-3
iv
5.14 Using Printer File Overrides .................................................................................................. 5-35
9 Update Files
9.1 About Updating Files ................................................................................................................. 9-1
9.1.1 Before You Begin.................................................................................................................. 9-1
9.2 Creating World Writer Versions............................................................................................... 9-1
9.2.1 Key Update Tips .................................................................................................................. 9-8
9.2.2 What You Should Know About......................................................................................... 9-8
10 Menu Setup
10.1 About Menu Setup................................................................................................................... 10-1
11 Sleeper Setup
11.1 About Sleeper Setup ................................................................................................................ 11-1
v
A Joined Logical Files
B Soft Join
B.1 Standard File Join Process......................................................................................................... B-1
B.2 What is a Soft Join? .................................................................................................................... B-1
B.2.1 Example One ....................................................................................................................... B-2
B.2.2 Example Two....................................................................................................................... B-5
Index
vi
Preface
Audience
This guide is intended for implementers and end users of JD Edwards World World
Writer.
Documentation Accessibility
For information about Oracle's commitment to accessibility, visit the Oracle
Accessibility Program website at
http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Related Documents
You can access related documents from the JD Edwards World Release
Documentation Overview pages on My Oracle Support. Access the main
documentation overview page by searching for the document ID, which is 1362397.1,
or by using this link:
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1362397.
1
Conventions
The following text conventions are used in this document:
Convention Meaning
boldface Boldface type indicates graphical user interface elements associated
with an action, or terms defined in text or the glossary.
italic Italic type indicates book titles, emphasis, or placeholder variables for
which you supply particular values.
monospace Monospace type indicates commands within a paragraph, URLs, code
in examples, text that appears on the screen, or text that you enter.
vii
viii
1
Overview to World Writer
1
Topic Description
Using up to 32 different files You can include up to 32 different files when designing your
World Writer version. The file or files you choose can be JD
Edwards World or non-JD Edwards World files. If these files
are on your iSeries, they already comply with IBM's standards
and are available for you to use.
Topic Description
Selecting fields and Sequence fields to be printed as columns on the report in
determining use the order you determine.
Select the data through the use of standard Boolean Logic.
Sort and group the data to make viewing the information
easier.
Specify totaling functions such as: summary, average,
minimum, maximum, or count.
Create both detail and summary reports.
Efficient handling of World Writer uses Data Dictionary to automatically display
numeric data numerical data on your report. Formatting includes decimal
position, use of commas and negative signs. You can modify
these types of information on the report as well as determine if
the data should be rounded.
Dates stored as Julian in the file appear in the Gregorian format
on the output. Further formatting for MDY and separator
character is recognized from System defaults or User
Preferences.
Automatic descriptions Data Dictionary helps when developing column titles. Many
times the fields you want on your report are already
appropriately named and these names are preloaded for you
on your report. This speeds your design time dramatically.
Presumptive join fields World Writer automatically links associated descriptions or
information attached to a field in your report. This feature
allows you to include more meaningful information on your
report than just a code or number. User Defined Codes as well
as Address Number, Business Unit, and Company Number are
examples of fields that have presumptive joins.
Calculated fields Create new fields by performing calculations using other fields
or literal values. Calculated fields can be printed, used to select
data, and used for sorting and totaling purposes.
Levels of security World Writer provides five levels of security:
1. Business Unit
2. User Exclusive
3. Group Level
4. File/Field Level
5. IBM Object Authority
Ease of learning World Writer is similar to DREAM Writer and FASTR. Being
familiar with DREAM Writer makes learning World Writer
easier but is by no means a prerequisite. You will find that,
once you grasp the basic concepts of designing a report, World
Writer becomes both a functional and productive tool.
JD Edwards World supplies prototypes of reports. You can
often copy an existing report and customize it to your needs.
These prototypes give you a head start with designing your
own reports.
Previewing reports online As you create your World Writer report, you can preview the
layout on your workstation. This allows you to check format,
column titles, spelling, spacing, and other report elements
while designing your report.
Creating physical files World Writer has the ability to create a physical file that
resides in a library on the iSeries. The file can be used in
another World Writer report, in a program, or downloaded to
the PC for use in PC applications such as Excel.
Topic Description
Updating fields in a file Use World Writer to update a field in a file. This is a powerful
feature and should be used with caution.
You can access the World Writer menu in any of three ways:
Selection 24 from the Master Directory (G)
Menu travel to menu G82
Fast Path WW
Skip to Version - Enter the first few characters of the version name to jump to that
location in the list of versions.
Options
1 - Run, submit the version for processing
2 - Change an existing version
3 - Add a new version or copy an existing version
4 - Specify report distribution
5 - View cover page outline
6 - Access printer file overrides
7 - Display SQL statement
9 - Delete a version
Function Keys
You can use function keys to do the following:
F2 - Toggle Change/Execution Date column
F13 - Display report layout (cursor sensitive). See Chapter 5.1, "About World
Writer Setup" for more information.
1. Locate the first blank line after the last version, paging down if necessary.
2. Enter 3 (Add/Copy Query) in the following field:
OP
The set up screens display in order.
3. Complete each screen, as needed, to create the version.
3. Enter 1 next to any of the set up screens to review or change the screen.
The following table compares the characteristics of the Revise and Copy functions:
Revise Copy
Option 2 - Change Query Option 3 - Add/Copy Query
Same Version Name Same & New Version Names - 2 versions
Original version is modified Original version not modified and new version created
Choose only setup screens Choose only setup screens needed
needed
To delete a version
When you delete a version, it cannot be retrieved. However, you are given a chance to
cancel the deletion.
On the Versions List screen
1. Locate the version.
2. Enter 9 (Delete/Cancel) in the following field:
OP
3. On Query Distribution List, enter the users who should receive this report. There
are a total of 45 blank spaces to enter user information such as name, phone, email,
and office location.
This information prints as part of the Cover Page. To specify to print the cover
page, see Chapter 5.5, "Using Additional Parameters."
Note: An entry made on this screen does not affect the number of
copies of the report that will print. This can be specified on Printer File
Overrides.
3. Use the Page Up/Page Down functions to scroll through all of the pages of
information.
Note: If outputting to a physical file, the cover page does not print,
regardless of the value in this field.
2. On Additional Parameters, enter Y in the Print Cover Page field. The cover page
prints before the report.
3. Call the program from a long JD Edwards World command line. The program
requires two parameters:
SBMJOB CMD(CALL PGM(P82005) PARM('QQQQQQQQQQ'
'VVVVVVVVVV')) where Q is the Query Group the version resides in and V is
the version.
Q and V are both a maximum of 10 characters.
It is not necessary to understand SQL to work with World Writer. However, if you are
familiar with SQL, this can be a helpful tool for troubleshooting.
On the Versions List screen
1. Choose the version.
2. Enter 7 (Display SQL statement) in the following field:
OP
3. Use the Page Up/Page Down functions to scroll through all of the pages of
information.
Caution: The above method is not always reliable since some files
are accessed through server files and will not be listed.
Note: The item name of the field displays in the upper right corner
of the screen. In some cases, the data item is not shown, but can be
found by choosing Functions, then Glossary.
A blank worksheet is provided to assist with designing and creating your World
Writer versions.
Field Explanation
Group You cannot enter information into this field. The Group ID
defaults from either the Versions List or from the version that
was copied.
Version A ten- character code identifying an individual query within a
given query group (see QRYG). It is similar in function to
DREAM Writer's Screen ID, but in World Writer this field is
user-defined.
Version Title A description that further describes the nature of the query.
Both the Version and Title also display on the Versions List.
The version title is different from the report title.
Report Title The title that displays at the top of the report. It can include up
to three lines with 40 characters each. The lines are
automatically centered on the report.
After you enter the Version and Report Title, press Enter and
specify file names.
File Name The name of a database file from which data is retrieved for the
version. The first file listed is considered the primary file.
Description You cannot enter information into this field. The file name
displays after you press Enter.
Field Explanation
Library The name of the library that contains the specified query file.
Defaults to *LIBL.
Member The name of the file member to use for the version. You can
select only one member. The default is to query the first
(*FIRST) member in the file. Most data files contain only one
member.
File ID Identifies all the fields in a file if more than one file is selected
in a query. In the case of duplicate field names in two or more
files, the file ID is used to determine which occurrence of the
field is being referred.
The query program automatically assigns file IDs sequentially.
JD Edwards World Indicates whether a file follows the JD Edwards World
standards for field naming. The default is Y. This assumes that
all the fields exist in Data Dictionary. If N is specified World
Writer uses the external File Field Descriptions.
5.2.1 Options
9 - Deletes a previously selected file.
5.3.1 Joining
World Writer retrieves records where "Matching" records are found in each file, based
on the joined fields.
The types of joins to obtain either "Matched with Primary file" or "Unmatched with
Primary file" are not available with World Writer.
Typically, matching field names from each file are joined. For example: The join
between F060116 and F0101 is the Address Book Number field, AN8. If an Address
Book Number exists in F0101 but there is no matching number in F060116, then that
number does not appear in the output.
5.3.4 Guidelines
The following list details some helpful guidelines and information:
Only join files when necessary. World Writer's presumptive join feature might
provide the fields you need.
Look for a joined logical file. The join criteria are predefined and eliminate the
need to include more than one file. Example: F0101JC is a joined logical file using
F0101, F0116 and F0401. Join fields that contain identical data. See Appendix A,
"Joined Logical Files" for a list of joined logical files available for use in World
Writer.
The most effective way to join files is by the fields that are unique keys to the files.
One way to find the unique keys is by viewing the file through Hidden Selection
40. Key fields are noted with K01, K02 etc. between the file field name and the
description. If no keys are shown in HS 40, view a logical file, such as F4211LA
At least one field must be joined and some files will require more than one field to
be joined to achieve a one-to-one relationship.
There are two direct join methods:
File Relations - Match Fields
File Relations - Enter Fields.
These screens are only available when two or more files have been specified on
Version Title & Files.
Field Explanation
From File To File The names of the database files specified on the Version Title &
Files screen.
Description The field description. If displayed in order of field name, the
name of the field is appended after the description.
Seq Links the sequenced field in the first file to the field with the
same sequence number in the second file. Use 1, 2, and so on,
for each field needed in sequence.
Relation Describes the test to perform between two fields. This should
always be EQ (equal), which is the default.
This screen is also a good place to review the join criteria for all files.
Note: This screen is only available when two or more files are listed
on Version Title & Files.
Field Explanation
From Field The name of the data field from one of the specified files. If
possible, start with a field from the 1st file
File ID The file ID associated with the From Field. You may skip this
field. When enter is pressed, the program will locate the first
File ID found that matches the From Field name and populate
this field. If identical field names exist in the files, you should
determine the correct File ID and enter it.
Relation The system displays a default value of EQ. Leave this default.
To Field The name of the data field from another file to link to the From
Field. The From and To Fields should have identical data and
must have the same characteristics, i.e. alpha vs. numeric.
File ID The file ID associated with the To Field. You may skip this
field. When enter is pressed, the program will locate the first
File ID found that matches the From Field name and populate
this field. If identical field names exist in the files, you should
determine the correct File ID and enter it.
Field Explanation
User Exclusive (0/1/2/3) Allows you to restrict user access for a report version.
For JD Edwards World, the valid values are:
0 No security. Anyone can change, copy, delete, or run the
version. This is the default when adding a new version.
1 Medium security. Only the "last modified by" user can
change or delete the version. Anyone can copy or run the
version. This is how the JD Edwards World DEMO versions
are delivered.
2 Medium-to-full security. Only the "last modified by" user
can change, delete, or run the version. Anyone can copy the
version.
3 Full security. Only the "last modified by" user can change,
delete, copy, or run it.
4 Medium security - extended. Only the "last modified by"
user can change or delete the version. Anyone can copy or run
the version.
Print Cover Page (Y/N) A code that controls whether to print the cover page for the
version. The cover page shows setup criteria.
Y Print cover page
N Do not print cover page
Hold on Job Queue (Y/N) A code used to indicate whether to hold the submitted job in
the job queue. Values are:
Y Hold in job queue
N Job will process through the job queue
Batch Job Queue The computer waiting line that particular job passes through. If
blank, it defaults to the job queue specified in the user's job
description.
Prompt for Data Selections A code that displays the Data Selection screen when a version
is submitted. This allows users access to modify the record
selection criteria without changing the basic structure of the
version. This also ensures that record selection is reviewed
and/or changed before the version is submitted.
Y Display Data Selection at runtime.
N Version is submitted without displaying Data Selection.
Query Detail (or Totals Only) A code indicating whether to print detail lines on a report, or
just the total lines.
D Print detail and total lines
T Print totals only
Default Line Spacing The number of lines to advance before printing the next detail
line. When a print line is wrapped, the wrapped lines are all
single-spaced.
The number of lines to space before a total line can be changed
when defining the total line on Data Sort & Totaling.
Default Column Spacing The number of blank spaces before the next column prints. The
default spacing can be overridden on a field-by-field basis on
Output Field Specifications.
Field Explanation
Maximum Form Width Indicates the width of the form on which the requested report
is to be printed.
The range of values is 1 through 378, with a default of 132. If
the width of the report columns is greater that this number,
either the remaining columns will wrap to the next line or be
truncated, based on the Line Wrap setting (see below). Use the
Report Layout F13 to view the results of changing this field.
Line Wrap (Y/N) Allows line wrapping caused by selecting more output fields
than will fit on a print line.
Y If the width of the report columns is greater that the
Maximum Form Width, then the remaining fields wrap to the
next print line(s).
N Line wrapping will not occur and remaining fields are
truncated.
Note: You must specify Y to print all Summary Functions.
One Line per Page (Y/N) Prints each data record on a separate page when this option is
set to Y.
Total Level Text in Header Used with software that must detect a change in data in order
to perform a function, usually involving a page skip. If this
field is set to Y, the text from Total Level Hdr field in Data Sort
& Totaling will print above the column headings. Only one
total level should contain Hdr text if this feature is in use.
Y prints Total Header text above column headings. The default
is No.
Maximum records to query Indicates the maximum number of records to fetch from the
database and print. Any selected records after this count are
not output. The default value is *NOMAX (no maximum). The
value specified will not exceed the number of records specified
for the Create Physical File command (CRTPF) or maximum
spooled output records for printer file QSYSPRT.
Use this feature to verify the print format of a new query or
when a sample of the data is desired.
Print Queue A designation of a specific print queue, such as QPRINT.
If left blank, this field defaults to the print queue specified in
your user profile.
Output Media Destination of the version output. The following codes are
valid:
P Printed Output
F Disk File
X Rydex Fax Output. Print output is routed to output queue
QFAX for use with FAX/400 supported by IBM.
Packed to Zoned Flag used to assist the user in preparing files that contain
numeric data and are intended for transfer to a PC or other non
AS/400 system. Enter a "1" to cause World Writer to convert all
packed fields to zoned decimal when creating a file. This flag
has no impact on reports.
Output File Name of the output file to be created. Specify F in the Output
Media field. The file does not need to be created on the iSeries;
it will be created for you when the version is submitted and
completes normally.
Field Explanation
Output Library The name of the output library where the file will be created.
Specify F in the Output Media field. This library must already
exist on the iSeries.
To select fields
On Field Selection List
Enter X in the appropriate column or columns (Print, Select On, Sort By, and
so on) to select the fields and their function.
Enter 1 in the Option field to select the field for Print, Select On and Sort By.
The field will appear on all three setup screens, but can easily be removed if
not needed.
2. If creating a new version, review the fields "tagged" on the Field Selection List that
display on each subsequent screen.
3. If modifying or copying a version, choose F15 on each subsequent screen to
display the "tagged fields."
Field Explanation
Description Represents the field text specified in the Data Dictionary.
Print Displays on the Output Field Specifications screen. (V82104)
when selected.
Select On Displays on the Data Selection Screen (V82107) when selected.
Sort By Displays on the Data Sort and Totaling Screen (V82108) when
selected
Sum Sum or total the values in this field. This is only valid for
numeric fields.
Avg Calculates the average value of this field. This is only valid for
numeric fields.
Min The minimum or lowest value of this field. Negative numbers
are considered lower than zero or any positive number.
Character fields are compared according to the standard
EBCDIC collating sequence.
Max The maximum or highest value of this field. Negative numbers
are considered lower than zero or any positive number.
Character fields are compared according to the standard
EBCDIC collating sequence.
Cnt Count and print the number of records printed. In World
Writer the count function is not a distinct count. This value will
be the same no matter what field is selected.
Field Name The data item name of the field.
Caution: The Field Selection list is valid only for the current session.
Once you complete setup steps or press F3 to exit, the Field Selection
list is deleted. You can create a new list if you return to add fields to
this version later.
stored in a different file. Without the use of presumptive join fields, you would be
required to join both files in order to retrieve the related information.
On the Field Selection List screen, presumptive join fields are named with the file field
name plus a 2-digit extension. The fields are indented directly below the file fields.
These fields are only available for print.
For example:
GLKCO is a file field.
GLKCO01 is a presumptive join field that contains the company name.
GLDCT is a file field.
GLDCT01 and GLDCT02 are presumptive join fields with the description lines for
document type.
Field Explanation
Total Width Width calculated for you by adding together the length of
fields and column spacing.
Seq No A number that defines the relative order of the output fields.
For example, a sequence number of 10 will come before 20, and
so on.
Screen-specific information
Fields that have a Print When code of N (never), do not affect
the print sequence and therefore can have any sequence
number.
Description Represents the field text specified in the Data Dictionary.
Size Print size of the field. This can be reduced from the actual size
of the field to allow for truncating the printed output or
enlarged to allow for numeric editing characters.
The actual number of characters taken up for printing is the
larger of either the output size or the column heading.
W L (Wrap Line) Wraps this field down to the next print line. Enter Y to activate
this wrap feature. Line spacing is always single-spaced.
This is used to make this line of data appear directly below the
data in the prior line. Take care to properly calculate the
number of spaces to enter in the Col Sp (Column Spacing)
field.
Field Explanation
P W (Print When) Code identifying when to print a field value. Valid codes are:
A Always print the value (this is the default).
C Print each time the value changes.
N Never print the value. Used for derived or sort fields that
you do not want printed.
Col Sp (Column Spacing) Number of spaces before a column will print. The default for
*DF is determined from the value entered on Additional
Parameters (V82109) Default Column Spacing. Use with the
Wrap Line feature to align columns.
Sup Hdg (Suppress Heading) Suppresses Heading. Enter a Y to Suppress the Column
Headings for this field. This is typically used with the Wrap
Line feature.
Edt Cde Defaults from Data Dictionary. Use Field Sensitive Helps (F1)
to determine how numeric data is formatted when printed,
such as:
Whether a separator character prints
Whether zero or blank prints when data = 0
The character and position of negative numbers
Prt Dec The number of decimal positions to show in the edited print
field.
Num Scl The scale code is used to truncate quantity fields. This allows
you to show a quantity expressed in 100s, or 1,000s and so on.
Valid codes are:
0 No scaling. This is the default.
1 Divide by 10.
2 Divide by 100.
3 Divide by 1,000.
4 Divide by 10,000.
5 Divide by 100,000.
6 Divide by 1,000,000.
Output Field The name of the field in the file.
Field Description
Chain Field The name of the field for presumptive join fields used to
retrieve a related description field.
Server File The name of the file for presumptive join fields used to retrieve
a related description field.
From File File ID assigned when files are specified in Version Title &
Files. If blank, this is either a presumptive join field or a
calculated field.
Note: You must press Enter once to update the Total Width field and
enable the F13 key for Report Layout. Whenever you make a change
to the Output Field Specifications, you may impact the Total Width. A
highlighted field Description indicates where line wrapping occurs.
5.7.1 Options
1 - Work with Calculation
5 - Work with Field Detail Specifications
7 - Query File Update. Available when one file specified on Version Title & Files. See
Chapter 9.1, "About Updating Files" for details.
9 - Delete a field. You cannot delete a field if it is being used on Data Sort & Totaling.
World Writer converts Julian date fields to Gregorian if the Edit Code is equal to W:
If the size is equal to or less than 6, no separator character is used.
If the size is greater than 8, the 4-digit year is used.
Sizes less than 6 or equal to 9 will truncate the data, both in printed output and
output to file.
World Writer uses the Julian value if the Edit Code is other than W:
Printed output - Use an Edit Code that does not print a comma, such as C, D, L, or
M.
Output to File - If the Size is less than 6, the version will end in a job log with the
error "MCH1210 Receiver value too small to hold result." The size must be at least
6 if outputting to a physical file with an Edit Code other than W.
Field Explanation
Output Size Displays on Output Field Specifications and can be modified
from either screen. See Chapter 5.7, "Using Output Field
Specifications" for field descriptions.
Field Explanation
Print Decimal Displays on Output Field Specifications and can be modified
from either screen. See Chapter 5.7, "Using Output Field
Specifications" for field descriptions.
Edit Code Displays on Output Field Specifications and can be modified
from either screen. See Chapter 5.7, "Using Output Field
Specifications" for field descriptions.
Numeric Scale Displays on Output Field Specifications and can be modified
from either screen. See Chapter 5.7, "Using Output Field
Specifications"for field descriptions.
Column Spacing Displays on Output Field Specifications and can be modified
from either screen. See Chapter 5.7, "Using Output Field
Specifications" for field descriptions.
Column Title Column headings defaulted from Data Dictionary. You can
change the values on the screen. The three lines are 20
characters each and are automatically centered within the first
20 characters of the column.
Typically, the column heading should align with the size of the
field. The third line should be reserved for dashes. If 20 dashes
are entered, the line of dashes extends the full length of the
column.
Field Size Actual field size, as defined in the file. This is for reference
only; not input capable.
Actual Decimals Precision Provides the divide by factor for SQL. For file fields, this field
can differ from the Print Decimal field. For calculated fields,
this field must be the same as the Print Decimal field.
Date Format - From This field is obsolete.
Edit Code
Print Decimal
Numeric Scale
Column Spacing
Column Title
4. Enter a unique name in the following field:
Field Name
5. Press Enter. The Query Result Field Definition window displays.
Field Explanation
Description Value defaults from Output Field Specifications. You can
modify this field from this screen.
Size Value defaults from Output Field Specifications. You can
modify this field from this screen. For example, you may
determine that the size is not large enough to hold the result of
calculation.
Print Decimal Value defaults from Output Field Specifications. You can
modify this field from this screen.
Expression Used to enter the calculation. You can enter up to four lines
with 60 characters each. Enter a single value or use as many
operands and operators that will fit in the lines provided. You
can split values and field name at the end of a line and
continue it on the next line. In most cases, you do not need a
space between fields, values, and operators
Calculation Description
GBAN01 + GBAN02 + Adds the Net Posting fields from F0902
GBAN03 + GBAN04 +
GBAN05 + GBAN06
YASAL * 2.5 Multiplies the Annual Salary from F060116 by 2.5
Integer(YADSI / 1000 + 5) Adds 5 to the year portion of the Original Start Date from
F060116
GLMCU||'.'||GLOBJ||'.'|| Concatenates the Business Unit, Object and Subsidiary field
GLSUB into one field with a period between each value. 10.1110.BANK
Substr(YASSN,1,3)||'-'||sub Uses both the Substr and Concatenate operator to format the
str(YASSN,4,2)||'-'||substr( Employee Tax ID field from F060116 in a social security
YASSN,6,4) number xxx-xx-xxxx format. The expression starts with the first
position of the field and after 3 characters, insert a dash. Then
beginning in the 4th position for 2 characters, then another
dash. And finally start in the 6th position for 4 characters.
Calculation Description
Substr(Digits(ABAN8),3,5)||' Uses the digits operator to convert the Address Book Number
'||ABALPH from F0101 so that last 5 characters of the field can be
concatenated to the Alpha Name field with two spaces in
between. 10244 Sally Jones
Decimal((SDUORG * Creates a packed field multiplying the Quantity Ordered from
COUNCS),15,2) F4211 by the Unit Price from F4105. This field is defined as
fifteen packed characters with two decimal places
Field Explanation
And/Or A code that determines whether compound data selection logic
is based on an AND condition or an OR condition.
AND Combines and continues selection criteria. This is the
default.
OR Begins a new condition that consists of the OR line and
consecutive AND lines.
Description The description of the field that contains the data you want to
select on. The test field name is found in the fold area of this
screen.
Selection Test Specifies the Boolean Logic test to perform between the data
field and selection value. Use Field Sensitive Help F1 for a list
of valid values, also described in the Boolean Logic section.
Field Explanation
Selection Value Contains the values to compare against.
Field Sensitive Help F1 is useful in to obtain a list of valid
values if the field is attached to a User-defined Code table or a
Search window.
Use F1 to determine the correct field formatting for length and
type.
You do not need to know the Julian date format. Enter these
date fields as MMDDYY (or User Preference/System format).
The program will edit the entry for a valid date and format the
field correctly.
You can use a field name to compare with another field. The
exception is comparing a date field to another date field. See
Appendix D, "Data Select on Julian Date Fields" for this
procedure.
Numbers will be edited and displayed with the same decimal
positions as the field.
Alpha field entries must be enclosed in single quotes (') and
cannot be longer than the selection field length. Shorter strings
are compared as if the missing positions are blank.
If a character field is specified in Data Dictionary as having a
Data Display Rule of '*RAB', the field is right-justified with
leading blanks (see MCU as an example).
To select on a blank numeric field, type 0 (zero).
To select on a blank alpha field, type '' (2 single quotes).
See Appendix D, "Data Select on Julian Date Fields" for the
procedure to select on a blank Julian date field.
Field Explanation
Sequence Assigned by the program. If it is necessary to insert a line,
assign the sequence number so that it lies between the
sequence numbers of the lines before and after the selected
fields.
BU Edit (Y/N) Indicates that the data field is a Business Unit and may be
subject to Business Unit Security. Input incapable.
Field Name Used if you need to data select on a calculated field. Enter the
name of the field. Leave the File ID field blank.
File ID Assigned when files are specified in Version Title & Files. If
blank, this is a calculated field.
5.10.1 Options
5 - If any of the value or range tests are specified, a "+" in the option column indicates
that there are more values. Use Option 5 to display the Query Selection Values screen
to review or change the selections.
9 - Deletes a previously selected field.
You use OR when only one condition must be met, or when you want to begin a
new set of selection criteria.
Test Example
EQ (Equal to) Amount EQ 5000 retrieves only those records with amounts
equal to 5000
LT (Less than) Amount LT 5000 retrieves only those records with amounts
less than 5000
LE (Less than or equal to) Amount LE 5000 retrieves only those records with amounts
equal to or less than 5000
GT (Greater than) Amount GT 5000 retrieves only those records with amounts
greater than 5000
GE (Greater than or equal to) Amount GE 5000 retrieves only those records with amounts
equal to or greater than 5000
NE (Not equal to) Amount NE 5000 retrieves only those records with amounts
not equal to 5000
NL (Not less than) Amount NL 5000 retrieves only those records with amounts
not less than 5000
NG (Not greater than) Amount NG retrieves only those records with amounts not
greater than 5000
Test Example
LIKE (A certain part of an Name LIKE - __TIN retrieves those names that have two
alphanumeric field characters followed by TIN
containing the same
Name LIKE - %TIN% retrieves those names that contain TIN,
characters as the test value
no matter what characters are before or after it.
pattern
NLIKE (A certain part of the Name NLIKE - __TIN retrieves only those names that do not
field that does not contain the have two characters followed by TIN.
same characters as the test
Name NLIKE - %TIN% retrieves those names that do not
value pattern)
contain TIN no matter what characters are before or after it.
RANGE (No less than the Amount Range 5000 7000 retrieves records with amounts
first value and no greater between 5000 and 7000.
than the second value)
5000 and 7000 would be included.
NRANGE (Less than the first Amount Range 5000 7000 retrieves records with amounts that
value and greater than the are less than 5000 and greater than 7000.
second value)
5000 and 7000 would not be included.
VALUE or VALUES (Retrieve Selects multiple items.
the items listed)
NVALUE (Do not retrieve Omits multiple items.
items listed)
To Sort Data
On Data Sort & Totaling
1. Complete the following fields:
Seq (Sequence)
A/D (Ascending and descending)
2. Assign sequence numbers by 10s to the fields used for sorting.
Note: The highest sort field has the lowest sequence number. For
example, sort the data first by company. Within each company, the
system sorts the data by business unit, and within each business unit,
by object account. For example, the sequence numbers include 10
Company, 20 Business Unit, and 30 Object.
3. If the grand total does not display on the screen, choose F15. The grand total
should always be the last sequence number.
Note: All sorting fields must also display on the Output Field
Specifications screen, although they do not have to be printed
columns. If a field is used on the Data Sort & Totaling screen that does
not appear on Output Field Specifications, the program will add it as a
non-printed field by assigning it the next sequence number.
Note: You do not have to assign a total level to a Grand Total Level,
but you do have to specify a sequence number to include it.
Field Explanation
Seq Assigns a sequence number to order the sort fields. The lower
the number, the higher the sort priority. That is, a field with a
sequence of 20 will sort within the values of a field with a
sequence of 10.
A sequence number must be assigned to select a field for
sorting, and all sequence numbers will be renumbered in
increments of 10.
Description The field text specified in the Data Dictionary
A/D The code that specifies the ordering of the data in the sort field.
A Ascending - data is sorted from lowest to highest
D Descending - data is sorted from highest to lowest
Tot Lvl (Total Level) Used to define report break fields. A report break occurs every
time the contents of a break field change from one record to the
next. Break fields are tested from highest priority to lowest
(highest priority is the break field with the lowest number). A
report break at a given level will cause a break at all the lower
priority levels as well.
Break levels should be assigned in the same relative order as
the sort levels. That is, the highest assignable break level (level
1) should be assigned to the highest sort priority (the sort field
with the lowest sequence number). The next break level should
be assigned to some lower priority sort level and so on.
Field Explanation
Page Skip Y Indicates that a new page should be started when the value
of this field changes
S Indicates printing summarized information on this field
level
A total level must be specified for a page skip to occur.
Normally only one total level should specify page skipping.
Line Spc Indicates the number of lines to advance after printing this
total line. The default value (*DF) is the line spacing specified
in Additional Parameters.
A total level must be specified for this line spacing to occur.
Sum Fnc The code that specifies whether to print any summary
functions associated with this total level as entered on the Total
Level Summary Functions screen.
If N is entered, no total line data will print for this level, but
any page or line spacing will occur.
Sort Field This is the name of the field in the file.
From File The File ID identifies which file contains the requested field.
Field Explanation
Total Level Hdr Contains 60 characters to enter a subheading comprised of
literal text and/or field values that print before a group of
data. Use an & (ampersand) before a field name to initiate
printing the field value, i.e. &ABALPH.
On the Report Layout screen, literal text is shown and any
fields denoted with the ampersand (&) will appear as the
letter H.
Total Line Text Contains 60 characters to enter literal text and/or field values
that print after a group of data and before the summary
functions line. The Row Description from Data Dictionary
defaults on this line. This can be modified to desired text or
removed. Use the & (ampersand) before a field name to
initiate printing the field value, i.e. &ABALPH.
On the Report Layout screen, literal text is shown and any
fields denoted with the ampersand (&) will appear as the
letter D.
5.11.2 Options
1 - When you initially set up a Total Level, you are automatically taken to the Total
Level Summary Functions screen. Option 1 also takes you to this screen to review or
change the selections.
9 - Delete a previously selected field.
1. Assign summary functions to each Total Level one at a time, including the Grand
Total.
If you have three total levels and a Grand Total, and your report requires
summary functions at all four levels, you will need to access this screen four times.
Field Explanation
Description Represents the field text specified in the Data Dictionary.
Sum (Summary) Totals all values; valid for numeric fields only.
Avg (Average) Totals all values, then divides by the number of records; valid
for numeric fields only.
Min (Minimum) Prints the lowest value in the group for numeric fields.
Negative numbers are considered lower than zero or any
positive number.
For alpha fields, print the first alphabetical value. Character
fields are compared according to the standard EBCDIC
collating sequence.
Max (Maximum) Prints the highest value in the group For numeric fields.
Negative numbers are considered lower than zero or any
positive number.
For alpha fields, print the last alphabetical value. Character
fields are compared according to the standard EBCDIC
collating sequence.
Cnt (Count) Prints the number of records in the group. This value will be
the same no matter which field is selected at the total level.
Field Name The name of the field in the file.
File ID The File ID identifying which file contains the requested field.
5.12.1 Options
1 - Marks all summary functions with an X.
9 - Deletes a previously selected field.
F15 - Display the fields tagged on the Field Selection List. The tag list is active only for
the current session.
F16 - Display all fields in the selected files. You cannot assign summary functions to
any fields that do not appear as printed columns on Output Field Specifications.
World Writer uses the system printer file called QSYSPRT. If no overrides are entered,
the attributes of QSYSPRT are used.
These are standard IBM override options. A similar screen is used with DREAM
Writer, FASTR and STAR reporting tools.
Many of the available options are dependent on the type of printer you have and your
printer must support the entries you make.
It is best to initially leave the default attributes until a sample of the report has been
printed and reviewed. Then make any adjustments if needed.
You can access the Printer File Overrides screen by doing any of the following:
Enter 6 in the Option field on the Versions List (V82100).
Enter 1 in the Option field on the Selective Change Prompt.
Choose F5 on the Version Title & Files (V82101).
Field Explanation
Print Queue A designation of a specific print queue, such as QPRINT. If left
blank, this field defaults to the print queue specified in your
user profile.
Field Explanation
Hld in Prt Queue (Y/N) A flag used to determine whether to hold the print file in the
print queue rather than printing it.
Valid values are:
Y Hold on the print queue
N Do not Hold on the print queue
S Hold and Save on the print queue
T Do not Hold, but Save on the print queue
Note: You can use 1 for Y and 0 (zero) for N.
Number of Report Copies The number of copies of this report to be printed. One copy is
the default.
Save Spool File Indicates whether the spool file should be set to a SAV status
after printing.
Char./Inch (10/15) The horizontal printing density. This should be entered as the
number of characters per inch and must be supported by your
printer.
Form Type Specifies the type of forms to be used in the printer.
Lines/Inch (4/6/8/9) The line spacing should be entered as the number of lines per
inch and must be supported by your printer.
Location of Page Overflow A field used in the definition of a report version to indicate the
number of lines to be printed on a specific form before page
overflow is detected.
Maximum Form Length A field used in the definition of a report version to indicate the
length of the form on which the requested report is to be
printed. This is expressed in lines per page.
Maximum Form Width A field used in the definition of a report version used to
indicate the width of the form on which the requested report is
to be printed. This is the same field found on the Additional
Parameters screen (V82109). It can be changed from either
screen.
Printer Device Name Specifies the name of the printer device.
Intelligent Printer Specifies the type of data stream to create for a printer file.
Print Text The Print Text field specifies a character string that will be
printed at the bottom of each page of the specified report. A
maximum of 30 characters are allowed. Refer to "PRTTXT"
keyword of the "OVRPRTF" command on the iSeries.
To create a group
World Writer groups are stored in User Defined Code table System Code 82, UDC GR.
You can access this User Defined Code table a number of ways:
From the World Writer Versions List, in the Group field, press F1, and then press
F10.
Type Fast Path UDC on a command line. Or from Menu G00 take selection 14.
Inquire on System Code 82, User Defined Code GR.
The first 11 lines of the table are suggestions for group naming conventions, followed
by the existing group names.
On General User Defined Codes
See Also:
Chapter 10.1, "About Menu Setup,"
Chapter 11.1, "About Sleeper Setup,"
Chapter 12.2, "Copy Versions & Groups."
To create a file
On Additional Parameters
1. Change the Output Media field to F for file output.
2. Specify the name of the file in the Output File field. You do not need to create the
file first.
3. Specify the library where the file will reside. The library needs to exist on the
iSeries.
4. Enter a 1 in the Packed to Zoned field to convert all packed fields to zoned
decimal.
The Packed to Zoned field is used with creating files. This flag may be needed in
preparing files that contain numeric data and are intended for transfer to a non-iSeries
system. The default value is blank which indicates that packed fields will output as
packed.
Caution: It is easy to update fields with World Writer, but it may not
be easy to undo the changes if an error is made. Use the steps in the
following sections to verify the records that will be updated with the
new value of the field.
Read through the entire chapter, so that you are familiar with the update process.
Practice the update procedure in a test environment before impacting your
production data.
Navigation
From World Writer (G82), enter 27
From World Writer Advanced Operations (G8231), choose Query Group Level
Security
World Writer does not automatically allow a version to be run in the update mode.
Security must be set up by user to allow this access.
On Query Group Level Security
1. Inquire on the User ID that will be submitting the World Writer version for file
update.
2. If the User ID highlights, add the user and type the Group ID from the World
Writer Version in the subfile portion of the screen.
3. In the Fupd column, enter Y to allow update access, and press Enter.
4. Inquire on the User ID to ensure the record was added.
5. If the User ID already exists, change the record accordingly.
Navigation
From World Writer (G82), enter 27
From World Writer Advanced Operations (G8231), choose Field Level Security
On Field Level Security
1. Inquire on the User ID that will be submitting the World Writer version for file
update.
2. If the User ID is highlighted, complete the following fields:
User ID
File ID
3. If the User ID already exists, change the record to include the file for update.
4. If the file already appears in the list, enter Option 1 next to the file to review the
field for update.
5. Press Enter. All the fields from the file ID you entered will display.
6. Find the field to be updated and enter Y in the Upd column. You can also type the
Field Name on a blank line.
7. Press Enter.
8. Inquire on the User ID and File ID to ensure the record has been added.
9. If the User ID and File ID exist, choose F16 to include the field for update.
3. Enter the SOURCE field name in the From Field Name field. This is either the
calculated field or and existing file field that contains the value to be moved to the
TARGET field.
The system places the version in update mode. The update will take place when
you submit it. Submitting the version generates a report, however it will give no
indication that the update took place. World Writer writes the record as it
currently exists in the file, then runs the field update.
4. To take the version out of update mode, enter Option 7 next to the TARGET field
and remove the SOURCE field name.
2. Set up Group Level and File Level security for all the fields to be updated.
3. From Output Field Specifications, choose F18 to access the Query File Update
Specs screen, V82117.
This screen allows you to enter multiple TARGET and SOURCE field names at one
time. Using this screen takes the place of using Option 7 and puts the version in
update mode.
4. Submit the version in update mode, and then verify that the records were
updated.
5. To take the version out of update mode, access V82117 again and enter Option 9 to
delete the fields.
Topic Description
Updating Julian date fields The value must be entered in the Julian format, for example
103131 for May 11, 2003. See Appendix C, "Julian Date
Conversion Charts" for a Julian calendar conversion chart.
Updating an alphanumeric Enter two single quotes ('') as the expression.
field to Blank
You do not need a space between the quotes.
Topic Description
Updating a numeric field to Enter a zero (0) as the expression. If the field to be updated has
Blank decimal places, enter the expression as 0.00 with the correct
number of decimal places shown.
Error 2929 - 'Join files cannot You cannot use World Writer for a field update if the version
use file update' when has more that 1 file that it has written over. You cannot use a
putting option 7 next to a joined logical file and perform a field update.
field to be updated
Error 1778 - ' Field must be The field entered must be defined as a printing field on Output
selected for query output ' Field Specifications.
when typing a field name in
the From Field Name field
on the Update Spec window
Error 1761 - ' End of An attempt is being made to update an alphanumeric field
expression expected, not with a numeric value or vice versa. Check either the expression
found ' when typing a field on your calculated field or the field attributes if you are using a
name in the From Field field within the file for the SOURCE field.
Name field on the Update
Spec window
Error 1737 - ' Not authorized Press F18 on the Output Field Specification screen. The field(s)
to version ' when attempting under the To Field column includes fields used for updating
to run the version in update and must be in Field Level Security. If you have copied a
mode version that also performed an update, you may have copied
the Update Specs as well. Delete the field(s) that are not going
to be updated using Option 9.
No field update even when Check to see if you have a presumptive join field for the field
the version runs successfully you have updating. A presumptive join field will have the
(no job log) in update mode same field name with a numeric extension. For example,
GLMCU is the field you are updating. If you have GLMCU01
on the Output Field Specifications screen, the update will not
take pace. Delete the presumptive join field and submit the
version again.
Also, if the field you are updating appears more than once on
Output Field Specifications, the update will not take place.
Delete all but one occurrence of the update field.
Updating non-JD Edwards The file must be in your library list before Field Level Security
World files can be set up.
Topic Description
The results of the calculated One reason this may occur is how the field being updated is
field look as expected on the defined in Data Dictionary. The Data File Decimal field
report. However when describes the decimal places actually stored in the field. This is
verifying the updated normally 00 (zeros). The Display Decimals field contains a
records, the new value in the number of decimals that this field will display on videos and
field contains the wrong reports.
data.
There are some exceptions; one being when the value in the
Data File Decimals field is greater than 0 and the Display
Decimals field is blank.
To successfully update these types of numeric fields, change
the Prt Dec field on the Output Field Specifications screen to 0
for both the field to be updated and the calculated field. The
expression of the calculation should contain the correct
number of decimal places.
In the example below, the CRR field is defined in Data
Dictionary with 7 in the Data File Decimals and the Display
Decimals is blank. In order for this field to be updated
correctly, change the 7 to 0 on Output Field Specifications - Prt
Dec column. The calculated field, NEWCRR, is also set to 0 in
Prt Dec column and the expression contains the decimal places
desired. When this version is submitted, the TDCRR field
would be correctly updated with a value of 23.8500000.
However the report will look incorrect because without
decimal places, the value is rounded. In the example, the value
on the report would be 24.
When the menu selection is taken, what happens is determined by value in the Prompt
for Data Selection field See Chapter 5.5, "Using Additional Parameters" of the version.
If Prompt for Data Selections is blank or N, the version is submitted automatically
to batch.
If Prompt for Data Selection is Y, the Data Selection screen is presented to the user.
The user can make changes on the screen, if necessary. This ensures that record
selection is reviewed before the version is submitted. When the enter key is
pressed, the changes are saved and version is submitted to batch with the new
selection criteria.
Note: The User Exclusive field for the version must be either 0 or 1
in order for Prompt for Data Selections to be available.
The Option Code determines what happens when the Menu Selection and F18 are
pressed. The table below is for World Writer versions only:
1. Create a % menu containing the jobs you want to submit as a group. For a World
Writer version, complete the following fields:
Job to Execute = J82001
Batch = 1
Option Code = 2
Option Key = World Writer Group ID
Version = World Writer Version name
2. Add the % menu to an existing menu selection. Complete the following fields:
Job to Execute = J81900
Batch = 1
Option Code = 2
Option Key = % menu name
Version = ZJDE0001
The From and To Libraries are the libraries where the World Writer files reside. Either
of the fields can be *LIBL indicating that the copy is from or to the environment you
are signed into. If both of the libraries are *LIBL, then the copy should be from one
Group to another.
The From and To Groups can be identical, indicating that the copy is from one library
to another.
Field Explanation
Copy From Library The copy source library name.
Copy To Library The copy target library name.
Copy From Group The copy source group ID
Copy To Group The copy target group ID.
Field Explanation
Copy From Name Specify one of the following:
Version Name - Copies just that specific version.
*ALL or *ADD - Replaces versions with the same name,
adds any new versions. All remaining versions are left as
is.
*MATCH - Only copies versions that do exist in the To
Group, replacing them with the matching versions in the
From Group.
*NEW - Only copies versions that don't exist in the To
Group.
*REPLACE - Removes all versions in the To Group exist in
the To Group, and copy all versions in the From Group to
the To Group.
Field Explanation
Exc The user may execute versions in this group Y or N.
Add The user may add versions to this group Y or N.
Chg The user may change or modify versions in this group Y or N.
Dlt The user may delete versions in this group Y or N.
Fupd The user may update files using queries in this group Y or N.
If the User ID does not exist, change the action to A and enter the file in the
subfile portion of the screen.
If the User ID already exists, the file(s) are listed in the subfile. To add an
additional file, change the action code to C and enter the file at the bottom of
the list.
If the User ID exists and you wish to delete access, enter 9 in the Option field
next to one or more files.
2. When you have entered valid information on V94011, you are automatically taken
to a screen that lists all the fields in the file, V9401. It is only necessary to add
records where you wish to change the default access allowed.
The default for DSP (Display) is Y. Enter N to prevent user access to this field.
If the user includes this field on Output Field Specifications for a version, they
will not be able to submit the version. The following error is received: "1737
Not Authorized to Perform Opt. on Query."
The default for UPD (Update) is N. Enter Y to allow the user access to update
this field. This allows the user to successfully submit a version that updates
this field.
12.5.1 Options
1 - Display Field Level Security.
9 - Delete Field Level Security.
Field Explanation
User ID The user id that currently appears as the owner of the version
on the Versions List.
Group ID The Group where the World Writer versions reside.
The ampersand (&) is used to indicate all User IDs and/or all
Group IDs.
Security Code The new value to be updated for the User Exclusive field for
the versions impacted.
Use Field Sensitive Help F1 for the allowed values.
Delete (Y/N) The default is blank or N.
If Y - this will delete records from both Query Group Level
Security and the Field Level Security files.
A joined logical file can be used in place of two or more of the physical files needed for
the report. This is advantageous because the physical files are joined during the
creation of the logical. Also, duplicate records may be eliminated from the report and
performance may be improved when logical files are utilized.
Below is a partial list of some of the more common joined logical files. This
information was obtained from Software Versions Repository.
File ID Description
F00147JA Multi-Tiered Payment Terms Join F00147/F0014/F0411
F00147JB Multi-Tiered Payment Terms Join F00147/F0014/F0311
F0101JA JF - Address Suppl Data Information (F0101 F01092 F01093)
F0101JB JF - Address Mailing Labels (F0101 F0111 F0116)
F0101JC JF - Address Mailing Labels (F0101 F0116 F0401 F0301)
F0101JD JF - Address Mailing Labels (F0101 F0116 F0115)
F0101JE JF - Address Mailing Labels (F0101 F0116)
F0101JF JF - Supplier Analysis (F0101 F0401)
F01133JA JF - PPAT Message Distribution (F01133 F01131)
F0301JA JF - Customer and Address Information (F0101 F0301)
F0301JB JF - Customer Mstr & Customer Co/BU Default (F0301 & F03015)
F0315JA JF - A/R STATEMENTS ONLY - F0315/F0101/F0301 - Address No.
F03465JA JF - AR Netting Workfile (F0101/F03465) ABAN8/ROAN8
F0411JA A/P Payment File - JF (F0101/F0411) - ABAN8/RPPYE
F0411JB A/P 1099 Join File JF (F0411/F0414)
F0411JC A/P Report File - JF (F0101/F0411) - ABAN8/RPAN8
F0411JD A/P 'As Of' Build File - JF (F0411/F0414/F0413)
F0411JE A/P Payment File - JF (F0101/F0411) - ABAN8/RPPYE
F0413JA A/P Matching Doc File - JF (F0101/F0413/F0414) - Payment Id
F0414JB A/P - JF (F0413/F0414)
F0414JC A/P - JF (F0413/F0414/F09320)
F04571JA JF - F04571/F04572 - A/P Payment Information
F06146JA Joined Logical file - F060116 and F06146
7. Press Enter.
8. If no errors are detected, press enter again to return to Output Field Specifications.
9. Proceed to Data Selection. The actual join is done on this screen.
10. Access the detail area (F4).
C.1.1 Examples
D.1.1 Example 1
Find records in F060116 where the original date of employment field is blank. File:
F060116, Field: YADSI
D.1.2 Example 2
Find records in F0411 where the G/L date is not equal to the invoice date. File: F0411,
Fields: RPDGJ, RPDIVJ
Because of the editing associated with Julian date fields, the file fields cannot be used
for data selection. Error 0004 - Date Invalid or Missing - is received. A calculated field
needs to be created and used in place of the file fields. The following cover pages show
how to setup the World Writer.
For information on how to create a calculated field, see Chapter 5.9.1, "Operands for
Calculations" in the JD Edwards World World Writer Guide
The calculated field is named ORIGINAL. The expression for the calculated field is
DIGITS(YADSI). YADSI is the file field name. This field does not need to be a printed
field.
If this does not produce the desired results, the field may actually contain blanks
instead of zeros. Change the Data Selection as shown below to retrieve blank values.
The calculated fields are named ##DIVJ and ##DGJ. The expressions for the calculated
fields are the date field names from the file, RPDIVJ and RPDGJ. These fields do not
need to be printed fields.
E.2.1 Example 1
Business Unit range is AA400 through ZZ499. How does A1400 fit into this range?
Beginning comparison:
Is A greater than or equal to A? Equal - continue.
Is 1 greater than or equal to A? 1 is greater than A. 1 qualifies for the beginning range.
The first compare stops and the compare for the ending range starts.
Figure E2 Example 1
Ending comparison:
Is A less than or equal to Z? A is less than Z. A qualifies for the ending range. The
compare stops.
A1400 fits within the AA400-ZZ499 range.
E.2.2 Example 2
Selected users are set up with a Business Unit Security range of From: SALARY Thru:
SALARY. Users who should not have access to SALARY are set up with a range of
From: 1 Thru: 999999. On a World Writer report, these users are seeing records where
the Business Unit field is equal to SALARY. How does SALARY fall into the range of 1
thru 999999?
The Business Unit field is an alphanumeric field that is right justified. If one of the
fields contains fewer characters than the other, the field with the lesser number of
characters is "padded" with leading blanks until the From and Thru fields are the same
length. (When an alphanumeric field is left justified, the blanks are placed at the end of
the field until the fields are the same length.).
2. Set up Business Unit Security to make sure that it checks correctly regardless of
any alphanumeric/numeric mix of Business Units. Setting up two ranges, 1 thru
99999 and 100000 thru 999999, would allow users access to business units 1 thru
200000 but not to SALARY.
In some files the business unit field may be blank. This is valid. However, if business
unit security is in effect, a user would have to have a range of *BLANK to *BLANK
A example, 1-12
Data Selection screen, 5-22
Add a version, 3-2 Data sort & totaling, 1-13
Additiional parameters Data Sort screen, 5-29
example, 1-9 Delete a version, 3-5
Additional Parameters, 5-8 Display a version list, 10-2
Advanced operations, 12-1
AND/OR logic, 5-26
Apply E
field level security, 9-3 Examples
group level security, 9-2 business unit security, E-2
Assign Total levels, 5-28 calculations, 5-21
data selection for Julian date, D-1
B
Boolean logic, 5-27 F
Build currency factor file, 12-4 Fast path, 2-2
Business unit security Field detail specifications, 5-18
about, E-1 Field Detail Specifications screen, 5-18
examples, E-2 Field level security, 7-1, 12-6
hierarchy, E-1 Field Level Security screen, 9-3, 12-6
overview, 7-2 Field selection list
example, 1-10
C Field Selection List screen, 5-12
File relations, 1-7
Calculated fields, 5-19 File/Field Level Security screen, 9-4, 12-7
Change printer output, 5-35 Files
Common joined logical files, A-1 Joining, 5-4
Comparison Matched Records, 5-4
to FASTR features, 1-3 presumptive join fields, 5-17
to STAR features, 1-3 Finding files and fields, 4-1
Copy
version, 3-4
versions & groups, 12-2 G
Copy Other Versions & Groups screen, 12-2 General User Defined Codes screen, 6-2
Cover page, 3-7 Group level security, 7-1, 12-4
Create Groups, 6-1
calculated fields, 5-19
file, 8-1
version, 9-2 J
Job stream, 10-2
D Join files
chart, A-1
Data Selection examples, B-2
Julian date, D-1 join process, B-1
Data selection logical files, A-1, B-1
about, 5-22
Index-1
presumptive join fields, 5-17 General User Defined Codes, 6-2
soft join, B-1 Menu Revisions, 10-1, 10-2
Julian date Output Field Specifications, 9-5
data selection, D-1 Output field specifications, 5-13
example of data selection, D-1 Query File Update Specs, 9-7
examples, C-1 Query Group Level Security, 9-2, 12-4
format, C-1 Query Report Layout Display, 5-35
Query Result Field Definition, 5-20
Query Selection Values, 5-26
L Report Version Security, 12-8
Locate files and fields, 4-1 Total Level Summary Functions, 5-34
Unattended Night Operations Setup, 11-1
M Security, 7-1
Setup, 5-1
Master menu, 1-4 Sleeper setup, 11-1
Menu Revisions screen, 10-1, 10-2 Sorting data, 5-28
Menu setup, 10-1 SQL statements, 3-8
Menus, 1-4, 2-1 Submit a version, 10-1
Summary function, 5-32
O
Object level security, 7-2 T
Operands, 5-21 Technical considerations when creating a file, 8-1
Output field specifications Total level summary function example, 1-14
about, 5-13 Total Level Summary Functions screen, 5-34
field selection list, 1-11 Total levels
Output Field Specifications screen, 5-13, 9-5 about, 5-28
summary function, 5-32
P
Print a version, 3-6 U
Printer file override example, 1-15 Unattended Night Operations Setup screen, 11-1
Printer output, 5-35 Update
Process flow, 1-4 mode, 9-5
multiple fields, 9-7
Q records, 9-7
Query File Update Spec screen, 9-7
Query Group Level Security screen, 9-2, 12-4 V
Query Report Layout Display screen, 5-35 Version level security, 7-2
Query Result Field Definition screen, 5-20 Version list
Query Selection Values screen, 5-26 about, 1-5
overview, 3-1
R Version title and files
about, 1-6
Report Layout, 5-35
Report version security, 12-8
Report Version Security screen, 12-8 W
Revise a version, 3-3 Worksheet for version layout, 4-2
Run time programs, 1-16 World Writer
adding a version, 3-2
S additional parameters, 1-9
advanced operations, 12-1
Screens apply field level security, 9-3
Copy Other Versions & Groups, 12-2 apply group level security, 9-2
Data Selection, 5-22 build currency factor, 12-4
Data Sort, 5-29 business unit security, E-1
Field Detail Specifications, 5-18 comparison to DREAM Writer, FASTR, and
Field Level Security, 9-3, 12-6 STAR, 1-3
Field Selection List, 5-12 copy a version, 3-4
File/Field Level Security, 9-4, 12-7 copy versions & groups, 12-2
Index-2
cover page, 3-7
create a file, 8-1
create a version, 9-2
create calculated field, 5-19
create groups, 6-1
data selection, 1-12
data selection on Julian date, D-1
data sort & totaling, 1-13
deleting a version, 3-5
display version list, 10-2
fast path, 2-2
features, 1-1
field level security, 12-6
field selection list, 1-10
file output, 8-1
file relations, 1-7
files, 4-1
function keys, 3-2
group level security, 12-4
grouping, 6-1
job stream, 10-2
join logical files, A-1
julian dates, C-1
master menu, 1-4
menu, 2-1
menu setup, 10-1
options, 3-2
output field specifications, 5-13
output field specifications field selection list, 1-11
overview, 1-1
printer file override, 1-15
printer file overrides, 5-35
printing a version, 3-6
report version security, 12-8
revising a version, 3-3
run time programs, 1-16
security, 7-1
setup, 5-1
sleeper, 11-1
technical considerations, 8-1
total level summary function, 1-14
update mode, 9-5
update multiple fields, 9-7
verify updated records, 9-7
version list, 1-5, 3-1
version title and files, 1-6
worksheet, 4-2
Index-3
Index-4