Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2002
    Location
    central ny
    Posts
    6

    Question Unanswered: columns that store arrays?

    my boss (who is -not- an rdba) wants to have tables that store cartesian type coordinates, and he wants those coordinates to be stored in one column.

    i.e. column "coordinate" with (i,j,k) or for example (10,20,30) or (5.25,1.34,8.456)

    instead of what i'd naturally think to do with three columns, column "i" column "j" and column "k" with the three parts of the cartesian coordinate.

    i'm hesitant to use a comma separated value string in the column (to implode and explode with a programming language like PHP) because... i want DB2 to see the numerical data as numerical data, so i can order rows correctly and find a range of values from the table (i.e. say i want to get all of the rows where coordinate 'i' is > 200 and < 500)

    is it possible to write an array like this to a column in a DB2 table? if not it's ok, i just would rather not have to be the one to explain to my boss that it's not a possibility :-0 !

    thanks!

    -doug

  2. #2
    Join Date
    Jan 2002
    Location
    Manila, Philippines
    Posts
    71
    Have you tried DB2 Spatial Extender ?

  3. #3
    Join Date
    Jun 2002
    Location
    central ny
    Posts
    6
    Originally posted by oliver
    Have you tried DB2 Spatial Extender ?
    actually, no, sounds like that might be just the right tool.

    thanks a ton, i'm gonna go read about it right now thanks again.

    peace!

    -doug

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Be aware that using Spatial Extenders will cost you additional bucks on Licencing ...

    Cheers

    Sathyaram

    Originally posted by protocoldroid


    actually, no, sounds like that might be just the right tool.

    thanks a ton, i'm gonna go read about it right now thanks again.

    peace!

    -doug
    Last edited by sathyaram_s; 06-27-02 at 15:54.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •