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...

Hi, Run dbaccess & select your database and run the below query, change the values for column - owner select * from sysconstraints where owner = "jack" and constrtype = "P

Hi, This got to do with your network connectivity to your database. It comes when the network is slow or too many clients are accessing the database at the same time. If these error come occassionally you can ignore them as they are just warnings but if they are frequent then you might...

Hi, You will have to store them in blob datatype. Here's an eg. create table myblob ( no smallint, blob_data blob ) insert into myblob(no, blob_data) values (1, filetoblob('c:\abc.jpg','client')) ;

Hi Shriyan / appi, Thanks for the feedback Regards, lloyd

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...

Hi Shriyan, Thanks for your feedback. Regards, lloyd

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,

Hi, Run Onmonitor, Select Dbspace & Info

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...

Hi ids2000, Thanks for your feedback, i will work on it. Best Regards, Lloyd

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...

Hi Shhankar, The brand error that your are getting is because of the platform. Are you sure you have IDS 9.4 under solaris 8 (intel platform) or its Sun Sparc. Make sure about it, i too had faced a similar error earlier. Best Regards, Lloyd

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...