execute sql from the Caché Terminal command line , prompt error "

Question

wx fg · Jul 3, 2017

I execute sql from Terminal

SET result=$SYSTEM.SQL.Execute("SELECT TOP 5 name,dob,ssn FROM Sample.Person")

but I got error "<METHOD DOES NOT EXIST> *Execute,%SYSTEM.SQL"

Why?

Thanks

Discussion (2)0

Vitaliy Serdtsev · Jul 3, 2017

Indicates that your version is below 2011.x

See documentation:
2010.2 (absent)
2011.1 (present)

3 0

wx fg · Jul 5, 2017

thanks! for 2010 version, ##class(%SQL.Statement).%ExecDirect() for executing sql

0 0

execute sql from the Caché Terminal command line , prompt error "<METHOD DOES NOT EXIST> *Execute,%SYSTEM.SQL"