Field List for Mapping Information

Table 2.24 Field List for Data Processing Information (Mapping Information / Input Side)

Field name

Initial value

Possible settings

Omission possible

Remarks

Field name

 

Display only

 

 

Field No.

 

Display only

 

 

Comment

 

Display only

 

 

Fixed/Variable length

 

Display only

 

 

No. of occurrences

 

Display only

 

 

No. of bytes

 

Display only

 

 

Number of digits after the decimal point

 

Display only

 

 

Field type

 

Display only

 

 

Input delimiter

 

Display only

 

 

Input delimiter value

 

Display only

 

 

Output delimiter

 

Display only

 

 

Output delimiter value

 

Display only

 

 

Constant

 

Display only

 

 

Multiple

 

Display only

 

 

Reference field name

 

Display only

 

 

name

 

Display only

 

 

type

 

Display only

 

 

minOccurs

 

Display only

 

 

maxOccurs

 

Display only

 

 

default

 

Display only

 

 

empty

 

Display only

 

 

Variable name

 

Display only

 

 

Variable type

 

Display only

 

 

Initial value

 

Display only

 

 

Cell

 

Display only

 

 

Column

 

Display only

 

 

 

Table 2.25 Field List for Data Processing Information (Mapping Information / Output Side)

Field Name

Initial value

Possible settings

Omission possible

Remarks

Field name

 

Display only

 

 

Field No.

 

Display only

 

 

Comment

 

Display only

 

 

Fixed/Variable length

 

Display only

 

 

No. of occurrences

 

Display only

 

 

No. of bytes

 

