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

Primary tabs

Caché, Terminal

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
  • 595
  • 2

Replies

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