DATA Step, Macro, Functions and more

Usage of DB2EXT via host connection

Reply
Contributor
Posts: 51

Usage of DB2EXT via host connection

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
Super Contributor
Super Contributor
Posts: 3,174

Re: Usage of DB2EXT via host connection

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.
Ask a Question
Discussion stats
  • 1 reply
  • 108 views
  • 0 likes
  • 2 in conversation