DB006001 Unrecognizable token on SET SESSION
search cancel

DB006001 Unrecognizable token on SET SESSION

book

Article ID: 130743

calendar_today

Updated On:

Products

IDMS IDMS - Database IDMS - ADS

Issue/Introduction



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?

Environment

Release: IDADSO00100-18.5-ADS-for CA-IDMS
Component:

Resolution

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.