How to call "ClassMethod" in SQL statement？

Question

Question

yeung elijah · Feb 1, 2021

#InterSystems IRIS

Hi,I am a novice.How to call "ClassMethod" in SQL statement？

I don't understand why it's wrong?

Discussion (4)0

Log in or sign up to continue

Robert Cemper · Feb 1, 2021

You should take a look to Using Caché SQL !

Executing SQL
https://docs.intersystems.com/latest/csp/docbook/Doc.View.cls?KEY=GSQL_basics#GSQL_basics_executing

Using the SQL Shell Interface
https://docs.intersystems.com/latest/csp/docbook/Doc.View.cls?KEY=GSQL_shell

0 0

score 0 · Answer 1 · 2021-02-01T02:52:23-05:00

Eduard Lebedyuk · Feb 1, 2021

Remove

FROM "procedure".day01

0 0

score 0 · Answer 2 · 2021-02-01T02:59:00-05:00

You can't run a SQL statement from the console prompt.
You need to start the SQL shell first:

SAMPLES>do $system.SQL.Shell()
SQL Command Line Shell
----------------------------------------------------
 
The command prefix is currently set to: <<nothing>>.
Enter <command>, 'q' to quit, '?' for help.
[SQL]SAMPLES>SELECT . . . . your statement

score 0 · Answer 3 · 2021-02-01T20:42:10-05:00

yeung elijah · Feb 1, 2021

Thank you

0 0