select d.direction_code
, f.Direction_Id
, SUBstring(vdate_Month_Id,5,2)
, SUBstring(vdate_Month_Id,1,4)
, max(vdate_Month_Id)-100
, max(f.update_date)
from db2admin.DW_JOC_ALL_DATA_TBL f, db2admin.REF_DIRECTION_LU_TBL d
where f.direction_id = d.direction_id
group by d.direction_code
, f.Direction_Id;

[IBM][CLI Driver][DB2/NT] SQL0440N  
No authorized routine named "SUBSTRING" of type "FUNCTION" 
having compatible arguments was found.  SQLSTATE=42884

select d.direction_code
, f.Direction_Id
, SUBSTR(vdate_Month_Id,5,2)
, SUBSTR(vdate_Month_Id,1,4)
, max(vdate_Month_Id)-100
, max(f.update_date)
from db2admin.DW_JOC_ALL_DATA_TBL f, db2admin.REF_DIRECTION_LU_TBL d
where f.direction_id = d.direction_id
group by d.direction_code
, f.Direction_Id;

[IBM][CLI Driver][DB2/NT] SQL0440N  No authorized 
routine named "SUBSTR" of type "FUNCTION" 
having compatible arguments was found.  SQLSTATE=42884

This occurs in a reference to routine "<routine-name>", when the 
database manager cannot find a routine it can use to implement 
the reference. There are several reasons why this could occur: 

o   "<routine-name>" was either incorrectly specified or does not 
    exist in the database.  

o   A qualified reference was made, and the qualifier was     
    incorrectly specified.  

o   The user's SQL path does not contain the schema to which the  
    desired function or method belongs, and an unqualified       
    reference was used.  

o   The wrong number of arguments were included.  

o   The right number of arguments were included in the function   
    or method reference, but the data types of one or more of the 
    arguments is incorrect.  

o   The routine does not exist in the database with the same      
    function id that was used when the package was bound (applies 
    to static statements).  

o   The mutator method corresponding to an attribute assignment   
    used in an UPDATE statement could not be found.  The data     
    type of the new value for the attribute is not a data type    
    that is the same or promotable to the data type of the   
    attribute.  

o   The routine invoker is not authorized to execute the 
    routine.  

 

User Response: 

Fix the problem and retry.  This could involve catalog access, a 
change to the statement, a grant of the execute privilege to the 
routine invoker, the addition of new functions, and/or a change 
to the SQL path.  

 sqlcode :  -440 

 sqlstate :  42884