Re: Defining of records in stored procedures.

Posted in 1996

Cheryl Kendricks — 17 Apr 1996 22:03:14 -0400 — source: Informix-list mailing list archive (1991-1998)

How about unload and load can use these in a stored procedure, if so on what Informix engine version 7.10, 7.11, 7.12.... Thanks! ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR kendric@gwysmtp.jcdc.doleta.gov OR cherylk@spamis.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On 16 Apr 1996, Stefanie Vario wrote: > Peter Tashkoff (TASHKOP@kiwi.co.nz) wrote: > : We can't figure out how to define a record in a > : stored procedure. > : Is it possible? I can't find anything in the manuals on > : it. > : TIA > : -- > > It's not possible. You can only use the data types that are valid in > an SQL create table statement (integer, char, varchar, etc) except > serial. You also can't define arrays. > > -- > Stefanie Vario > svario@zenacomp.com > ZenaComp Incorporated > http://www.zenacomp.com/~zenacomp >