when a new row is added to a table containing a serial column, the next highest integer value is assigned to that column when the row is committed. can I define a serial datatype which will autoincrement when updating a row with a previously assigned serial value?...in datablade?.. I'm currently using the following functionality for an i...
Looking for the following forms functionality with INFORMIX 4GL?, ISQL with ESQL/C?, PROGRESS-4GL?, ORACLE? etc? I have a CRUD form which displays a customer[master] with all of their asociated transactions in record arrays[detail] on the same screen: [id ] [fullname ] [address1 ] [address2 ...
Hello, I have an application that connects to informix that is written in vb.net. I previously had this application working on a server with .net 3.5 installed. I then attempted to upgrade the server to .net 4.0 along with an upgraded application. That broke the whole application. I then uninstalled .net 4.0, rolling the server back ...
I am attempting to fire up ISQL 4.10DC1 on MS-DOS 6.22, but cant seem to get PSTARTSQL.EXE to load, it says DOS16M Error[6]: Not enough memory.. I have DEVICE=C:\DOS\HIMEM.SYS as my first line in CONFIG.SYS and properly set all environment variables, including DOS16M=3. Anyone have any experience with this version of ISQL?..Does anyone h...
Hello, I am having trouble connecting to an informix database from a .net web application. I am not able to modify the code in the application. When I try to run the application, I am getting the following error - SQL0035N The file "en_us\IBM.Data.Informix.xml" cannot be opened. I assume it is an incorrect configuration in my ma...
Background Information: Visual Studio 2010 (.NET Framework 4.0) Informix Server 7.31 Informix ClientSDK 3.50 TC7 (Windows 32-bit) was installed as well. I have tried multiple ways suggested online to connect to the Informix server, but all of them do not work for me for whatever reason. I have looked at articles such as Connect Info...
Hi, We have installed informix client in 64 bit machine. Informix client doesn't include "dbaccess" command. Our application uses "dbaccess" command in many shell scripts. As per the configuration we are not supposed to install server here. Is it possible to download or configure "dbaccess" alone? Appreciate the support in advance. Th...
I maintain a 3rd party Informix driver that's written with ESQL-style (Informix API) calls. I'm working on a bug where, for TEXT fields, INSERTs work fine and UPDATEs fail. Stepping through the code, what I've found is that we're checking our sqlda structure to tell us whether and how to bind, and after the call to sqli_describe_statem...
If you do, I'm looking for documentation pertaining to installation settings and DOS protected mode troubleshooting. I'm getting a DOS/16M: Error [6] Not enough memory to load PSTARTSQL.EXE (protected mode SE engine). Any help would be greatly appreciated! ...
The docos say "screen size 80 by 20" but I would like to go to 132 columns wide. ...
Informix-SE 4.10.DD6, Informix-SQL 4.10.DC1 Perform screen: 1) I have column defined as DATETIME HOUR TO MINUTE and when I display it in ISQL Perform screen its default format is HH:MM (24-hour time). I would like to display it as HH:MM (am/pm). Perform format attribute only applies to DATE and DECIMAL datatypes. How can I format displa...
IDS with INFORMIX-SQL Perform Screens: Let's say I'm adding a new customer row with perform. I want to scan the customers drivers license and store that image along with the customers personal info. How is this accomplished?.. Later on, the customer returns and I query his personal info. Then I want to view the customers drivers license...
Hello folks. I've installed the trial version of IBM Informix Dynamic Server 11.50 on my development laptop, for use with an ASP.NET 2.0 app I'm writing. I have created a couple databases and filled them with sample data but I cannot connect. This is the relevant section of code: Dim facStr As String = System.Configuration.Configuratio...
Hi, I have a stored procedure get_data(estargs set(char(1000) not null)) in the informix 11.5 database. I have to use this stored procedure in order to get a value from the database. I tried using this way but it fails: conn = dataSource.getConnection(); String [] arrayObj={"and code = 'Value1'","and lmt= 10000.000"}; ...
Informix-SQL(SE) 4.10.DD6 (MS-DOS 6.22): I have a table created as: "pcuser".tablename. I attempted to drop this table with: DROP TABLE tablename; and received the following error message: 545: No write permission for table pcuser.tablename. Since my app is single-user and I'm not concerned with restricting privileges for any ta...
I have a stored procedure like this: CREATE PROCEDURE Proc_Test(testvalue set(char(1000) not null)) RETURNING int; DEFINE z char(7000); LET z = ' '; FOREACH select * into z from table(testvalue) END FOREACH; return 1; end procedure; Due to the change in the requirement I would like to change this stored procedure as:...
Can ISQL Perform forms co-exist with I4GL forms within I4GL and access the same SE or IDS engine? ...
The output of onstat -g ses displays both hostname and tty columns. However, both of these are truncated to the first 8 chars. Is it possible to obtain the hostname or tty in full from any other variant of onstat? (For network connections - and my purposes - they are interchangeable) Background: we have a script executing onstat -g ses...
I would like to add a "Print-Ticket" command to the ring menu in my I4GL Form so that when my users hit the escape key to update a transaction row they can select the "Print-Ticket" command from the ring menu to print the current row being displayed with an ace report, without exiting the form. I would also like this print capability for...
I have the following SQL script with two unload statements: UNLOAD TO "actives.unl" SELECT * FROM table1 AS t1 WHERE t1.status = "A" ORDER BY t1.fk_id; UNLOAD TO "inactives.unl" SELECT * FROM table1 AS t1 WHERE t1.status = "I" ORDER BY t1.fk_id; When I execute the script from within ISQL's QueryLanguage M...