SPUFI Defaults
Once set up the SPUFI defaults are unlikely to be changed. Their values are very similar across installations, a typical example is shown below.
CURRENT SPUFI DEFAULTS SSID: DDBA ===> ____________________________________________________________________________ Enter the following to control your SPUFI session: 1 SQL TERMINATOR .. ===> ; (SQL Statement Terminator) 2 ISOLATION LEVEL ===> CS (RR=Repeatable Read, CS=Cursor Stability) 3 MAX SELECT LINES ===> 250 (Maximum number of lines to be returned from a SELECT) Output data set characteristics: 4 RECORD LENGTH ... ===> 4092 (LRECL=Logical record length) 5 BLOCK SIZE ...... ===> 4096 (Size of one block) 6 RECORD FORMAT ... ===> VB (RECFM=F, FB, FBA, V, VB, or VBA) 7 DEVICE TYPE ..... ===> SYSDA (Must be DASD unit name) Output format characteristics: 8 MAX NUMERIC FIELD ===> 33 (Maximum width for numeric fields) 9 MAX CHAR FIELD .. ===> 80 (Maximum width for character fields) 10 COLUMN HEADING .. ===> NAMES (NAMES, LABELS, ANY or BOTH)Read more about this topic: IBM Spufi