Field List for Output Settings

Table 2.28 Field List for Data Processing Information (Output Settings)
Field name		Initial value	Possible settings		Omission possible	Remarks
Format		The format of the icon placed in the output area.	CSV, Format, Multi Format, Hierarchy Format, XML, Excel, Text, Database Table		No
Comment			Characters		Yes	255 bytes or fewer
Layout (Common)
	ID (#23)		Alphanumeric characters and symbols (#1)		No	50 bytes or fewer
	Output location (#4)	Fixed	Fixed, Use field values, Standard output		No	The Output location section does not appear if Database Table is selected as the format. Standard output does not appear as an option button if Excel is selected as the format.
	File name	(#5)	Windows	Characters (#2)	No	200 bytes or fewer
	File name	(#5)	UNIX	Alphanumeric characters and symbols (#3)	No	200 bytes or fewer
	Enabling output file changeover	OFF	ON, OFF		No	This is not displayed if the format is XML or Database Table.
	Delete 0-byte output files	OFF	ON, OFF		No	This is not displayed if the format is Database Table.
Layout (CSV)
	Omit ID	OFF	ON, OFF		No
	Delimiter	,	^, \|, ~, \, $TAB, $SPACE, $NULL, None, Enter hexadecimal		Yes	You can specify settings when the Omit ID is selected.
	Enclosure character (hexadecimal)		Hexadecimal character		*1
	Enclosure character	"	", #, $, %, &, ', (, ), ^, \|, ~, \, $TAB, $SPACE, None, Enter hexadecimal value		Yes
	Enclosure character (hexadecimal)		Hexadecimal character		*1
	Add enclosed characters to numeric data	OFF	ON, OFF		No	You can select a setting if the Omit ID is selected and the enclosure character is set to a value other than None.
	Handling of trailing spaces after character data	Trim	Trim, Do not trim, Compress		No
	Handling of leading zeroes in numeric data	Trim	Trim, Do not trim, Add a zero (0), Add a plus sign (+)		No
	Output a title line	OFF	ON, OFF		No
Layout (Format)
	Numeric value byte order	Same as host	Same as host Same as host, Big-endian, Little-endian		No
Layout (Multi Format, Hierarchy Format)
	Numeric value byte order	Same as host	Same as host Big-endian, Little-endian		No
	Zoned decimal zone	3	0 to 9, A to F		No	Hexadecimal value
	Zoned decimal sign (positive)	4	0 to 9, A to F		No	Hexadecimal value
	Zoned decimal sign (negative)	5	0 to 9, A to F		No	Hexadecimal value
	Packed decimal sign (positive)	4	0 to 9, A to F		No	Hexadecimal value
	Packed decimal sign (negative)	5	0 to 9, A to F		No	Hexadecimal value
Layout (XML)
	Handling of trailing spaces after character data	Trim	Trim, Do not trim, Compress		No
	Handling of leading zeroes in numeric data	Trim	Trim, Do not trim, Compress		No
	XML Schema instance attributes	Output	Output, Output only the default namespace, Do not output		No
	Schema location		Windows	Characters and symbols (#2)(#3)	Yes	200 bytes or fewer
	Schema location		UNIX	Alphanumeric characters and symbols (#3)	Yes	200 bytes or fewer
	XML version	1.0	1.0		No
	Standalone declaration	yes	yes,no,Do not output (#24)		No
	DTD handling	Internal	Internal, External		No
	Output empty-element tags	Do not output	Do not output, Output		No
	XML record unit	Custom	Custom, 1, 2, 3		No
	Indentation	Indent	Do not indent, Indent		No
	Add prefixes	ON	ON, OFF		No
Layout (Excel)
	－	－	－		－	－
Layout (Database Table)
	Numeric value byte order	Same as host	Same as host Big-endian, Little-endian		No
	Date (D)	Use default value	Use default value, NULL		No
	Character string (M, N, or W)	Use default value	Use default value, NULL		No
	Numeric character (Z)	Use default value	Use default value, NULL		No
Layout (Text)
	Line break after final record	Output	Output, Do not output		No
Code conversion
	Kanji code type (#20)	(#22)	Shift JIS, JEF, EUC, IBM kanji, KEIS, NEC kanji, UTF-16, UTF-8, JIS		No
	Unicode byte order (#20)(#21)	Same as host	Same as host, Big-endian, Little-endian		No	Displayed if UTF-16 is selected for the kanji code type.
	Unicode table (#7)	Same as host	Same as host, Windows, UNIX		No
	EBCDIC set (#8) (#16) (#20)		EBCDIC kana, EBCDIC lowercase, EBCDIC ASCII, EBCDIC ASPEN, Japan (Latin) for IBM, Japan (Latin) Extended for IBM, NEC Katakana, Japan (Katakana) Extended for IBM, ASCII (#10)		No
	Shift code (#20)	Add	Trim, Replace with spaces, Add, Do not add		No	You cannot select a setting if the kanji code type is JIS.
	KEIS fullwidth space (#20)	A1A1	A1A1, 4040		No	Specify if KEIS is selected for the kanji code type.
	Line break code (#17)	(#18)	Hexadecimal character		Yes	UTF-16: 4 or 8 bytes Other than UTF-16: 2, or 4 bytes
	BOM addition (#20)	(#9)	Add BOM, Do not add BOM		No
	Insert a line break after each record	(#14)	ON, OFF		No
	Path of the EBCDIC user table (#15)(#20)		Windows	Characters (#2)	Yes	200 bytes or fewer
	Path of the EBCDIC user table (#15)(#20)		UNIX	Alphanumeric characters and symbols (#3)	Yes	200 bytes or fewer
	Convert characters other than of JIS Level 1 or JIS Level 2 as well (#6)(#20)	ON	ON, OFF		No
	Fullwidth and halfwidth character conversion
	Kana conversion	Do not convert	Do not convert, Convert halfwidth to fullwidth, Convert fullwidth to halfwidth		No
	Alphanumeric conversion	Do not convert	Do not convert, Convert halfwidth to fullwidth, Convert fullwidth to halfwidth		No
	Symbol conversion	Do not convert	Do not convert, Convert halfwidth to fullwidth, Convert fullwidth to halfwidth		No
External characters (#16)(#19)
	Conversion table for external characters	Do not use	(#11)		No
	Handling of external characters that are not registered	(#13)	(#12)		No
	Path of the external character conversion table		Windows	Characters (#2)	Yes	200 bytes or fewer
	Path of the external character conversion table		UNIX	Alphanumeric characters and symbols (#3)	Yes	200 bytes or fewer

You can use only hyphen (-), underscore (_), period (.), left parenthesis ((), and right parenthesis ()).

External characters cannot be used. Operations are not guaranteed if you use any platform-dependent characters.

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

The Browse screen of the output file varies depending on the item selected in Output location.

Fixed: : Select file screen
Use field values: : Output File Name Settings screen

This field is set $STDOUT if Standard output is selected as the Output location.

This field is displayed only if Kanji code type is Shift JIS, IBM Kanji, UTF-8 or UTF-16.

This field is displayed only if Kanji code type is UTF-8 or UTF-16.

The conversion between UTF-8/UTF-16 and EBCDIC code, EBCDIC user table cannot be selected as EBCDIC set.

The initial value varies depending on the setting of Kanji code type.

UTF-8: : Do not add BOM
UTF-16: : Add BOM

#10

You can select this if JIS is specified for Kanji code type.

#11

The options displayed vary depending on the Code conversion settings of the input settings and output settings.

If the character encoding is the same as in the input settings: : Do not use, Use preferentially
If the character encoding is different from that of the input settings: : Do not use, Use, Use preferentially

#12

The options displayed vary depending on the Code conversion settings of the input settings and output settings.

If the character encoding is the same as in the input settings: : Do not convert
If the character encoding is different from that of the input settings: : Use default value, Treat as an error

#13

The initial value varies depending on the Code conversion settings of the input settings and output settings.

If the character encoding is the same as in the input settings: : Do not convert
If the character encoding is different from that of the input settings: : Use default value

#14

The initial value varies depending on the setting of Format.

If Format is CSV or XML	:	ON
If Format is a value other than CSV or XML	:	OFF

#15

This is displayed if Format is set to JEF, IBM kanji, KEIS, NEC kanji, or JIS.

#16

This is displayed if both of the following are selected in Format and Kanji code type:

The format is set to Format, Multi format, Hierarchy format, or Text.
The kanji code type is set to JEF, IBM kanji, KEIS, NEC kanji, or JIS.

#17

In output settings, you can specify this field in the following case:

The format is set to CSV or Text.
The format is set to Format, Multi format, Hierarchy format or XML, and Insert a line break after each record is selected.

#18

The initial value for the line break code depends on the OS where DataMagic Server runs. In DataMagic Desktop grade, the value is 0D0A.

#19

This is not displayed in DataMagic Desktop grade.

#20

You cannot specify this field in DataMagic Desktop grade.

#21

This is displayed if UTF-16 is set for the kanji code type.

#22

The value of the Encoding of input and output files (cs4file) specified in the system environment settings file (huledenv.conf).

#23

You cannot specify this field if Format is Text. You can omit this field for CSV.

#24

You can select whether or not to output the standalone attribute with the following:

Output: standalone="yes"
Output: standalone="no"
Do not output both standalone="yes" and standalone="no"

This field displays hexadecimal representations of the values set for Delimiter or Enclosure character.

Table 2.29 Field List for Data Processing Information (Output File Name Settings)
Field name	Initial value	Possible settings		Omission possible	Remarks
Field to use	Input field	Input field, Matching field, Fixed character string, Dynamic character string, End date, Start date, Input file path, Input file name, Serial number, Variable		No
Field name		Characters (#1)		No	255 bytes or fewer
Field No. (#3)		1 to 9999		No
Matching number (#4)		Matching setting quantity		No	3 bytes or fewer
Fixed character string (#5)		Windows	Characters (#2)	No	200 bytes or fewer
Fixed character string (#5)		UNIX	Alphanumeric characters and symbols (#1)	No	200 bytes or fewer
Dynamic character string (#6)	01	01 to 20		No
Format (#7)		Input field: Format ID registered with multi format in the input settings		No	End date, Start date: 1024 bytes or fewer
Format (#7)		End date, Start date: Halfwidth numeric		No	End date, Start date: 1024 bytes or fewer
Field number/Field name (#4)		Characters (#1)		No	255 bytes or fewer
Samples (#8)		(#11)			Double-click to set the selected information as the format
Input file path (#9)		Display only		No
Input file name (#10)		Display only		No
Serial number		Display only		No
Variable name		Characters (#2)(#10)		No	256 bytes or fewer
Format of the output location path and file name		The content specified in the Detailed Settings for Fields to Use screen is displayed.		Yes
Work file path		Result of the Select File screen		Yes

#1	:	You cannot specify left angle brackets (<), right angle brackets (>), double quotation marks ("), single quotation marks ('), or ampersands (&). Operations are not guaranteed if you use any platform-dependent characters.
#2	:	External characters cannot be used. Operations are not guaranteed if you use any platform-dependent characters.
#3	:	You can specify settings only if Input field is selected in Field to use, CSV is specified as the input format, and no ID is specified.
#4	:	You can specify this field only if Matching field in Field to use is selected.
#5	:	You can specify this field only if Fixed character string in Field to use is selected.
#6	:	You can specify this field only if Dynamic character string in Field to use is selected.
#7	:	Used as a combo box if Input field is selected for Field to use, and Multi Format is selected as the input format. This field is used as a text box if End date or Start date is selected for Field to use. You can specify this field only if Input file path is selected for Field to use.
#8	:	You can specify this field only if End date or Start date is selected for Field to use.
#9	:	You can specify this field only if Input file name is selected for Field to use.
#10	:	If you specified left parenthesis and right parenthesis, you cannot use $INAME for the value of this field. In this case, use $INUM instead.
#11	:	For Windows YYYYMMDD YYYYMMDDHHMISS MMDDYYYY DDMMYYYY For UNIX YYYYMMDD YYYYMMDDHHMISS MMDDYYYY DDMMYYYY

Table 2.30 Field List for Data Processing Information (Output Location Changeover)
Field name	Initial value	Possible settings	Omission possible	Remarks
Field to use	Number of output records	Number of output records, Input field, Matching field, Variable	No
Record number		1 to 9,999,999,999	No
Field name		Result of the Select field screen	No
Field number		1 to 9999	No
Format		Format ID registered with multi format specified in the input settings	No
Matching number		From 1 to the specified number	No	3 bytes or less
Variable name		Result of the Select variable screen	No