cancel
Showing results for 
Search instead for 
Did you mean: 

Correct filename with namespace?

varun5nov51
Explorer
0 Kudos

I am creating a .hdbtable file and need to deploy it to my database. The namespace created during creation of a Project is "Varun_NS1" .

Following is the code

column table "PERFORMANCE"( "ID" INTEGER unique not null COMMENT 'Employee ID', "EVALUATION_RATING" DOUBLE COMMENT 'Evaluation results', "REPORTS_TO" INTEGER not null COMMENT 'Reports to Manager', "FEEDBACK_COMMENT" NVARCHAR(512) COMMENT 'Feedback comment', "SATISFACTION_INDEX" DOUBLE COMMENT 'Employee given rating', PRIMARY KEY ("ID"))

COMMENT 'Performance evaluation record'

Error: "PERFORMANCE" has to be prefixed with the namespace "Varun_NS1" and the name must not contain additional ':' characters after the namespace prefix [8200530]

What should be the name of the table in this file to remove the error ?

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hi Varun Kumar,


Please prefix your namespace to the table name and use double colon before the table name.

Ex: “Varun_NS1”::”PERFORMANCE”

varun5nov51
Explorer
0 Kudos

Hello Lokesh,

I tried writing the name of the table with the schema name as "Varun_NS1"::"PERFORMANCE" but it seems there is still a syntax error . However, I dig in some from my end and found that if write the table name as "Varun_NS1::PERFORMANCE" . It works like a charm !!!

Thank you !!!