utlediupdt (Command to import management information)

-f filename

Specify the name of the export file you want to register. (This parameter cannot be omitted.)

-r|-m

Specify whether to update IDs that have already been registered. (This parameter can be omitted.)

-r

: Updates IDs that have already been registered.

-m

: Does not update IDs that have already been registered.

If there is any ID that has already been registered, a warning message is displayed but this is not an error.

An error occurs if this parameter is omitted when one or more IDs are registered.

-k {E|S|8}

Encode for the export file (This parameter can be omitted.)

If you omit this parameter, the following value is applied to the processing.

For Windows

:Shift JIS

Note that UTF-8 will be applied if the character code (system locale) in Windows is UTF-8.

For UNIX

:Value of the Local host kanji code type (knjcode) in the system environment settings file (huledenv.conf)

a) Data processing information format

For details about each field, see Data processing information.

PRMID,ID-character-string 
#ACCOUNT,name-of-updating-user …… This is not output in the DataMagic Desktop grade. 
[GRPID,business-group-name] 
ENCFNAME,__PRMID_FILE__ 
data-processing-schema 
[IDLIST,ID list] 
[COMMENT,comment] 
#STIME,date-and-time-of-last-update 
END

b) CSV information format

For details about each field, see CSV information.

CSVID,ID-character-string 
#ACCOUNT,name-of-updating-user　…… This is not output in the DataMagic Desktop grade. 
[GRPID,business-group-name] 
TOKEN,enclosure-character,delimiter
      ………………… Use hexadecimal figures to enter enclosure characters and delimiters. 
[COMMENT,comment] 
#STIME,date-and-time-of-last-update 
ITEM,field-name 
[ITEM_COMMENT,field-comment]…If there are multiple ITEM lines, make sure that you specify this field immediately after each ITEM line. 
END

c) Format information format

For details about each field, see Format information.

FMTID,ID-character-string 
#ACCOUNT,name-of-updating-user
   ……… This is not output in the DataMagic Desktop grade. 
[GRPID,business-group-name] 
SIGN,zone-sign,output-external-sign-(positive),output-external-sign-(negative),
output-internal-sign-(positive),output-internal-sign-(negative)
   ……… Use hexadecimal character strings to specify the zone, output external signs 
       (positive and negative), and output internal signs (positive and negative). 
 
[SIGN_IN,input-external-sign-(positive),input-external-sign-(negative),input-internal-sign-(positive),input-internal-sign-(negative)]
   ……… Use hexadecimal character strings to specify the input external signs 
       (positive and negative) and input internal signs (positive and negative). 
       If you omit this tag, the settings for the output signs specified in the SIGN line are referenced. 
 
[COMMENT,comment] 
#STIME,date-and-time-of-last-update 
ITEM,field-name,validity,[parent-field],number-of-occurrences],number-of-bytes,[digits-after-decimal-point],field-type
   ……… Validity (0 = disabled, 1 = enabled) 
       Specify the parent field by using the field name. (If you omit the parent field, no parent" is assumed.) 
[ITEM_COMMENT,field-comment]
   ……… If there are multiple ITEM lines, make sure that you specify this field 
       immediately after each ITEM line. 
 
ITEMD,field-name,validity,[parent-field],[number-of-occurrences],delimiter-(input),delimiter-(output),field-type,addition-upon-output,
addition-upon-input,[digits-after-decimal-point]
   ……… Validity (0 = disabled, 1 = enabled) 
       Specify the parent field by using the field name. (If you omit the parent field, "no parent" is assumed.) 
       Specify the parent field by using the field name. (If you omit the parent 
       field, "no parent" is assumed.) 
       Addition upon output/input (0 = do not add, 1 = add) 
[ITEM_COMMENT,field-comment]
   ……… If there are multiple ITEM lines, make sure that you specify this field 
       immediately after each ITEM line. 
 
ITEMR,field-name,validity,[parent-field],[number-of-occurrences],reference-field,multiple,field-type,constant,[digits-after-decimal-point] 
   ……… Validity (0 = disabled, 1 = enabled) 
       Specify the parent field by using the field name. (If you omit the parent field, "no parent" is assumed.) 
[ITEM_COMMENT,field-comment]
   ……… If there are multiple ITEM lines, make sure that you specify this field 
       immediately after each ITEM line. 
END

• ITEM is used to specify the fixed length. You can specify multiple fixed lengths.

• ITEMD is used to specify the variable length delimiters. You can specify multiple variable-length delimiters.

• ITEMR is used to specify the variable field reference. You can specify multiple variable-field references.

d) Multi format information format

