DB006001 Unrecognizable token on SET SESSION

Products

• IDMS
• IDMS - Database

Issue/Introduction

After getting to the last step of SQL install JOB 15 which creates tables for DEMO of SQL, this error is seen:

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

Environment

Release: All supported releases.
Component: SQL Option.

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

The last page displays the * Product Intent Status * information.

On the left side under the heading IDMS Core Products there is the SQL product CA IDMS SQL.

In this case, it displayed NO.

Ensure that the RHDCPINT module in use has been linked with #DEFPINT SQL not commented out.