Search results for query: *

I have a query where I am select field 1, field 2. Based on the value of feild 2 I would like to be able to output another field with a value, but this field is not a field on my table. (varfld 1) When field 2 = "1" I want varfld 1 = "cookie" When field 2 = "2" I...

table1 will always be resident. It is part of our ERP system. I need to extract updates and inserts to be extracted via another process and sent to another system. I only need the key information for this other session to drive the extracts. I will be recreating the tables that hold the...

I have never written a trigger before and I'm having problems following these wonderful manuals I have. What I want to do is this: On a daily basis create two new tables create table tableA (fld1 char) create table tableB (fld1 char) Then I need to track new records or updates seperately...

TEXEXPAT... how do you get it to write to disk? we are trying to do this ..........

Thanks!

Probably a Stupid question. but. What is a table scan? When I look up stats on my informix tables using a canned query that informix gave me, it has a column listing the number of scans against a table. (the other columns are nrows, nread, nwrites..etc). Are scans good or bad or is it all...

I have tried both formats and I'm getting closer. I suspect I will have to finish in unix, but just incase.. I thought I'd post my findings here. This query: unload to rcgweb08.out delimiter " " select t_cpls, t_item, t_qanp, t_pric from ttdsls032101 where t_stdt between today-1...

I have written a query and pulling data from an informix table into an output file. I figured out how to strip the column labels off,,, Now I have two questions 1. I have two blank lines on the beginning of the file that I want to get rid of. can i do this with an sql statement? (I know i can...

This helped me tremendously for something I am doing. One additional question. When I use this to suppress column labels, I get 2 blank lines in the beginning of my file. How do I suppress blank lines? Thanks!

Great! thank you so much!!

I am using informix with BaanIV. I know how to do simple queries. I need to pull the data from a table based on date. I know how to do this hard coded, but I need to be able to run this query from our crontab on unix and look for all changes for today and yesterday. How do I get this query to...