Written by

Question wx fg · Jul 3, 2017

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

#Caché #Terminal

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)

0 0

wx fg Jul 5, 2017 to Vitaliy Serdtsev

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

0 0