For details of each field, see Multi format information.

MFMTID,ID-character-string 
#ACCOUNT,name-of-updating-user
   ……… This is not output in the DataMagic Desktop grade. 
#Type,Settings type(0:Unified settings, 1:Separate settings) 
TYPE,Settings type
   ……… Settings type (0:Unified settings, 1:Separate settings) 
       (If you omit this field, 0 is assumed.) 
[GRPID,business-group-name] 
KEY,key-start-position,key-length [key-category]
   ……… Displayed when unified settings is used.
   ……… Key category (0 = character, 1 = binary) (If you omit this field, 0 is 
       assumed.) 
[DEFAULT,default-format-ID] 
[COMMENT,comment] 
#STIME,date-and-time-of-last-update 
#ITEM,key-value,format-ID 
ITEM,key-value,format-ID
   ……… Displayed when unified settings is used.
   ……… If the key category is binary, specify the key value by using hexadecimal 
       digits. 
[ITEM_COMMENT,field-comment]
   ……… If there are multiple ITEM lines, make sure that you specify this field 
       immediately after each ITEM line. 
 
#ITEMI,format-ID,conditional logic formula 
#ITEMIV,start position,key category(0:Character 1:Binary 2:Extension),scope of keys,key value 
ITEMI,format-ID,conditional logic formula
   ……… Displayed when separate settings is used.
   ……… If the key category is binary, specify the key value by using hexadecimal 
       digits. 
[ITEM_COMMENT,comment] 
   ……… If there are multiple lines of ITEMI and/or ITEMIV in the file, 
       specify the command line immediately after the target ITEMI line. 
ITEMIV,start position,key category,scope of keys,key value 
ITEMIV,start position,key category,scope of keys,key value 
         : 
[ITEMI,format-ID,conditional logic formula] 
[ITEM_COMMENT,comment] 
[ITEMIV,start position,key category,scope of keys,key value] 
END

• KEY is used when the unified settings is selected.

• ITEM is used when the unified settings is selected. ITEMI and ITEMIV are used when the separate settings is selected.

e) Hierarchy format information format

For details about each field, see Hierarchy format information.

HFMTID,ID-character-string 
#ACCOUNT,name-of-updating-user 
   ……… This is not output in the DataMagic Desktop grade. 
[GRPID,business-group-name] 
[COMMENT,comment] 
#STIME,date-and-time-of-last-update 
 
RECORD,field-name,[parent-field],format-ID,occurrence-condition,key-start-position,key-value,no-hit-behavior
   ……… Specify the parent field by using the field name. (If you omit the parent 
       field, "no parent" is assumed.) 
       Occurrence condition (N = no conditions, A = key match, B = key match (binary)) 
       No-hit behavior (E = error, D = use the default value, P = treat as normal and 
       use previous value) 
[ITEM_COMMENT,field-comment]
   ……… If there are multiple ITEM lines, make sure that you specify this field 
       immediately after each ITEM line. 
 
GROUP,field-name,[parent-field],maximum-number-of-occurrences,escape-condition,key-start-position,key-value
   ……… Specify the parent field by using the field name. (If you omit the parent 
       field, "no parent" is assumed.) 
       Specify the maximum number of occurrences by using either a numeric value or 
       the name of a reference field. 
       You can specify a numeric value from 1 to 999999999. 0 indicates infinity. 
       To specify the reference field name, use the format &field-name&format-ID-field. 
       Escape condition (N = no conditions, A = key match, B = key match (binary)) 
[ITEM_COMMENT,field-comment]
   ……… If there are multiple ITEM lines, make sure that you specify this field 
       immediately after each ITEM line. 
END

f) XML information format

For details about each field, see XML information.

XMLID,ID-character-string 
#ACCOUNT,name-of-updating-user …… This is not output in the DataMagic Desktop grade. 
[GRPID,business-group-name] 
SCHEMA,category ... Category (X = XML schema, D = DTD) 
FNAME,import-file-name 
ENCFNAME,__XMLID_IMPORT_FILE 
encoded-import-file 
[COMMENT,comment] 
#STIME,date-and-time-of-last-update 
END

g) Excel information format

For details about each field, see Excel information.

EXCELID,ID-character-string 
#ACCOUNT,name-of-updating-user
     ……… This is not output in the DataMagic Desktop grade. 
