Informix - Fetching Records from a table

Posted by Pradeep on Stack Overflow See other posts from Stack Overflow or by Pradeep
Published on 2010-05-27T11:48:24Z Indexed on 2010/05/27 11:51 UTC
Read the original article Hit count: 178

Filed under:

informix

Consider the below table

Col1 Col2 Col3

123 ABC 20/5/2010

123 CDS 21/5/2010

123 VDS 22/5/2010

123 ABC 23/5/2010

123 VDS 24/5/2010

123 CDS 25/5/2010

123 ABC 26/5/2010

I need to fetch the first occurrence of CDS and calculate the time diff between the next row. Similarly I need to find out the next occurrence of CDS and calculate the time diff with the next row. This has to go on until there are no occurrences of CDS left in the table.

Will be grateful if someone can help on this!!

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

Developer IT

Informix - Fetching Records from a table - Developer IT

Informix - Fetching Records from a table

informix

Related posts about informix

How to improve Java perfomance on Informix for Windows

Informix "Database locale information mismatch"

Problem with Informix JDBC, MONEY and decimal separator in string literals

Users Login Info in INFORMIX-SQL

String concatenation within INFORMIX-SQL "Perform" screens.

Categories cloud