Search results for query: *

Dear All, We have Informix 9.21 running on Solaris and using Java for application development. At present we have our Database as ISO-8859 we are planning to use UTF-8 . I have set up a new database for UTF-8 with the following steps 1.Export the database 2.Set DB_LOCALE to en_us.utf8...

Hi All, I have a major problem on Production box, recently we have changed thes erver, and exported and imported the database to new server from old box. Version is 9.21C on Solaris. In one table there are 10 fields of datatype LVARCHAR, in export file (.unl) the data is present , but when it...

Hi All We are running production box with informix 9.21 on solaris, the present database has installed with DATABLADES (ETX,LLD adn TXT) but we are not using any blobs, clobs ,rowdatatypes etc in our database. Separate webserevr running tomcat. We got a new database server for a better...

Hi Shriyan Thanks for your reply. The Clause "First" will not serve the purpose, as one of the developer wants to restrict the number rows returned from the large query , so that she can display in 50's . She wants to know is that possible to write in Sql, i am working on Web...

I'd like to know if is it possible only to get a defined range of rows from informix. That is, I'd want to recover rows from number 1 to 50 the first time, from number 51 to 100 the second time, from 101 to 150 the third time, and so on... and display from the java application , so that it can...

I'd like to know if is it possible only to get a defined range of rows from informix . That is, I'd want to recover rows from number 1 to 50 the first time, from number 51 to 100 the second time, from 101 to 150 the third time, and so on... from the java application, and display per page so...

Hi I have a small database with around 80 tables , and cron job is running to do update stats "update statistics high " runs every night on database and on sysutils , we do have lot of data going to database for few tableseveryday . The biggest table has 500000 rows. Is...

What needs to be set in informix for searching keywords like café . if we give sql as select * from test where name matches '*mycafé*' or select * from test where name matches '*café*' it does not work but it works with select * from test where name matches '* café*' select * from test...

Hi I have to pick up 14 fields data ,concatenate and load them into another table. The main table had 4 fields which are of type VARCHAR(255) and rest 10 fields are of type lvarchar. Another table has 2 columns one is of type integer and another one is CHAR(10000). I have written a stored...