Hi folks,
i am currently using SAS in C/S mode from a standard WIndows PC SAS client session to a NT 4 SP6 SAS server.
SAS version is 8.1. On the server side is also installed DB2 CAE version 7.
what i need to do is initialize a SAS libname in the server session, this libname connecting to a DB2 engine located on an AS400 and being accessed from the NT server through the DB2 CAE interface.
This works perfectly when i manually input a user/password on the libname instruction (ie : libname XX DB2 user=toto using=titi database=MYDB2BASE schema="MYDB2SCHEMA"
Now i need to do the same without providing the user/password pair on the SAS libname statement, since i want DB2 to use the OS user/password pair provided at the client/server connection.
My new statement should now be libname XX DB2 database=MYDB2BASE schema="MYDB2SCHEMA";
This doesn't work. I get a DB2 error message : "invalid user/paswword supplied...". I have absolutly no idea of what user/password DB2 uses for the RDBMS connection.
Has any one any idea of how to proceed and if this works ?
For info, this works perfectly in the same manner with an Oracle connection.
Any idea or help will be greatly appreciated.
Thanks in advance.
i am currently using SAS in C/S mode from a standard WIndows PC SAS client session to a NT 4 SP6 SAS server.
SAS version is 8.1. On the server side is also installed DB2 CAE version 7.
what i need to do is initialize a SAS libname in the server session, this libname connecting to a DB2 engine located on an AS400 and being accessed from the NT server through the DB2 CAE interface.
This works perfectly when i manually input a user/password on the libname instruction (ie : libname XX DB2 user=toto using=titi database=MYDB2BASE schema="MYDB2SCHEMA"
Now i need to do the same without providing the user/password pair on the SAS libname statement, since i want DB2 to use the OS user/password pair provided at the client/server connection.
My new statement should now be libname XX DB2 database=MYDB2BASE schema="MYDB2SCHEMA";
This doesn't work. I get a DB2 error message : "invalid user/paswword supplied...". I have absolutly no idea of what user/password DB2 uses for the RDBMS connection.
Has any one any idea of how to proceed and if this works ?
For info, this works perfectly in the same manner with an Oracle connection.
Any idea or help will be greatly appreciated.
Thanks in advance.