Variable length 1 to 99999 (#1)

Yes

 

Number of digits after the decimal point

0

0 to 9

Yes

 

Field type

 

9,B,F,I,M,N,P,S,X,D,Z,W

Yes

 

Initial number of bytes

 

Display only

 

 

Initial number of digits after decimal point

 

Display only

 

 

Initial field type

 

Display only

 

 

Input delimiter

 

Display only

 

 

Input delimiter value

 

Display only

 

 

Output delimiter

 

Display only

 

 

Output delimiter value

 

Display only

 

 

Constant

 

Display only

 

 

Multiple

 

Display only

 

 

Reference field name

 

Display only

 

 

name

 

Display only

 

 

type

 

Display only

 

 

minOccurs

 

Display only

 

 

maxOccurs

 

Display only

 

 

default

 

Display only

 

 

empty

 

Display only

 

 

Handling of trailing
spaces after character data

Same as output settings

Same as output settings,
Trim, Do not trim,
Compress

No

 

Handling of leading
zeros in numeric data

Same as output settings

Same as output settings
Trim, Do not trim,
Add a zero (0), Add a plus sign (+)

No

 

Concatenation sequence

 

Display only

 

 

Key

 

Display only

 

 

Fullwidth and halfwidth kana conversion

Same as output settings

Same as output settings, Do not convert,
Convert halfwidth to fullwidth, Convert fullwidth to halfwidth

No

 

Fullwidth and halfwidth alphanumeric conversion

Same as output settings

Same as output settings, Do not convert,
Convert halfwidth to fullwidth, Convert fullwidth to halfwidth

No

 

Fullwidth and halfwidth symbol conversion

Same as output settings

Same as output settings, Do not convert,
Convert halfwidth to fullwidth, Convert fullwidth to halfwidth

No

 

Handling of 0-byte input data

Same as output settings

Same as output settings
Use default value, NULL

No

 

Variable name

 

Display only

 

 

Variable type

 

Display only

 

 

Initial value

 

Display only

 

 

Cell

 

Display only

 

 

Column

 

Display only

 

 

#1

:

If Variable length is selected, No. of bytes, Number of digits after the decimal point, and Field type cannot be changed.

 

Table 2.26 Field List for Data Processing Information (Mapping Information / Output Information Settings)

Field name

Initial value

Possible settings

Omission possible

Remarks

Type

Input field

Input field, Numeric operations, Query value, Common components, Fixed value, Date operations, User exit program

No

The order of types varies depending on frequency of use by the user.

Type = Input field

 

Field name

 

Input side fields linked by connections

No

 

Start position

1

1 to 99,999

No

 

Output size

 

1 to 99,999

Yes

 

Function 1

 

Characters

Yes

9999 bytes or fewer

Function 2

 

Characters

Yes

9999 bytes or fewer

Function 3

 

Characters

Yes

9999 bytes or fewer

Function 4

 

Characters

Yes

9999 bytes or fewer

Function 5

 

Characters

Yes

9999 bytes or fewer

Function 6

 

Characters

Yes

9999 bytes or fewer

Function 7

 

Characters

Yes

9999 bytes or fewer

Function 8

 

Characters

Yes

9999 bytes or fewer

Function 9

 

Characters

Yes

9999 bytes or fewer

Function 10

 

Characters

Yes

9999 bytes or fewer

Function list

 

Display only

 

 

Function list help

 

Display only

 

 

Type = Numeric operations

 

Formula

 

Alphanumeric characters and symbols (#1)

No

1024 bytes or fewer

Value list

 

Display only

 

 

Type = Query value

 

Query value category

 

Fixed character string, Dynamic character string (runtime argument)

No

 

Query value

 

Fixed character string: SQL statement

No

9999 bytes or fewer

Dynamic character string (runtime argument): 01 to 02

No

 

Virtual table name

 

Display only

 

 

Field Name

 

Display only

 

 

Value list

 

Display only

 

 

No-hit behavior

Return a null character

Return a null character, Return an error

No

 
 

Function 1

 

Characters

Yes

9999 bytes or fewer

Function 2

 

Characters

Yes

9999 bytes or fewer

Function 3

 

Characters

Yes

9999 bytes or fewer

Function 4

 

Characters

Yes

9999 bytes or fewer

Function 5

 

Characters

Yes

9999 bytes or fewer

Function 6

 

Characters

Yes

9999 bytes or fewer

Function 7

 

Characters

Yes

9999 bytes or fewer

Function 8

 

Characters

Yes

9999 bytes or fewer

Function 9

 

Characters

Yes

9999 bytes or fewer

Function 10

 

Characters

Yes

9999 bytes or fewer

List of computational functions

 

Display only

 

 

Function list help

 

Display only

 

 

Type = Common Components

 

Field name

 

Input side fields linked by connections

No

 

ID

 

Reference from the Select ID screen

No

If ID is entered, the Verify button is activated.

Comment (#2)

 

Display only

 

 

Argument n (#2)

 

Specify arguments

 

The number of arguments displayed is required by the definition of the component.

Type of argument (#2)

 

Display only

 

 

Comment of argument (#2)

 

Display only

 

 

Type = Fixed value

 

Category

Fixed character string

Fixed character string(#3), Dynamic character string (runtime argument), Date, Time, Fixed binary value,
Dynamic value (binary)

No

 

Value

 

Same as the value set for Category

No

 

Samples

 

Display only

 

 

Function (#4)

 

Characters

Yes

9999 bytes or fewer

Function list (#4)

 

Display only

 

 

Function list help (#4)

 

Display only

 

 

Type = Date operations

 

Formula

 

Alphanumeric characters and symbols

No

1024 bytes or fewer

Value list

 

Display only

 

 

#1

:

You cannot specify left angle brackets (<), right angle brackets (>), double quotation marks ("), single quotation marks ('), or ampersands (&).

#2

:

This is displayed when ID is entered.

#3

:

If Fixed value is selected for Type and Fixed character string is selected for Category, control characters can be used. To use control characters, specify 1 (enable use) for Use control characters inside a fixed value (ed_fixvalue_ctrlchar_flag) in the system environment settings file (huledenv.conf).

#4

:

This item is displayed only if Dynamic character string (runtime argument) or Dynamic binary value is selected for Category.

 

Table 2.27 Field List for Data Processing Information (Mapping Information / Output format)

Field name

Initial value

Possible settings

Omission possible

Remarks

Format

Standard

Standard, Date, Numeric character string, Character string

No

 

Format = Date

 

Format

 

Characters (#1)

No

1024 bytes or fewer

Samples

YYYY/MM/DD HH:MI:SS

YYYY/MM/DD HH:MI:SS,
YYYY-MM-DD HH:MI:SS,

YYYY-MM-DD,

MON DD YYYY,MONTH DD YYYY,

MM.DD.YYYY HH12:MI:SS AM,

DD-MM-YYYY,DD.MM.YYYY

 

 

Handling of null characters

Execution start date

Execution start date, Null

No

 

Format = Numeric character string

 

Sign output

Add to negative values only

Add to negative values only, Add nothing (absolute value),
Add to both positive and negative values

No

 

Significant digits after decimal point

Undefined

Custom, Undefined

No

 

0

0 to 9

No

(#2)

Handling of digits after the last significant digit

Round to the nearest value (up for 5 and above)

Round to nearest value (up for 5 and above), Round up, Round down

No

 

Digit delimiter

Do not add

Add, Do not add

No

 

Currency symbol

Undefined

Undefined, \, $

No

 

Padding method

Left-justified

Left-justified, Right-justified and padded with zeros (0),
Right-justified and padded with spaces

No

 

Padding size

(Numeric character string)

Undefined

Custom, Undefined

No

 

 

1 to 99,999

No

(#2)

Handling of null characters

Treat as zero (0)

Treat as zero (0), Null

No

 

Format = Character string

 

Output method

Left-justified

Left-justified, Right-justified

No

 

Output size

(Character string)

Custom

Custom, Undefined

No

 

 

1 to 99,999

No

(#2)

#1

:

If the Field type is X, you cannot specify EE, EEYY, eeyy, or 2-byte codes.

#2

:

Specify if Custom is selected.