RE: SQL stored procedures:

Matt,

SQL does not directly support the concept of arrays, as this violates the
concept of a "normalized" database as defined by Dr. E.F. Codd.  Without
knowing more details about your database and objectives, it's nearly
impossible to know how to advise you.

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



> -----Original Message-----
> From: Matt Patee [mailto:mpatee@abm.com]
> Sent: Monday, August 26, 2002 4:28 PM
> To: midrange-l@midrange.com
> Subject: SQL stored procedures:
>
>
> How do you define arrays within an SQL stored procedure? What
> is the syntax
> for populating and accessing data via subscripting within an array? Is
> there a good website that shows examples?
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Matthew Patee
> Midrange Systems Manager
> ABM Industries
> (415) 351-4309
> fax:(415) 351-4331
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>