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 :-) You do not state what version you are using. This is only possible with the Universal Data Option, I believe. Art S. Kagel