Question
wx fg · Jul 3, 2017

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

hi

  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

0
0 855
Discussion (2)0
Log in or sign up to continue

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