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?
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