Hello Nicolai, A sql program is a c program with sql statements embedded in it. Other than C you can write programmes in Fortran, Cobol and ada.
I have attached a sql file and embedded sql program which could execute a row returning procedure. For compiling the sc file you would have to do the following steps from Ingres command prompt. 1) esqlc statrpp.sc 2) nmake statrpp.obj 3) cl statrpp.obj %II_SYSTEM%\ingres\lib\libingres.lib -o statrpp Assuming that you have .net installed on your system. You have figured out smart way to get the status from a procedure. About the third party tools, I am not sure if there are any that are More advanced than the sql, isql and visual sql. About the vdba suite, database administration can certainly become much more simpler even if you are working on different operating systems. However it certainly cannot execute a row returning procedure. Hope this helps... Sambit Kumar Nanda Computer Associates Software Engineer, Development tel:+91-40 5567 0409 fax:+91-40 55670001 [EMAIL PROTECTED] -----Original Message----- From: Nicolai Tufar [mailto:[EMAIL PROTECTED] Sent: Saturday, March 19, 2005 12:39 PM To: Nanda, Sambit K Cc: [email protected] Subject: Re: [Users] call procedure from Visual SQL Wow, thank you for reply! On Sat, 19 Mar 2005 12:23:43 +0530, Nanda, Sambit K <[EMAIL PROTECTED]> wrote: > Only way to extract results from a row returning procedure is through a > sql program. And how would I do that? What is a sql program? You mean a program in, say, java using JDBC? > > However you can certainly execute procedure from visual sql which do not > return any thing for example a procedure performing some inserts can be > executed from > Visual sql interface. I figured out a way to do it. I insert MESSAGE statement before return statement in procedure, like this: ..... MESSAGE :result; return :result; end; then call procedure not from Visual SQL but form text-based "isql" program. There it prints message in the output. Can I see MESSAGE statement output from procedure in Visual SQL? Or maybe there are other, more advanced SQL tools around? Maybe third-party tools? Ingres Getting Started document says that a product called "Visual DBA suite" is not included in free version of Ingres? What is this suite? Can it perform what I need? If it can we will buy it, because we really need it. Thanks in advance, Best regards, Nicolai
test.sql
Description: test.sql
statrpp.sc
Description: statrpp.sc
_______________________________________________ Users mailing list [email protected] http://ingres.ca.com/mailman/listinfo/users
