Search results for query: *

Hi, i'm not sure where to post this question. Please let me know if there is a better part of the forum to post this. I'm using Informix 4GL (11.50. database) on an AIX Unix server (6.1 o/s). I have code that uses the function keys and keys on the keypad to do certain things. For example...

Hi, i am using Informix 11.50.FC3 database on an AIX 6.1 UNIX server with 64 GB of memory. I am trying to use the dbload command utility to load a file into an informix database table. How can i substitue a hardcoded value into a field whenever i see spaces, instead of the data from the input...

Does anyone know how i can check to see if this informix program has a memory leak? SQL error -406 refers to "memory leak", but i'm not sure how i could tell.

That's correct. The program hasn't changed in months, nor has the Informix version, nor has the database version changed. The only thing that i can see happening is that the program is now processing more data than it ever has before and the output files are larger. We've even gone it and...

Database: Informix 11.50.FC3 Server: AIX 7.1 o/s with 64 GB of memory We have an Informix 4GL program that runs in batch mode and creates an output file. The output file is an xml file. Recently, the program starting failing with the following error: Program stopped at...

Using Informix 11.50.FC3 on an IBM AIX UNIX server with the 6.1 o/s. We use forms to add data to tables. To access forms, we enter "forms" at the UNIX server prompt. This brings up an interactive app that allows us to connect to the appropriate database, select a table and then create/generate...

Using Informix database 11.50.FC3 on an AIX UNIX (o/s 6.1) server. Table has 3 records with the following columns. Two of the records have same phn_nbr and time_stmp: record_type source_chnl time_stmp phn_nbr phn_sts frst_nm mi lst_nm DTL 100040 2013-05-22...

Hi PHV. I tried your suggestion (and different variations), but i get a syntax error.

Here's another version of the sql: update table1 a set (a.first_name, a.last_name) = (select b.first_name, b.last_name from table2 b) where a.family_id = b.f_id and b.create_date > '01/01/13' and b.ref_no between 1 and 10 and a.first_name is null and...

using informix db 11.50.FC3 AIX Unix server 6.1 O/S I have two tables. I want to get values out of one table and update the other table. Table 1. first_name last_name family_id Table 2. first_name last_name f_id create_date ref_no I want to update the first_name and last_name columns in...

Thanks so much. I got this to work. Initially i didn't think the inner join wold work because i had trouble joining a table to itself, but using your example, i can see where i made a mistake.

using informix db 11.50.FC3 AIX Unix server 6.1 O/S i have a table with record type, name, timestamp, status and phone number; there can be multiple records with the same phone number; i want a result set that does not have the same phone number on multiple records; if there are two records...

Ok thanks. I entered --> output to pipe "cat" without headings as the first line of my sql and it worked...no headings. Thanks for your help. I made it harder than it was!

Yes it looks like that would work, but i thought there was possibly a keyword i could use in my isql statement to suppress headings. If i could use the "WITHOUT HEADING" key words without isql having to create the output file, that would work for me.

Informix DB: 11.50.FC3 unix AIX: 6.1 o/s i'm executing an isql statement and i want to suppress the headings. I'm using a unix script to execute the isql command and the unix script takes care of creating the output file...i'm not creating the output file in my isql statement. Unix command...

In informix 4gl, when i declare a cursor (either declare with select or insert), does the cursor hold/consume memory that may impact system performance. For example, i have a declare cursor statement with a select that should bring back over 1 million rows (each row with 20 columns that are at...