The Pass-Through Facility for Relational Databases CONNECT Statement 231
The termination command that you select can be a script, stored
procedure, or any DBMS SQL language statement that might provide
additional control over the interaction between the SAS/ACCESS engine and
the DBMS. You can specify any valid DBMS command that can be passed by
the SAS/ACCESS engine to the DBMS and that does not return a result set
or output parameters. The command executes immediately before SAS
terminates each connection to the DBMS. If the command fails, SAS provides
a warning message but the disconnect still occurs. You must specify the
command as a quoted string.
DBGEN_NAME= DBMS | SAS
specifies whether to automatically rename DBMS columns containing
characters that SAS does not allow, such as $, to valid SAS variable names.
See “DBGEN_NAME= LIBNAME Option” on page 87 for further information.
DBMAX_TEXT=
integer
determines the length of a very long DBMS character data type that is read
into SAS or written from SAS when using a SAS/ACCESS engine. This
option applies to reading, appending, and updating rows in an existing table.
It does not apply when you are creating a table.
Examples of a DBMS data type are the SYBASE TEXT data type or the
Oracle LONG RAW data type.
DBPROMPT=YES | NO
specifies whether SAS displays a window that prompts the user to enter
DBMS connection information prior to connecting to the DBMS.
Default value: NO
If you specify DBPROMPT=YES, SAS displays a window that interactively
prompts you for the DBMS connection arguments when the CONNECT
statement is executed. Therefore, it is not necessary to provide connection
arguments with the CONNECT statement. If you do specify connection
arguments with the CONNECT statement and you specify
DBPROMPT=YES, the connection argument values are displayed in the
window. These values can be overridden interactively.
If you specify DBPROMPT=NO, SAS does not display the prompting
window.
The DBPROMPT= option interacts with the DEFER= option to determine
when the prompt window appears. If DEFER=NO, the DBPROMPT window
opens when the CONNECT statement is executed. If DEFER=YES, the
DBPROMPT window opens the first time a Pass-Through statement is
executed. The DEFER= option normally defaults to NO, but defaults to YES
if DBPROMPT=YES. You can override this default by explicitly setting
DEFER=NO.
DEFER=NO | YES
determines when the connection to the DBMS occurs.
Default value: NO
If DEFER=YES, the connection to the DBMS occurs when the first
Pass-Through statement is executed. If DEFER=NO, the connection to the
DBMS occurs when the CONNECT statement occurs.
VALIDVARNAME=V6
indicates that only those variable names considered valid SAS variable
names in Version 6 of SAS software are considered valid. Specify this
connection argument if you want Pass-Through to operate in Version 6
compatibility mode.
By default DBMS column names are changed to valid SAS names by using
the following rules:
