Default file format: character (20) [list] This default file type for host operating system files is used if you do not specify a file type using the FORMAT parameter. Refer to “Format” and “Parameters Within a Set Statement” in the KB_SQL
Delimiter: character (3)
This value is used to delimit columns in the query result when you save the query results to a data file using the DELIMITED format. Enter this value as the ASCII value of the character desired. For example, to delimit using Control-A, specify 1 as the delimiter. This will place a $CHAR(1) between columns in the result set.
Export method: character (30) [list] This export method is used instead of the default format for the file type being used in the SELECT command.
Import method: character (30) [list] This import method is used instead of the default format for the file type being used in the INSERT command.
Date output: character (20) [list] You can specify the default display format for date values. The list includes those output formats for the DATE data type that are supported by the KB_SQL date conversion utility. Refer to Chapter 11: Miscellaneous Interfaces for more details on the SQL0DT routine. Date input: character (3) [list] You can also specify the default input format for dates. KB_SQL supports the United States, European, and Canadian formats for date inputs. Be sure that your output and input formats are consistent. That is, if you select DMY as an input format, you should display dates with the day first, followed by the month and year. Otherwise, the date conversion utility will report errors in your date input values. Time output: character (20) [list] You can specify the default display format for times. The list includes those output formats for the TIME data type that are supported by the KB_SQL date conversion utility. Refer to Chapter 11: Miscellaneous Interfaces for more details on the SQL0TM routine.
Moment separator: character (5) KB_SQL supports a MOMENT data type that is a time stamp,
complete with date and time. The format of these values is determined by the output formats specified for dates and times. The date is
separated from the time by the '@' character. You can specify another character string if you wish. For example, to have dates display as '03/30/61 at 10:30 AM', you would specify ' at ' as the moment
separator. This has implications on how your moment input values will be processed. Refer to Chapter 11: Miscellaneous Interfaces for more details on the SQL0TS routine.
Moment time first? YES/NO
By default, KB_SQL displays the date portion first, followed by the separator, then the time portion. Answer YES to reverse this order. This has implications on how your moment input values will be processed. Refer to Chapter 11: Miscellaneous Interfaces for more details on the SQL0TS routine.
Default for COMMIT prompt? YES/NO
This determines the default value for the Commit ? prompt. Enter NO to force the user to enter YES to save the changes.
Show search/select statistics? YES/NO
Answer YES to see the number of records searched and selected for each query run. Compare this value to the access plan cost estimate. Show data access plan? YES/NO
Answer YES to see the data access plan prior to the building routines during query compiles. This provides pseudo code for the query process.
Auto select if one match? YES/NO
Answer YES if selection windows should pick a single matching entry without user confirmation. Answer NO if you wish to confirm all selections even if there is only one match.
Perform ROW commit? YES/NO
Answer YES if you want to allow INSERT, UPDATE, and DELETE commands to skip rows that contain errors. Otherwise, answer NO. The ANSI SQL standard is to discard all changes and return an error message should an INSERT, UPDATE, or DELETE encounter an error. By answering YES to this prompt you ignore this standard at the site level, allowing the commands to reject any rows with errors and process the remaining rows. The site level setting may be overridden in the SQL Editor by setting SET ROW_COMMIT to either YES or NO. Show DBA status window at startup? YES/NO
A YES answer will display the System Status window each time a DBA or MGR user logs on to the system. Answer NO if you do not wish to display this screen at startup.
Default SearchPatternEscape character: character (3)
This is a metacharacter used by ODBC SQL Catalog functions. It must be a printable character or an ASCII value.
Password expire days: integer (3)
Enter the default number of days after which passwords will expire. This number will be used to set the expiration date for user passwords at time of creation and on password renewal.
Password warning days: integer (3)
Enter the default number of days after which the user will be warned of an upcoming password expiration date. The default is 14 days.
Note:
1.) Use of these password features is completely optional. If you do not want passwords to expire, do not enter anything in the field.
2.) The User Group Member List report shows the expiration date for users that have the value set.