rngdump - Dump Range of Records

rngdump [-c[n][t] [-S=x] | -d[n][t]] [-iindex] [-ofile] dataarea|dataID filename [-date=fmt] [-time=fmt] [-dec=x] [-f fieldname[...]] [-vfieldvalue[...]]

Dump a selection of records from a database file to standard output or a file. You can specify which fields of the record are dumped, which records are dumped, the record ordering, and the data format. The default output format is space-separated columns. Data in the default format can be viewed on-screen or sent to a printer or file. You can also choose to format the data in comma-separated value format (CSV) or in dbdump format.

The Dump Range of Records utility is a system administrator tool and it does not enforce data-level security (file or field). You can use token-security to control who can run rngdump. Also, every time rngdump is run, it writes a log record to $LAWDIR/system/secadmin.log that shows the time that the command was run, the user name of the user who ran the command, and the command that was executed including all options.

Important: The -S option of rngdump is only valid when CSV format is enabled, whereas the s option of rngdbdump is only valid when the CSV format is disabled.


Program Option	Description
`c`	Put the output in a comma-separated value format.
`d`	Dump to flat file. Creates a file that the dbload utility can import.
`n`	Dump output without the field headers.
`t`	Do not print informational messages.
`S`	Specify the delimiter of the returned output. This is only valid with the `-c` option.
`iindex`	Dumps the database using the index you specify instead of the primary index of the file. For example, `-iGLMSET2`.
`ofilename`	Dump the data to a file. For example, `-oglmaster.csv`.
`date`	Print dates in the given format. For example, `date=MDY/` prints `12/31/1999` and `date=YMD-` prints `1999-12-31` This is not valid with the `-d` option.
`time`	Print times in the given format. For example, `time=12:` prints `1:30:00 PM` and `time=24’` prints `13’30’00`. This is not valid with the `-d` option.
`dec`	Specify the decimal separator. For example, `dec=,` prints `0.25` as `0,25`. This is not valid with the `-d` option.
`ffieldname`	Dump the data only for the specified fields. If you use this option, specify one or more field names in the `fieldname(s)` field. For example, `-f DEPARTMENT EMPLOYEE STATUS`.
`vfieldvalue`	Dumps data that is equal to the specified field. For example, `Vcompany=4321`