Re: Informix datatypes...

Florin Micle wrote: > Is there some possibility to define a column data type in Informix? > I mean like in Oracle: table%ROWTYPE. > Is there someway I can do this? I want to pass a parameter to a procedure > and I would rather pass a single one than as many as number of columns the > table has. > Can I avoid passing parameters like > execute procedure myproc( var.field1, var.field2, var.field3,... ) > and do something like > execute procedure myproc( var ) ? > That would be useful :-) I use INFORMIX Universal Server (9.13), which allows you to define row types and typed tables. This is well documented in the INFORMIX manuals for Universal Server - specifically the "Tutorial", chapters 12 and 14. The documentation is available online from INFORMIX's web site http://www.informix.com/answers You have to realise that INFORMIX is not ORACLE. The methods for achieving the same goals vary. You don't write a C++ program the same way you write a C program. Similarly, an SPL procedure will differ from a PL/SQL procedure. Good luck, Avi. ************************************************************************ /\\ \\ /| Avi Abrami, Analyst/Programmer, Telegate Ltd. /__\\ \\ / | 7 Haplada Street, Or-Yehuda, ISRAEL / \\ \\/ | Phone:+972-3-5388717 Fax:+972-3-5335877 eMail:avia@telegate.co.il