Viewing Data (dbdisplay)

dbdisplay displays data stored in a file. Options allow filtering for subsets of data, or viewing only specified fields.

Note: 

The data cannot be exported to a file or modified in any way using this utility. The dbexport utility must be used if you want to save or modify the data.

At a Landmark command prompt, type

dbdisplay [-hl] [-F fieldNames] [-f "filterstring"] [-D datepattern [-L localeName]] [-T timepattern] [-S decimalseparator] [-i indexname] dataarea 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"

Example: Displaying a Field's Data Using a Filter

-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 a Field's Data 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