Hello to you SAS Gurus, I have a couple of questions regarding SAS DB2 connectivity. SAS Environment: SASCompute 9.4]# ./sas -nodms NOTE: SAS (r) Proprietary Software 9.4 (TS1M4) NOTE: This session is executing on the Linux 3.10.0-514.2.2.el7.x86_64 (LIN X64) platform. DB2 Environment: AS400/DB2 11.1; OS is Linux First question, in what environment setup do I need DB2 Connect to work with SAS Explorer in other to connect to DB2 on AS400?? Do I really need DB2 connect to use SAS to connect to DB2 on AS400? Why and how do I need it? I have read severally on SAS topics such as SAS/Connect, SAS/ACCESS etc but I could not find any reference to using DB2 connect from SAS to connect to DB2 or setting up DB2 connect on the DB2 server side either. Ca the SAS guru confirm this? DB2 connect is or is not needed for SAS to connect to DB2. The next question is really the problem. I want to connect my new SAS Explorer product to an existing AS400 running DB2. I am very new to SAS but knowlegable about DB2 and can supply pertinent information for the connection. We have installed IBM DB2 connector on the SAS server, but no one has knowledge of the command line syntax to connect the client to the DB2 server. We need help confirming that we can connect and also any configuration(s) needed on the DB2 Connector client. Do I need DB2 client on the SAS server also? We can get full access to the SAS Linux server that the client is installed on. Do I need to do anything on the DB2 server side? What is the typical SAS syntax to gain connection to DB2 on AS400? Please a complete syntax example will be highly appreciated. Any comment, suggestion and connection example will be golden. I thank you all in advance. Below is the SAS code (and errors) that I tried to run but got no where: 1? proc sql noerrorstop; connect to db2 (user=ABC password=xxxx database=dbname; select * from connect to db2 ( select * from connection to DB2 (select * from syscat.functions where funcschema ='saslin'); 2? 2 connect to db2 (user=ABC password=XXXX database=dbname; select * from - 79 2 ! connect to db2 ( select * from connection to DB2 ERROR 79-322: Expecting a ). 2 connect to db2 (user=ABC password=xxxx database=dbname; select * from 2 ! connect to db2 ( select * from connection to DB2 --- 22 ERROR 22-322: Syntax error, expecting one of the following: GROUP, HAVING, ORDER, WHERE. 2 connect to db2 (user=ABC password=xxxx database=dbname; select * from 2 ! connect to db2 ( select * from connection to DB2 --- 76 ERROR 76-322: Syntax error, statement will be ignored. 4? proc sql noerrorstop; connect to db2 (user=user1 password=password1 database=database1; select * from connect to db2 ( select * from connection to DB2 (select * from syscat.functions where funcschema ='saslin'); quit; NOTE: PROCEDURE SQL used (Total process time): real time 1:56.49 cpu time 0.00 seconds 5? 5 connect to db2 (user= password=XXXXXXX database=dbname1; select * - 79 5 ! from connect to db2 ( select * from connection to DB2 ERROR 79-322: Expecting a ). 5 connect to db2 (user=user1 password=password1 database=S213732V; select * 5 ! from connect to db2 ( select * from connection to DB2 --- 22 ERROR 22-322: Syntax error, expecting one of the following: GROUP, HAVING, ORDER, WHERE. 5 connect to db2 (user=sasdb2 password=orange1 database=S213732V; select * 5 ! from connect to db2 ( select * from connection to DB2 --- 76 ERROR 76-322: Syntax error, statement will be ignored. 7? proc sql noerrorstop; connect to db2 (user=user1 password=password1 database=database1; select * from connect to db2 ( select * from connection to DB2 (select * from syscat.functions where funcschema ='schema1'); quit; NOTE: PROCEDURE SQL used (Total process time): real time 6:13.79 cpu time 0.03 seconds 8? 8 connect to db2 (user=user1 password=password1 database=dbname1; select * - 79 8 ! from connect to db2 ( select * from connection to DB2 ERROR 79-322: Expecting a ). 8 connect to db2 (user=user1 password=password1 database=dbname1; select * 8 ! from connect to db2 ( select * from connection to DB2 --- 22 ERROR 22-322: Syntax error, expecting one of the following: GROUP, HAVING, ORDER, WHERE. 8 connect to db2 (user=user1 password=password1 database=dbname1; select * 8 ! from connect to db2 ( select * from connection to DB2 --- 76 ERROR 76-322: Syntax error, statement will be ignored. 10? Thanks a million everyone Okonita
... View more