How can we use substring, trim, length operations on some text of blob datatype. And how can we upda开发者_StackOverflowte a column of blob datatype using query?
How can I substring a text of BLOB datatype in informix? If the operation is possible only on text of char d开发者_StackOverflow中文版atatype, is it possible to convert from BLOB to char (like to_char
I do not know how to write a specific stored procedure in Informix, so I had to write the logic in my mind in SQL Server which I know how to write (Microsoft simplicity)... So I will write my stored p
I am new to Informix, but remember doing this with SQL Server.Basically I want to query all columns in a given table for a specified value.
I want to obtain a specific set of results from a table in a single query and I\'m not being able to find how to do it.
Is there a simple tutorial or HowTo that describes the installation of the I开发者_如何学JAVABM Informix ClientSDK on OpenSuSE 11.2? I was not able to get it work.... I set all the system environment
I want to know if there is any 开发者_开发问答way to list (get) all the database names on Informix. I need a proper query or stored procedure to do that.Alternatively you could execute this query when
Our J2EE web application runs against Informix 9.40. Sometimes one table is locked and then any JSP having SQL code accessing this table will retur开发者_如何转开发n an error.I know how to use onstat
This is an extension of a question I asked before: C#: How do I get the ID number of the last row inserted using Informix
IDS 9.04 on unix. I got a table which has 200000+ rows ,each row has 200+ columns. when I execute a query (supposed to return 470+ rows with 50 columns)on this table,it takes 100+ secs to return,and
加载中,请稍侯......