SQL CREATE Table Name with System defined variable | InterSystems

Question

Jimmy Christian · Apr 23, 2019

Hello all,

I am still learning CACHE and have below question.

In one of my ZEN method i am creating a table using

&sql(CREATE TABLE xxxxx(TNAMESPACE CHAR(100),TINTERFACE CHAR(100)))

Does any one knows how to concatenate a $USERNAME or any content of a variable to the name of table ?

&sql(CREATE TABLE xxxxx_$USERNAME(TNAMESPACE CHAR(100),TINTERFACE CHAR(100))) is not WORKING.

Thanks,

Jimmy Christian.

Discussion (2)0

Log in or sign up to continue

Vitaliy Serdtsev · Apr 23, 2019

s res=##class(%SQL.Statement).%ExecDirect(,$$$FormatText("CREATE TABLE %1 (TNAMESPACE CHAR(100),TINTERFACE CHAR(100))",$$$quote("xxxxx"_$USERNAME)))

w res.%SQLCODE

0 0

Jimmy Christian Apr 23, 2019 to Vitaliy Serdtsev

Thank you . This is perfect !

I just tweaked it little bit

SET testingddl="CREATE TABLE xxxxxxx"_$USERNAME_"(TNAMESPACE CHAR(100),TINTERFACE CHAR(100),TPORT INT)"
s ret=##class(%SQL.Statement).%ExecDirect(,.testingddl)

0 0