Inquiry of Creating Procedure in Informix 10

kent_plaza · #1 (**permalink**) 01-24-08, 04:58

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 · #2 (**permalink**) 01-24-08, 10:32

Unfortunately i think this is not possible...

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

kent_plaza · #3 (**permalink**) 01-24-08, 21:48

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

ceinma · #4 (**permalink**) 01-25-08, 06:23

Code:

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
...
..

Internet Services

Web Development

Digital Marketing

Consumer Tech