Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mynwo
  • Order by date
  1. mynwo

    Problems with transactions

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

    Storing multi-lingual data in Informix blob datatype

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

    Primary Keys

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

    Error listener-thread: err = -27001 in online.log

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

    How to insert a picture into database?

    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')) ;
  6. mynwo

    How to log an sql statement

    Hi Shriyan / appi, Thanks for the feedback Regards, lloyd
  7. mynwo

    How to log an sql statement

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

    Help on Stored Procedures

    Hi Shriyan, Thanks for your feedback. Regards, lloyd
  9. mynwo

    Help on Stored Procedures

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

    Storing multi-lingual data in Blob datatype

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

    Inserting japanese/chinese data in blob data type

    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,
  12. mynwo

    Recover down chunks

    Hi, Run Onmonitor, Select Dbspace & Info
  13. mynwo

    Inserting GMT date

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

    Informix JDBC - System or internal error

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

    Rootdbs gets filled

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

    Rootdbs gets filled

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

    Installation Problem

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

    Storing Japanese / Chinese Data

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

    Index Creation Error........

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

    Inserting Blob Data (Invalid LO argument)

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

Part and Inventory Search

Back
Top