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