utledlist (Command to output the conversion log)
The data processing log file is a database file. Therefore, this command is used to reference the content of the data processing log file. Parameters can be used to specify the details of the output range and the output format. The results are output to the standard output. The redirection symbol (>) can be used to output the results to a file.
Grade |
User type for DataMagic |
Business group settings for management information |
Executability |
---|---|---|---|
DataMagic Server |
Superuser |
- |
Executable |
General user |
Omit specification of rights (#1) |
Executable |
|
Specify rights |
Executable (#2) |
||
DataMagic Desktop |
- |
- |
Executable |
#1 |
: |
Indicates that user rights are not specified for business groups but they will be used as filtering conditions. |
#2 |
: |
The following log information can be output by ordinary users:
If the general users do not belong to a business group for which user rights are to be specified, the log information about the business group cannot be output. |
Commands
- For the DataMagic Server grade
-
utledlist [[-f YYYY/MM/DD [hh:mm:ss]] [-t YYYY/MM/DD [hh:mm:ss]]| -s seqno|-b {n|thisweek|thismonth|today}] [-e {n|ok|ng}] [-p parameter] [-d id][-u userid][-g grpid] [format] [-k {E|S|8}] [-l max]
- For the DataMagic Desktop grade
-
utledlist [[-f YYYY/MM/DD [hh:mm:ss]] [-t YYYY/MM/DD [hh:mm:ss]]| -s seqno|-b {n|thisweek|thismonth|today}] [-e {n|ok|ng}] [-p parameter] [-d id][-g grpid] [format] [-k {E|S|8}] [-l max]
Parameters
-f YYYY/MM/DD [hh:mm:ss]
Specify the start date of the log data you want to output. (This parameter can be omitted.)
If you omit this parameter, log data is output from the beginning.
-t YYYY/MM/DD [hh:mm:ss]
Specify the end date of the log data you want to output. (This parameter can be omitted.)
If you omit this parameter, log data is output to the end.
-s seqno
Specify the conversion identifier you want to output. (This parameter can be omitted.)
The conversion identifier will be a unique number that identifies a record in the conversion log.
-b {n|thisweek|thismonth|today}
Specify the range of log data to be output. (This parameter can be omitted.)
The range can be specified relative to the present.
- n
-
: Outputs log data from n days ago.
Use a number from 1 to 9999.
- thisweek
-
: Outputs log data from the current week. (from Sunday)
- thismonth
-
: Outputs log data from the current month.
- today
-
: Outputs log data of the current day.
-e {n|ok|ng}
Specify the exit code of the log data that you want to output. (This parameter can be omitted.)
- n
-
: Outputs log data that had the exit code n.
- ok
-
: Outputs all log data that had a normal end.
- ng
-
: Outputs all log data that had an abnormal end.
-p parameter
Use -p to specify a character string that will be used to perform a wildcard search for log parameter file names and output log information. (This parameter can be omitted.)
-d id
Specify the data processing ID of the log data you want to output. (This parameter can be omitted.)
If you omit this parameter, log data for all data processing IDs is output.
-u userid
Specify the executing user of the log data you want to output. (This parameter can be omitted.)
If you omit this parameter, log data for all executing users is output.
-g grpid
Specify the business group of the log data you want to output. (This parameter can be omitted.)
If you omit this parameter, log data for all business groups is output.
format
Specify the output format of log data by using a format character string.
(This parameter can be omitted.)
If you omit this parameter, the following output format is applied:
"%6s %03e %03d %t %T %n"
Non-format characters in the format character string are not converted and are displayed without change.
The formats are converted as follows:
- %s
-
: ID
- %n
-
: Processing record number
- %N
-
: Total number of output records
- %u
-
: Executing user
- %g
-
: Business group
- %f
-
: Parameter file name
- %i
-
: Data processing ID
- %p
-
: Execution parameters
- %E
-
: End message
- %D
-
: Detailed message
- %C
-
: Comments
- %e
-
: End code
- %d
-
: Details code
- %m
-
: Use of multi-threading
- %t
-
: Date conversion started
- %T
-
: Date conversion ended
- %%
-
: %
- \n
-
: Line break
- \t
-
: Horizontal tab
- Flag characters
-
: You can specify flag characters after the % character starting from 0.
-
0:
Pads a value with zeros. The converted values of %n (processing record number), %e (end code), and %d (details code) are left-padded with zeros instead of blank characters. If both 0 and a hyphen (-) are used, 0 is ignored.
-
-:
Left-aligns the converted value within the field (default is right alignment).
-
- Field width
-
: Specify the minimum field width using positive integers.
If the conversion result is larger than the field width, the field width is automatically expanded to contain the conversion result.
-
The conversion identifier will be a unique number that identifies a record in the conversion log.
-
The date is output in the format that is specified as the date format (datefmt) for the system environment settings.
-k {E|S|8}
Specify the output code of the log data. (This parameter can be omitted.)
If you omit this parameter, the following value is applied for output:
- 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 Local host kanji code type in the system environment settings file (huledenv.conf)
-l max
Specify the maximum number of entries of log data that you want to output. (This parameter can be omitted.)
Specify a value from 1 to 999.
If you omit this parameter, all log data is output.
-
The date part of Usage is displayed in the format that is specified as the date format (datefmt) for the system environment settings.
-
To specify a date, use the format selected as the date format (datefmt).
-
If you specify the start and end dates by using parameters, you must insert one half-width space between the date (YYYY/MM/DD) and the time (hh:mm:ss). You must also enclose the date (YYYY/MM/DD) and time (hh:mm:ss) in double quotation marks ("). However, if you specify only the date or the time, the double quotation marks are unnecessary.
Example: -f "2011/04/01 10:00:00"
-
You can specify only a time as the parameters for the start and end dates. If you omit the date and specify only the time, the date on which the command is executed is treated as the date.