Usage of DB2EXT via host connection

ThomasH — Tue, 26 May 2009 11:17:09 GMT

Hi all,

I have a question regarding usage of proc db2ext when using it via a host connection.

What I would like to do: Use proc db2ext to extract DB/2 tables on a z/OS system and copy it as SAS datasets via a connection to a UNIX environment.

I can imagine it via

a) open a host connection and use db2ext on the host to create datasets in a library on the client. How would that work?

[...]

signon host user=&user password=&pass;

rsubmit;

libname host db...
libname client...
* how to specify the library on the calling client side inside the host?

proc db2ext in=host out=client...
run;

endrsubmit;

b) open a host connection, create the SAS datasets there and then use proc copy from client.

rsubmit;

libname host db...
libname hostsas

proc db2ext in=host out=hostsas...
run;

endrsubmit;

libname hostsas server=host;

proc copy in=hostsas out=clientlib;
run;

What would be the best way to do it?

Thanks,
Thomas

Re: Usage of DB2EXT via host connection

sbb — Sat, 30 May 2009 12:56:55 GMT

You may find the SAS support http://support.sas.com/ website resources useful for this topic. Here is a link to the most current SAS DOC on SAS/Access and DB2, as a general guide - your SAS version may have additional considerations:

SAS/ACCESS Interface to DB2 under z/OS
http://support.sas.com/documentation/cdl/en/acreldb/61890/HTML/default/a002299542.htm

I expect that you will find additional supplemental technical reference material at the website, as well, either using the SEARCH facility or using a Google search against the SAS.COM site.

Scott Barry
SBBWorks, Inc.

topic Re: Usage of DB2EXT via host connection in SAS Programming

Usage of DB2EXT via host connection

Re: Usage of DB2EXT via host connection