Recent content by mynwo

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