[GRPID,business-group-name] 
MST_BOOK,management-Excel-file-name 
SHEETNAME,target-sheets 
IN_PARAM,target-sheets,handling-of-cells-with-errors,inital-row-number-for-table-read-operation,
table-read-operation-end-condition,detailed-read-conditions 
   ……… Target sheets (A: all sheets, S: specified sheets, I: ignore specified sheets) 
       Handling of cells with errors (E: error, I: ignore) 
       Initial row number for table read operation (a value from 1 to 1048576 or 0) (If you omit this field, 0 is assumed.) 
       Table read operation end condition 
       (1: end of data 
        2: empty record 
        3: empty row in a specified column 
        4: specified row 
        5: row containing an empty cell) 
       Detailed read conditions 
       (If the table read operation condition is 2, 
	specify the end row number (initial row number to 1048576). 
        If the table read operation condition is 4, 
	specify the column number (A to XFD). 
        If the condition to end table read operation is not 2 or 4, 
	do not specify any value (enter only a comma)). 
OUT_PARAM,target-sheets,initial-row-number-of-table,wheter-to-use-template 
   ……… Target sheets (S = single, M = multiple) 
       Initial row number of table (Specify a value from 1 to 1048576.) 
       Whether to use a template (Y = use, N = do not use) 
TEMPLATE_FILENAME,template-file-name 
TEMPLATE_SHEETNAME,template-sheet-name 
[COMMENT,comment] 
#STIME,date-and-time-of-last-update 
ITEM,field-type,cell-number,field-name 
   ……… Field type (Z, M, or D) 
	Cell number (a value from A to XFD for table specification, 
	a value from A1 to XFD1048576 for cell specification) 
[ITEM_COMMENT,field-comment] 
END

h) Database table information format

For details about each field, see Database table information.

DBID,ID-character-string 
#ACCOUNT,name-of-updating-user
     ……… This is not output in the DataMagic Desktop grade. 
[GRPID,business-group-name] 
DBCID,database-connection-ID 
[COMMENT,comment] 
#STIME,date-and-time-of-last-update 
OUT_PARAM,update-method,table-name
        ……… Update method 
             (I: insert, 
             B: BULK INSERT (Oracle: INSERT by using direct path loading function, 
              SQL Server/INSERT by using FastLoad function, 
              PostgreSQL/BULK INSERT， 
              ODBC/BULK INSERT (only supported for Redshift or Snowflake), 
              others not supported) 
              M: update the rows that have the same key, 
              and insert the rows that do not have the same key) 
OUT_SQL_POLICY,update-method 
      ……… Update method 
          （0: execute only OUT_SQL, 
            1: execute OUT_SQL and OUT_SQL2, 
            2: execute OUT_SQL2 if OUT_SQL1 failed) 
OUT_SQL_START 
SQL-statement-used-for-writing 
OUT_SQL_END 
OUT_SQL2_START 
SQL-2-used-for-writing 
OUT_SQL2_END 
IN_PARAM,table-name,sort-order,field-name-to-use-for-sorting
        ……… Sort order (N = do not sort, D = ascending, R = descending) 
IN_SQL_START 
SQL-statement-used-for-import 
IN_SQL_END 
BEFORE_SQL_START 
SQL-executed-before-processing 
BEFORE_SQL_END 
SUCCESS_SQL_START 
SQL-executed-after-successful-processing 
SUCCESS_SQL_END 
ITEM,validity,field-name,fixed/variable-length,size,field-type,concatenation-sequence,Key,use-in-SQL-2
        ……… Validity (1 = enabled, 0 = disabled) 
            Fixed/variable length (F = fixed length, V = variable length) 
            Size represents the field size for fixed-length fields, 
	    and the maximum size for variable-length fields. 
            For variable-length fields, if you enter 0, the size is unlimited. 
            Field type (B (binary), 
            F (floating point), I (image, unconverted), 
            M (variable-length characters), N (double-byte graphic characters), 
            D (date), Z (numeric character string), 
            W (unicode character string)) 
            Key (0 = not a key, 1 = a key) 
            Valid when M (merge) is specified for OUT_PARAM. 
            Use in SQL 2 (0 = do not use, 1 = use) 
            Valid when OUT_SQL2_START through 
            OUT_SQL2_END are specified, and 1 or 2 is specified for OUT_SQL_POLICY. 
[ITEM_COMMENT,field-comment]
  ……… If there are multiple ITEM lines, make sure that you specify this field 
      immediately after each ITEM line 
END

i) Database connection information format

For details about each field, see Database connection information.

DBCID,database-connection-ID 
#ACCOUNT,name-of-updating-user
     ……… This is not output in the DataMagic Desktop grade. 
