[kent_plaza]

I am facing some difficulty to use procedure in IBM Informix 10 database.

When I creating a new procedure, I need to specify the return datatype(bold) :-

--------------------------------------------------------------------------
CREATE FUNCTION gl_contingent_get()
RETURNING VARCHAR(2) as contingent_id,VARCHAR(20) as contingent_name

DEFINE v_contingent_id VARCHAR(2);
DEFINE v_contingent_name VARCHAR(20);
--------------------------------------------------------------------------

I would like to know is it any method able to refer column datatype rather than specify each.

For example in Oracle, we can use TableName.ColumnName%Type to refer particular datatype of a column.



Thank you.

[ceinma]

Unfortunately i think this is not possible...

What you can do is create distinct data types and uses them...

[kent_plaza]

Thanks for you reply.
ceinma, what do you mean "create distinct data types" ?

[ceinma]

create distinct type myDataType_cod as integer
;
create distinct type myDataType_txt as char(100)
;
create table xyz (
  cod   myDataType_cod,
  txt     myDataType_txt
);

create function xyz() returning myDataType_cod as COD , myDataType_txt as TXT
...
..