Generate Item Values
This screen is used to configure data that is to be generated.
Screen Image
lnd_018.jpg
Field Descriptions
Auto-Generation Information
Specifies the data item name to be replaced for the automatic generation data. Use the Browse button to select from the list of items in Select Item Name dialog box.
The Item Name field only accepts item names selected from the Select Items dialog , which is displayed when you click on the Browse button.  Only elementary items can be set.
Handling of OCCURS items differs according to the setting of the Show OCCURS Items checkbox in the Select Items dialog as indicated in the following table:
Checked Specify a data item name with a subscript.
Not checked Specify a data item name without a subscript.
Format Information
Type
Setup Default value The generated value is created using the existing format.
Setup Format The format is changed, and data is created according to the new format.
Format
Customizing of Format
Customize the format by checking the box.
Format
The new format is specified here.
Specifying a format:
A format is composed of an optional variable part and an optional fixed part. Either may be specified in any order.
Variable part Begins with character "%" (percent), followed by a value indicating the "Number of digits", and then a character denoting the new format.
Specification example: %9D
Number of digits The number of digits must equal the number of digits in the original format. If adding a fixed part to the new format, for every fixed part character added, the number of digits must be reduced by one character. If the format characters are "YMD" and "YMA", the number of digits can only be 2 or 4.
Format character D Numerical value with a sign. The value generated can be -9 to +9. Data items that can use this attribute are data items whose original format defined character data types (alphanumeric character items etc.) and numeric data types (external decimal items etc.).
U Numerical value without a sign. The value generated can be 0 to 9. Data items that can use this attribute are data items whose original format defined character data types (alphanumeric character item etc.) and numeric data items without a sign (external decimal items etc.).
s Small alphabetic letter of normal width. The range of the value generated can be a to z. Data items that can use this attribute are data items whose original format defined character types (alphanumeric character item etc.).
S Normal width alphabetic capital letter. The  value generated can be A to Z. Data items that can use this attribute are data items whose original format defined character types (alphanumeric character item etc.).
YMD Date (Only valid dates are accepted). The value generated is a valid date. Data items that can use this attribute are data items whose original format defined character types (alphanumeric character item etc.).
YMA Date (will accept both valid and invalid dates). The value generated is a valid date. Data items that can use this attribute are data items whose original format defined character types (alphanumeric character item etc.).
T Time
The range of specifiable values is 000000 (0:0:0) to 235959 (23:59:59).
The number of characters cannot be specified for the variable part.
The item attribute which can be specified is a character type (alphanumeric character item etc.).
TS YMD + Time
The range of specifiable values is 19700101 090000 (9:00:00, January 1, 1970) to 20380119 031407 (3:14:7, January 19, 2038).
The number of characters cannot be specified for the variable part.
The item attribute which can be specified is a character type (alphanumeric character item etc.).
Fixed part The fixed part of a format is a string enclosed by single quote characters ('). When a fixed part is added to a format, the characters enclosed in the single quote characters are added to the data item as a literal.
Specification example '9999'
Format Example
This list box displays the list of system registered formats (%D, %U, %s, %S, %YMD, %YMA, %T, %TS), as well as those formats that were added by the user.  User added formats can be deleted; system registered formats cannot be deleted.
Range Specification
Start Value
The start value of the variable part of the format is set in this entry field. If the format contains two or more variable parts, delimit the starting values with the "," character (comma). The start value should be a value that is compatible with the corresponding format.
End Value
The end value of the variable part of the format is set in this entry field. If the format contains two or more variable parts, delimit the starting values with the "," character (comma). The end value should be a value that is compatible with the corresponding format.
Increment Value
The increment value of the variable part of the format is set in this entry field. Specify values within the range of from -9 to +9.
Operation when end value is exceeded
The behavior of the automatic generation of data when the value of the variable part exceeds the end value is selected here. Choose from "Initializing" or "Repeat from the beginning value".
Examples
Format: D (Numerical value with a sign)
Example 1) To update the item defined by PIC S9(5) on 100 existing records for the value of 101 - 200 respectively:
Format %5D
Start Value +00101 (acceptable as 101)
End Value +00200 (acceptable as 200)
Increment Value 1
Example 2) To update the item defined by PIC S9(5) on 100 existing records for the value of 50 to -49 respectively:
Format %5D
Start Value +00050 (acceptable as 50)
End Value -00049 (acceptable as -49)
Increment Value -1
Format: U  (Numerical value without sign)
Example 1) To update the item defined by PIC 9(5) on 100 existing records for the value of 101 - 200 respectively:
Format %5U
Start Value 00101(acceptable as 101)
End Value 00200(acceptable as 200)
Increment Value 1
Example 2) To update the item defined by PIC X(10) on 100 existing records for the value of ABCDE00001 - ABCDE00100 respectively:
Format 'ABCDE'%5U
Start Value 00001(acceptable as 1)
End Value 00100(acceptable as 100)
Increment Value 1
Format: s (Small alphabetic letter of normal-width)
Example 1) To update the item defined by PIC X(5) on 100 existing records for the value of aaaaa - aaadv respectively:
Format %5s
Start Value aaaaa
End Value aaadv
Increment Value 1
Example 2) To update the item defined by PIC X(10) on 100 existing records for the value of aaaaa10cc - aaadv10fx respectively.
Format %5s'10'%2s
Start Value aaaaa,cc
End Value aaadv,zz
Increment Value 1
Format: S (Normal-width alphabetic capital letter)
Example 1) To update the item defined by PIC X(5) on 100 existing records for the value of ZZZZZ - ZZZWE respectively.
Format %5S
Start Value ZZZZZ
End Value ZZZWE
Increment Value -1
Example 2) To update the item defined by PIC X(10) on 100 existing records for the value of AAAAAAAAXX - AAADVADVXX respectively.
Format %5S%3S'XX'
Start Value AAAAA,AAA
End Value AAADV,ADV
Increment Value 1
Format: YMD (date:no error)
Example 1) To update the item defined by PIC X(8) on 100 existing records for the value of 20000101 - 20000410 respectively.
Format %4YMD
Start Value 20000101
End Value 20000410
Increment Value 1
Example 2) To update the item defined by PIC X(6) on 100 existing records for the value of 000101 - 000410 respectively.
Format %2YMD, or %YMD
Start Value 000101
End Value 000410
Increment Value 1
When the year is represented by two digits, such as 99 and  02, then 99<02.
Format: YMA (date:with error)
Example 1) To update the item defined by PIC X(8) on 100 existing records for the value of 20000101 - 20000407 (the value of the error inclusive on the way) respectively.
Format %4YMA
Start Value 20000101
End Value 20000407
Increment Value 1
Example 2) To update the item defined by PIC X(6) on 100 existing records for the value of 990701 - 991007 (the value of the error inclusive on the way) respectively.
Format %2YMA, or %YMA
Start Value 990701
End Value 991007
Increment Value 1
When the year is represented by two digits, such as 99 and 02, then 99<02
Format: T (time)
Example 1) To update the item defined by PIC X(6) on 100 existing records for the value of 100001 - 100140 respectively.
Format %T
Start Value 100001
End Value 100140
Increment Value 1
Processing number 100
Format:TS (date+time)
Example 1) To update the item defined by PIC X(15) on 100 existing records for the value of 20000101 100001 - 20000407 100140 respectively.
Format %TS
Start Value 20000101 100001
End Value 20000407 100140
Increment Value 1
Processing number 100