Following the documentation to insert into tableA from tableB in the SQL query box from the Management Portal :

INSERT INTO tableA (col1, col2)
SELECT col1, col2
FROM tableB

This straightforward query raises the following error :

parseExtFrom+19^%qaqcmx
*mt("f", "1^TABLEA") :

Could someone help me decipher this error message ? Thanks for your help.

Hello, new user here ! My admin granted me all access to the domain I'm working on. Nonetheless, I'm unable to perform simple SQL queries such as creating a table or an index.

What I have tried :

• Creating a table : within the namespace I've been granted access to, I'm trying to create a table with 2 methods :

  • Basic query : CREATE TABLE test.hello_world (col1 INTEGER, col2 VARCHAR) This raises the error :

  [SQLCODE: <-400>:] [%msg: ^rINDEXCLASS("HS.JSON.WRITER"),/iris/irishealth/mgr/HSCUSTOM/>]

  • Creating a table from an already existing view : CREATE TABLE test.hello_world AS SELECT test.v_tableA