[GRPID,business-group-name] 
DBTYPE,product-type……… Product type (0 = SQLite3, 1 = Oracle, 2 = SQL Server#, 
                             3 = DB2, 6 = PostgreSQL,7 = ODBC#,8 = Excel) 
 
[INIT_CODE,character-encoding]
 ……… Character encoding (ASCII, SJIS, EUC, UTF-8, 
     UTF-16, UTF-16BE, UTF-16LE) 
     (If you omit this field, "undefined" is assumed.) 
     Specify the character encoding to be used in 
     the time between connecting to the database and determining the encoding. 
[COMMENT,comment] 
#STIME,date-and-time-of-last-update 
[USER,user] 
[ATTESTATION,authentication-method]#  
 ……… Authentication method (0 = SQL Server authentication, 1 = Windows authentication) 
     (If you omit this field, SQL Server authentication is assumed.) 
[PASSWD,password] 
[PASSWD_ENC,encrypted-password] 

[PRIVKEY, private-key] ……… Absolute path of the private key 
[PRIVKEYPASSWD, private-key-passphrase] 
[PRIVKEYPASSWD_ENC, encrypted-private-key-passphrase] 
DATABASE,database-name,host-name,port-number 
DSN,DSN-name,host-name,port-number ……… DSN name (if the database is Oracle,TNS name) 
END

#: For Windows only.

j) Common components information format

For details about each field, see Common components information.

PONID,ID-character-string 
#ACCOUNT,name-of-updating-user  ……… This is not output in the DataMagic Desktop grade. 
[GRPID,business-group-name] 
[NEEDINPUT,whether-to-perform-input-mapping]
       ………………… Whether to perform input mapping 
                 （0 = do not perform input mapping, 1 = perform input mapping) 
                 （If you omit this field, 0 is assumed.) 
[NARGS,number-of-arguments (0 to 5)] …… (If you omit this field, 0 is assumed.) 
[CAST,output-type]
 ………………………… I, M, 9, D, or 0x00 
                   If you do not want to specify the output type, you can omit this field. 
[ARGTYPES,argument-type] 
………………… Argument type (M or 9) 
            Specify as many argument types as the number of arguments. 
            For three arguments, there are the following eight patterns 
            MMM, MM9, M9M, M99, 999, 99M, 9M9, 9MM 
[ARG1COMMENT,comment-for-argument-1] ……… Comment for common components argument 1 
[ARG2COMMENT,comment-for-argument-2] ……… Comment for common components argument 2 
[ARG3COMMENT,comment-for-argument-3] ……… Comment for common components argument 3 
[ARG4COMMENT,comment-for-argument-4] ……… Comment for common components argument 4 
[ARG5COMMENT,comment-for-argument-5] ……… Comment for common components argument 5 
[COMMENT,comment] 
#STIME,date-and-time-of-last-update 
COMPONENT,component-type,returned-character-string 
 ……… Component type 
     (D = Date, T = Time, M = Fixed character string, 
     9 = Fixed numeric character string, F = Function, 
     V = Virtual query,
     v = Virtual query (for initial processing), 
     L = Lua script (only actual functions),
     L = Lua script (for initial processing)) 
[ITEM_COMMENT,comment-for-data-part] 
DEF_START 
    : 
    : 
    : 
DEF_END 
END

k) User information format

For details on each field, see DataMagic Operation Manual.

In the case of the DataMagic Desktop grade, user information cannot be used.

USERID,user-ID 
#ACCOUNT,name-of-updating-user 
DOMAIN,domain-name 
………………… Specify this tag if you are using Windows. 
[DISPNAME,displayed-name] 
AUTHTYPE,authentication-method
………………… Authentication method (O = OS authentication, P = Product authentication) 
USERTYPE,user-type
………………… User type (A = Administrator, G = General user) 
PASSWD,plain-text-password 
PASSWD_ENC,encrypted-password 
#STIME,date-and-time-of-last-update 
[COMMENT,comment] 
END

l) Business group information format

For details on each field, see DataMagic Operation Manual.

GRPID,business-group-name 
#ACCOUNT,name-of-updating-user 
[COMMENT,comment] 
[OMITAUTH,omit-to-specify-permissions (0 = do not omit, 1 = omit)] 
(If you omit this field, "0" is applied.)
       …… In the DataMagic Desktop grade, "1" is set even if "0" is specified. 
#STIME,date-and-time-of-last-update 
[USER,user-ID,management-information-access-rights,execution-right]
       …… This cannot be used in the DataMagic Desktop grade.
       …… Management information access rights (N = no access, V = can view only, 
         U = view and update) 
         Execution right (N = cannot execute, X = can execute) 
END