4gl and stored procedures
Artem Goncharuk asked whether a 4GL function could be deployed to the server and called like a stored procedure. Jay Aymond said no: use SPL on 7.x, or Java on 9.x. Obnoxio The Clown said it might be possible by wrapping the 4GL in ESQL/C functions and binding them in with the DBDK, but it would be slow and ugly and he would not bet on it working.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hello! Maybe this question is rather stupid... but I did not find an answer in docs.. As far as I understand applications that interact with db can be easyily developed with 4GL. But is there any way to write a function in 4GL and use it in a stored procedure-like way? I mean compile it and deploy to server so that other applications could call it in a SQL statement? Sincerely, Artem Goncharuk
No ... you must use SPL if using the 7.x version of the database. If you are using 9.x, you can also use Java. -- Jay Aymond Community Coffee Artem Goncharuk <art@land3.nsu.ru> wrote in message news:96dfm9$sch$1@nl.novosoft.ru... > Hello! > Maybe this question is rather stupid... but I did not find an answer in > docs.. > As far as I understand applications that interact with db can be easyily > developed with 4GL. But is there any way to write a function in 4GL and use > it in a stored procedure-like way? I mean compile it and deploy to server so > that other applications could call it in a SQL statement? > > Sincerely, > Artem Goncharuk > >
In the year of Our Lord Wed, 14 Feb 2001 14:31:35 +0600, "Artem Goncharuk" <art@land3.nsu.ru> spake, saying: >Maybe this question is rather stupid... but I did not find an answer in >docs.. >As far as I understand applications that interact with db can be easyily >developed with 4GL. But is there any way to write a function in 4GL and use >it in a stored procedure-like way? I mean compile it and deploy to server so >that other applications could call it in a SQL statement? Well, I suppose it may be possible, but it would probably be a heavily slow and ugly solution. 1. Write your 4GL 2. Wrap it in ESQL/C calling functions 3. Use the DBDK to bind them into the server. Ish.
In the year of Our Lord Wed, 14 Feb 2001 19:10:13 GMT, obnoxio@hotmail.com (Obnoxio The Clown) spake, saying: >In the year of Our Lord Wed, 14 Feb 2001 14:31:35 +0600, "Artem Goncharuk" ><art@land3.nsu.ru> spake, saying: > >>Maybe this question is rather stupid... but I did not find an answer in >>docs.. >>As far as I understand applications that interact with db can be easyily >>developed with 4GL. But is there any way to write a function in 4GL and use >>it in a stored procedure-like way? I mean compile it and deploy to server so >>that other applications could call it in a SQL statement? > >Well, I suppose it may be possible, but it would probably be a heavily slow and >ugly solution. > >1. Write your 4GL >2. Wrap it in ESQL/C calling functions >3. Use the DBDK to bind them into the server. > >Ish. If you're using 9.x. I wouldn't bet on it working, though. :-)