Error Libref is not assigned

Reply
Occasional Learner
Posts: 1

Error Libref is not assigned

Hi All,

 

Here's my SAS DB2 Job

 

//SASDB2   JOB (S9,D500,990,2000),'TEST',CLASS=A,                   
//         MSGCLASS=A,NOTIFY=&SYSUID,MSGLEVEL=(1,1)                 
/*ROUTE XEQ DB2F                                                    
//*                                                                 
//******************************************************************
//* DB2 COnnect THROUGH SAS                                         
//******************************************************************
//SASSTEP  EXEC SAS                                                 
//SYSOUT   DD SYSOUT=*                                              
//*                                                                 
//SYSIN    DD *                                                     
proc sql;                                                           
select epin,npi                                                     
    from IMSFCS90.PVTNPI;                                           
quit;                                                               
/*     

 

I got an error 'ERROR: Libref IMSFCS90 is not assigned.'.

IMSFCS90 is the creator name.

 

Please help me with my error.
                                                        

Super User
Posts: 8,590

Re: Error Libref is not assigned

Posted in reply to AaronOani

You need a libname statement that uses SAS/ACCESS to DB/2.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 1 reply
  • 269 views
  • 0 likes
  • 2 in conversation