DBLOAD Procedure Specifics for SAP ASE

Overview

For general information about this feature, see the DBLOAD Procedure.

The SAP ASE interface supports all DBLOAD procedure statements.

Here are the SAP ASE interface specifics for the DBLOAD procedure.

• The DBMS= value for PROC DBLOAD is SAPASE.
• The TABLE= statement for PROC DBLOAD is:

  TABLE= <'>table-name<'>;

• PROC DBLOAD uses these database-description-statements.

  USER=<'>SAP-ASE-user-name<'>

  specifies the SAP ASE user name (also called the login name) that you use to connect to your database. If the user name contains spaces or nonalphanumeric characters, you must enclose it in quotation marks.

  PASSWORD=<'>SAP-ASE-password<'>

  specifies the password that is associated with the SAP ASE user name.

  If you omit the password, a default password of NULL is used. If the password contains spaces or nonalphanumeric characters, you must enclose it in quotation marks.

  PASSWORD= can also be specified with the SYBPW=, PASS=, and PW= aliases.

  DATABASE=<'>database-name<'>

  specifies the name of the SAP ASE database that contains the tables and views that you want to access.

  If the database name contains spaces or nonalphanumeric characters, you must enclose it in quotation marks. If you omit DATABASE=, the default database for your SAP ASE user name is used.

  Alias: DB=

  SERVER=<'>server-name<'>

  specifies the server that you want to connect to. This server accesses the database that contains the tables and views that you want to access.

  If the server name contains lowercase, spaces, or nonalphanumeric characters, you must enclose it in quotation marks.

  If you omit SERVER=, the default action for your operating system occurs. On UNIX systems, the value of the environment variable DSQUERY is used if it has been specified.

  INTERFACE=file-name

  specifies the name and location of the SAP ASE interfaces file. The interfaces file contains the names and network addresses of all available servers on the network.

  If you omit this statement, the default action for your operating system occurs. INTERFACE= is not used in some operating environments. Contact your database administrator to determine whether it applies to your operating environment.

  BULKCOPY= Y|N;

  uses the SAP ASE bulk copy utility to insert rows into an SAP ASE table. The default value is N.

  If you specify BULKCOPY=Y, BULKCOPY= calls the SAP ASE bulk copy utility in order to load data into an SAP ASE table. This utility groups rows so that they are inserted as a unit into the new table. Using the bulk copy utility can improve performance.

  You use the COMMIT= statement to specify the number of rows in each group (this argument must be a positive integer). After each group of rows is inserted, the rows are permanently saved in the table. As each group is being inserted, if one row in the group is rejected, all rows in that group are rejected.

  If you specify BULKCOPY=N, rows are inserted into the new table using Transact-SQL INSERT statements. See your SAP ASE documentation for more information about the bulk copy utility.

PROC DBLOAD Example for SAP ASE

The following example creates a new SAP ASE table, EXCHANGE, from the DLIB.RATEOFEX data file. (The DLIB.RATEOFEX data set is included in the sample data that is shipped with your software.) An access descriptor ADLIB.EXCHANGE is also created, and it is based on the new table. The DBLOAD procedure sends a Transact-SQL GRANT statement to SAP ASE. You must be granted SAP ASE privileges to create new SAP ASE tables or to grant privileges to other users.

libname adlib 'SAS-library';
libname dlib 'SAS-library';

proc dbload dbms=sapase data=dlib.rateofex;
   server='mysrv1'; database='testdb'; user='myusr1';
   password='mypwd1'; table=EXCHANGE; accdesc=adlib.exchange;
   rename fgnindol=fgnindolar 4=dolrsinfgn;
   nulls updated=n fgnindol=n 4=n country=n;
   load;
run;