Hi all.
I have some problem with getting data from external source (PostgreSQL) via JDBC and load it in DeepSee and I resolved some problems while writing this question :)
So..Below I proved my steps of working:
- Created SQL Gateway Connection
- Created class for loading data via JDBC
S Connection=##class(%Library.SQLGatewayConnection).%New() S sc=Connection.Connect("jdbcurl","user","pass",0) If $$$ISERR(sc) do $System.Status.DisplayError(sc) quit S sc=Connection.AllocateStatement(.Statment)S query="SELECT * FROM students" S sc=Connection.Prepare(Statment,query)S sc=Connection.Execute(Statme