Example: Specifying a Column Width

Some fields may be much larger than most of the data stored in them; or you might only need to see the initial portion of the data. You can specify the width of the column in the output by appending a numeric value to each field in the -F parameter.

dbdisplay -h -F SampleCompany,SampleEmployee,SampleAddress.SampleAddressLine1:8 mysamplehr SampleEmployee

In this example, the output for the address line was shortened to 8 characters. Note that you only get 6 characters, plus two dots to indicate more data exists. The name of the field is also truncated in the header.

SampleCompany SampleEmployee Sample..
         1234       98765432 456 So..
         1234      123454678 1234 F..
         1234      123454679
         1234      123454680
         1234      123454681
         1234      123454682
         1234      123456783

Number of records displayed: 7