MVSFORUMS.com

[Sarangadhar]

Hi,
We have SAS and DB2 on mainframe. we are using Spufi to query database. Can i interact DB2 thru SAS.
_________________
Thanks

[kolusu]

Sarangdhar,

Please search before posting. This topic has been discussed earlier. check this link

http://www.mvsforums.com/helpboards/viewtopic.php?t=3446&highlight=sas

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[Sarangadhar]

Kolusu i tried below SAS code:
OPTIONS DB2SSID=DSN;
PROC SQL;
CREATE VIEW SASUSERS AS
SELECT * FROM CONNECTION TO DB2
(SELECT USERID, SUBR_NBR, USER_TYP FROM PFLDSNA.PFLPFL_USER);

PROC PRINT;
TITLE 'SAMPLE SAS CONNECTION TO DB2';
RUN;

I'm getting this error:
CANNOT CONNECT TO DB2 SUBSYSTEM DSN, RC = 00F30034

This RC says Plan name specified does not exist or wrong plan name specified. Where can I specify the plan name.


Below is the normal spufi we are using:
//SPUFI EXEC PGM=IKJEFT01
//SYSTSPRT DD SYSOUT=*
//SYSTSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(DSN)
RUN PROGRAM(DSNTEP2) PLAN(DSNTEP51)
/*
//SYSIN DD *
SELECT column1, column1 FROM owner.tablename;
_________________
Thanks

[kolusu]

Sarangadhar,


The reason code 00F30034 means that you are not authorized to run this plan. check this for a detailed explanation of the reason code.

[Sarangadhar]

I'm authorised to run this plan, In fact i'm running cobol-db2 programs with plan PLFPBTC0, and spufi programs with plan DSNTEP51.

First of all i didn't specify any plan name in SAS-DB2 step, right?, then what plan name it takes by default?
_________________
Thanks