DB006001 Unrecognizable token on SET SESSION

Document ID : KB000130743
Last Modified Date : 10/04/2019
Show Technical Document Details
Question:
After getting to the last step of SQL JOB 15 which creates tables for DEMO of SQL. We are
Rel 18.5. 

CONNECT TO SQLTABLE; 
Status = 0 SQLSTATE = 00000 
CREATE SCHEMA DEMOEMPL; 
Status = 0 SQLSTATE = 00000 
SET SESSION CURRENT SCHEMA DEMOEMPL; 
Status = -4 SQLSTATE = 42600 Messages follow: 
Syntax error in line 1 at column 16, token = CURRENT 
DB006001 T24 C-4M330: Unrecognizable token
How can I resolve this error?
Answer:
The SET SESSION CURRENT SCHEMA statement requires that the SQL product be enabled within the RHDCPINT (Product Intent) module.
From the Enter Next Task Code prompt:
DCPROFIL
page 10 holds the * Product Intent Status * page
on the left side under the heading -  CA IDMS Core Products
you will see the SQL product - CA IDMS SQL                        YES

In this case, it displayed NO.
I was running with an older RHDCPINT.
Once I linked the new RHDCPINT into the CUSTOM.LOADLIB,
the DCPROFIL  indicated CA IDMS SQL                        YES

This resolved the error.