informix
operations on blob data in informix
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?[详细]
2023-01-31 14:18 分类：问答substring operation on blob text in informix
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[详细]
2023-01-30 17:24 分类：问答Translate stored procedure from MS SQL Server to Informix
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[详细]
2023-01-30 10:32 分类：问答Search all columns in Informix table for a value
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.[详细]
2023-01-28 02:00 分类：问答How do I obtain for each distinct primary key occurrence in a table, the first of an ordered set of rows?
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.[详细]
2023-01-27 19:38 分类：问答HowTo for installing Informix ClientSDK on OpenSuSE 11.2
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[详细]
2023-01-27 19:12 分类：问答How to list all Informix database names
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[详细]
2023-01-26 23:11 分类：问答Informix table is locked
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[详细]
2023-01-26 22:19 分类：问答Informix: How to get the rowid of the last insert statement
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[详细]
2023-01-26 15:18 分类：问答Informix query slow
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[详细]
2023-01-26 01:18 分类：问答
![Interactive visualization of a graph in python [closed]](https://www.devze.com/res/2023/04-10/09/92d32fe8c0d22fb96bd6f6e8b7d1f457.gif)
加载中,请稍侯......