For DSV output, we recommend the following DBSQLPR processing options.
Directs DBSQLPR to create a DSV output dataset that is intended for downloading into a typical spreadsheet tool such as Microsoft Excel.
DBSQLPR output is directed to the DD name of STDOUT. For testing purposes, you may want to test your query using STDOUT as a SYSOUT dataset until you have the data formatted the way you want. Once you are ready, the DBSQLPR could be re-executed pointing STDOUT to a dataset that is suitable for transferring to the PC using FTP to your spreadsheet tool.
The x is any non-blank character that does not occur normally in your data values. Most systems use comma (,) as the value, but since some of the data in the Delta tables contains commas, we recommend using the semi-colon (;).
Directs DBSQLPR to remove unneeded spaces from column headers and data so that the output record is smaller.
When STDOUT is directed to create DSV output, the DSV columns are fixed in length to represent the longest value of the column header or the largest column value.
By combining SQUISH with the maximum value for PRTWIDTH, you are able to generate DSV output rows with a significant number of column values.
Indicates that DBSQLPR should not ECHO the processing options and SQL statement to STDOUT.
Indicates that no form feed processing should be done. This prevents any additional form feeds to be placed in the output.
Indicates that the output is treated as a single page of output.
Indicates that the TYPE line generated by DBSQLPR to show the type and length of the column is to be suppressed.
Indicates that the output line can be up to 1500 characters. Output rows over 1500 characters cannot be used for DBSQLPR output files.
|
Copyright © 2014 CA.
All rights reserved.
|
|