Search results for query: *

Dear All, I have IDS 9.3 on sun solaris 8. My database is created with buffered logging. I execute the below steps thgough a script / dbaccess. begin work; execute procedure 1; execute procedure 2; commit work; The first procedure executes properly, but there is an error in the second one...

Dear All, I have set my db_locale to "en_us.utf8" and created a new database. When i try to insert japanese/chinese data into blob (same goes for clob & text datatype too) they get stored as junk, however i can store all other european languages into blob properly. Also these data get stored...

Dear All, I am testing on migration from one database to other. I have a file which contains all the database changes (insert/update/delete) that need to be run. Is there anyway i can log all these statements in to a file. When i run this file and if any of these statement fails can i come to...

Dear All, I need some help on procedures. I have a table which has around 5000 records. I need to insert additional 200 records, i have insert statements ready for the same. I need to make sure while inserting that if records does not exists in the table it should insert them or else update...

Dear All, I am facing a problem of storing japanese/chinese data in blob datatype. I have created a database in utf8 format to support multi-lingual data. I can store japanese data in char/varchar datatype, however when i try to store the same in blob datatype they are stored as junk. The same...

Dear All, When i try inserting japanese or chinese data in to blob data type it stores as junk, something like this 次� 年, but when insert the same data in a char or varchar field it stores as ?? ?. Is it that blob does not support japanese data. Thanks in advance. Best Regards,

Dear all, Is it possible to insert GMT date in Informix date/datetime variable or we will have to store it as a char datatypee. Below is the output of GMT date -- Tue Mar 16 12:51:04 GMT 2004 Regards, Lloyd

Dear All, My java developers are trying to connect to my DB & are getting the error "java.sql.SQLException: System or internal error". What could be the problem. This error happens occassionally. Below are the settings in the property file - XXX.SQLConnectionPool.MinimumReadyConnections=50...

Rootdbs gets filled Dear All, I need ur help. I have IDS 9.3 on sun solaris 8. My Informix server is going for a toss. I am attaching my onconfig file for ur ref. My users are connecting thru java. They are opening a lot of connections, when i do onstat -g ses, i get around 2000 sessions as a...

Dear All, I have created my database with utf8 codeset. I have a column name in a table with size 20 char. I can insert data in english language upto 20 characters. Now if i want to insert japanese or chinese data i can insert only ??? characters as they are multibyte. But as per...

Dear All, I have a table A with fields 'id' (primary key) and 'name', i have 3 tables b, c and d which have the common columns 'id' (foreign key from table a) and 'name'. The column 'id' is also the primary key in tables b, c and d. I have designed my database in such a way that all my...

Dear All, I have IDS 9.4 on Win 2000. I have installed client sdk 2.81, i have also installed Informix JDBC Driver 2.21.JC5. I have a blob table. I could insert data into the table through java. Now i have installed IDS 9.3 on Sun Solaris and when i try to insert data, i get the foll. error...

Hi All, Does Informix data type support multi-byte characters. I need to insert data with multiple languages. I have a field with nchar(20). If i insert a english or french data of length 20 chars it inserts in to the table. But when i want to insert korean data of same length, then it...

Dear All, I have IDS 9.4 on win, 2000. I want to have multi-language support for my database. Previous threads did not give me sufficient info. I have set my DB_LOCALE variable to en_us.utf8, I also created a new database and a table but cannot proceed further. Now how do i need...

Hi all, I have set DB_LOCALE=en_us.utf8 at the server and created a database and table. Now how to check whether the database supports multi-language. How to insert values. Any other env variables need to be set. Please advice. Regards, lloyd

Hi All, I have installed IDS 9.4 on win, 2000. I have also installed Informix client-SDK 2.81. I created a system dsn to my database & i can connect thru winsql. Now i need to know what are the parameter that need to be set if i need to connect from JAVA. Do i need to install jdbc drivers...

Dear All, I have downloaded the IDS 9.4 trial ver. from IIUG. When i install it i get the foll. error on my log, "build_smi" failed. I even tried to manually run the buildsmi.bat script and also ran sysmaster.sql script but nothing worked. My instance is running. There is no...

Hi all, I had download IDS 9.4 eval copy from IIUG. When i run setup & create an instance i get the foll error on my log Build_smi failed, cannot build sysmaster database. But my instance is running. But no tables are created under sysmaster database. Foll. is the list of my error log file...

Dear All, Has anyone worked on Informixmultli-language. If yes how can we do the settings to support multi-lingual. I need to support 5 different languages. Please advice. Regards, lloyd

Hi All, When i try to install IDS 9.3 on Sun solaris i get the foll. error /etc/brand : syntax error at line 1 : '(' unexpected, is this got to do with the hardware configuration or is it platform specific installation. Actually i am trying to install Intell ultra sparc and the actual...