IBM Informix using spatial datablade

Posted by changed on Stack Overflow See other posts from Stack Overflow or by changed
Published on 2010-03-25T22:16:11Z Indexed on 2010/03/26 0:23 UTC
Read the original article Hit count: 359

Filed under:

ibm

|

informix

|

spatial

I need to use IBM Informix for my project where I have point coordinates and I need to find which points are present in query rectangular region.

Informix has spatial datablade module with ST_POINT and ST_POLYGON data objects. I know how to create, insert and create r-tree index on tables with such objects.

But problem is how to do a SELECT statement, something which list all the points in a particular rectangular region.

© Stack Overflow or respective owner

Related posts about ibm

An Open Letter from Lyle Ekdahl, Group Vice President and General Manager, Oracle's JD Edwards

as seen on Oracle Blogs - Search for 'Oracle Blogs'
From Lyle Ekdahl, Group Vice President and General Manager, Oracle's JD Edwards As you may have heard, we recently announced some changes to the way Oracle will offer licensing of technology products with JD Edwards EnterpriseOne. Specifically, we have withdrawn from new sales the product known… >>> More
Websphere federated repository for Active Directory

as seen on Server Fault - Search for 'Server Fault'
Hi, What I am trying to achieve is to have Websphere 6.1 use Active Directory users authentication. Websphere is running on Windows 2008 R2. What I've done already: Succesfully setup a federated repository for Windows Active Directory (LDAP); Create a realm definition for the federated repository… >>> More
IBM InfoPrint 1532 Printer And IBM InfoPrint 1532 Laser Toner - Amazing Functionality And Affordabil

as seen on Article City - Search for 'Article City'
The IBM InfoPrint 1532 printer is the advanced version of the Express printer models. IBM introduced additional features to the InfoPrint monochrome laser series and this printer came about. This dev... [Author: Ben Pate - Computers and Internet - March 21, 2010] >>> More
IBM Keynote: (hardware,software)–>{IBM.java.patterns}

as seen on Oracle Blogs - Search for 'Oracle Blogs'
On Sunday evening, September 30, 2012, Jason McGee, IBM Distinguished Engineer and Chief Architect Cloud Computing, along with John Duimovich IBM Distinguished Engineer and Java CTO, gave an information- and idea-rich keynote that left Java developers with much to ponder.Their focus was on the challenges… >>> More
Getting NoClassdef on HMAC_SHA1 in Webpshere

as seen on Stack Overflow - Search for 'Stack Overflow'
We have WAS 6.0 (I know) .2.43 ND running in multiple regions. Our Dev-B region runs fine, but Dev-C throws a java exception when we make web-calls (at least this is what the developer tells me)...Same code in both regions and I checked the obvious suspects (Global security, SSL ciphers etc) and… >>> More

Related posts about informix

How to improve Java perfomance on Informix for Windows

as seen on Stack Overflow - Search for 'Stack Overflow'
I have problem with performance of Java UDR functions on Informix on Windows. On this server I already have some functions in C and SPL. I chose one function to write it in those 3 languages and I measured performance of this function on test table. Function calculates some kind of checksum so it… >>> More
Informix "Database locale information mismatch"

as seen on Server Fault - Search for 'Server Fault'
I have informix 11.5 running in my Win-2003 box and few databases running in it. System databases have locale en_us.819 My custom databases have locale en_us.57372 (UTF8). There is also application deployed to JBoss 4.0.2 which has few datasources configured for those custom databases. <local-tx-datasource> <jndi-name>InformixDS</jndi-name> <connection-url>jdbc:informix-sqli://@database… >>> More
Problem with Informix JDBC, MONEY and decimal separator in string literals

as seen on Stack Overflow - Search for 'Stack Overflow'
I have problem with JDBC application that uses MONEY data type. When I insert into MONEY column: insert into _money_test (amt) values ('123.45') I got exception: Character to numeric conversion error The same SQL works from native Windows application using ODBC driver. I live in Poland and have… >>> More
Users Login Info in INFORMIX-SQL

as seen on Stack Overflow - Search for 'Stack Overflow'
INFORMIX-SQL 4.1 - There's this ASCII UNIX file called "passwd" in /usr/informix/etc which holds all the user id's and encrypted passwords to log into ISQL. Is there a system catalog table which holds the logged in users? I see a SYSUSERS.DAT file but when I queried it, it didnt show my login id… >>> More
String concatenation within INFORMIX-SQL "Perform" screens.

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I concatenate two char columns within a perform screen? example: table sample col1 char(1), col2 char(1) . . after editadd of sample let label_3 = sample.col1 + sample.col2 .. this didn't work, I even tried using subscripts for the 2 cols but no dice! >>> More