dbdisplay - Display Data

dbdisplay [-Bhl] [-F field ...] [-f "filterString"] [-D dateformat [-L localeName]] [-T timeformat] [-S decimalseparator] [-i indexname] [-R] dataarea file

dbdisplay displays data for a specified database file.

Program Option Description
-h or --headers Print field headers.
-l or --nolobs Do not print lob fields.
-F fieldNames or --fields=fieldNames

Print only specified fields.

Use the format field[:width],field[:width]...

--distinct Retrieve only distinct records based on the -F option values.
-f "FilterString" or --filter=FilterString

Limit the output based on the specified filter value for the index keys of the file. The filter can be a conditional expression, such as

-f "FileName.FieldName=123"

or

-f "Relationship.FieldName=123"

-s searchString or --search=searchString Limit the output based on the search expression specified.
-D dateformat

Specify the date format for displaying dates. The default format is yyyyMMdd. When specifying the format, use uppercase M's to indicate the month format, and lowercase d's and y's to indicate the day and year formats, respectively. For example, MM/dd/yyyy is correct but mm/dd/yyyy is not correct.

For a full explanation of supported formats, see the Java API documentation for the java.text.SimpleDateFormat class.
-T timeformat

Specify the time format for displaying times. The default format is HHmmss. When specifying the format, use uppercase H's for the hour format, and m's, and s's to indicate the minute, and second formats, respectively.

For a full explanation of supported formats, see the Java API documentation for the java.text.SimpleDateFormat class.
-L localeName or --locale=localeName

Specify a locale in the format language[_COUNTRY[_variant]].

For example, en_US

Valid only with the -D option.
-S decimalseparator Specify the decimal separator.
-i indexname

Exports the data using an index sequence, using the specified indexname (for example, -iGLMSET1). The index name must follow the -i.

Example: Displaying Fields Sorted by an Alternate Index

-K relationshipName Display results based on the specified relationship name.

-n N or --depth=N

Set the hierarchy depth to the value of N.

-R Show text search relevance score.
-r name The relevance set name.
dataarea The data area that you want to view data for.
file A specific business class, module, database space, or business class pattern to execute the command against. Wildcard characters can also be used in order to specify multiple business classes.
-v displayoptions

errorlevel, tracelevel, and verbose specified in any order, where:

  • errorlevel = {n}none | {f}atal | {e}rror | {w}arning (warning is the default)

  • tracelevel = 0:6 where 0 is no message and 6 is everything

  • verbose = whether to display exception stacktrace

Example: Displaying Fields Sorted by an Alternate Index

Enterprise Company is delivered with and defined the same in all Landmark applications. These examples use the -h option to show the field names and the -F option to limit the output to fields of interest.

The following command lists three fields from the Enterprise Company business class (file) in the MySampleHR data area. The fields will be sorted by the default index, or the symbolic key. In this case, Company is the symbolic key.

dbdisplay -h -F Company,EnterpriseGroup,DefaultCountry MySampleHR EnterpriseCompany

Command output:

Company EnterpriseGroup DefaultCountry
    333 WEST            USA
   1111 EAST            USA
   2222 EAST            USA

The following command lists the same three fields from the Enterprise Company business class (file) in the MySampleHR data area. This time an alternate index, ByEnterpriseGroup, is specified with the -i option.

dbdisplay -h -F Company,EnterpriseGroup,DefaultCountry -i ByEnterpriseGroup MySampleHR EnterpriseCompany

The output now shows the records listed in order by Enterprise Group instead of Company.

Company EnterpriseGroup DefaultCountry
   1111 EAST            USA
   2222 EAST            USA
    333 WEST            USA