topic Re: How to Load some data into DB2 Database using DBLOAD PROC ? in SAS Enterprise Guide

How to Load some data into DB2 Database using DBLOAD PROC ?

THALLA_REDDY — Thu, 07 Jan 2021 11:43:25 GMT

Hi Team,

I am using DB2 Database to manage my clients data and connecting through SAS Enterprise Guide 8.3. Can anyone help me how to load some data into a table in my DB2 database.

In the DB2 database We have the subsystem architecture to access the database and it's table.

For Ex: We have the subsystems like
DBT1, DBT2 etc.., and under these subsystem we have some databases defined and then tables are created in those databases.

My requirements is I have table (DBT1 --> T1101015A --> prsn_data

Here DBT1 is subsystem, T1101015A is the database and PRSN_DATA is the table name.

Please help to load some data into PRSN_DATA table using DBLOAD PROC in SAS Enterprise Guide.

thanks in Advance,

thalla

Re: How to Load some data into DB2 Database using DBLOAD PROC ?

Ksharp — Thu, 07 Jan 2021 12:06:36 GMT

PROC DBLOAD is very very old product.
Why not using LIBNAME + PROC SQL / PROC COPY ?

Re: How to Load some data into DB2 Database using DBLOAD PROC ?

THALLA_REDDY — Thu, 07 Jan 2021 14:00:33 GMT

Hi Thanks for your reply.
Can you help me with a small code for LIBNAME + PROC SQL / PROC COPY?

Re: How to Load some data into DB2 Database using DBLOAD PROC ?

Ksharp — Fri, 08 Jan 2021 10:59:45 GMT

1) fristly , make a connection to DB2 via DB2 client software or ODBC (data source at control center).
2) And using LIBNAME statement .
libname x db2 ........
or
libname x odbc dsn= ... insertbuff=10000;
3) copy table from sas into DB2.
proc copy in=work out=x noclone;
run;

P.S. search your topic at support.sas.com . you could find many useful stuff . Good Luck .

Re: How to Load some data into DB2 Database using DBLOAD PROC ?

LinusH — Fri, 08 Jan 2021 12:08:05 GMT

Just to add, if you already have a defined schema in DB2 (quite common) use PROC APPEND or PROC SQL (INSERT INTO) instead.