Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MizzGail
  • Content: Threads
  • Order by date
  1. MizzGail

    assign value to variable based on a field value...

    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...
  2. MizzGail

    Triggers

    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...
  3. MizzGail

    table scan

    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...
  4. MizzGail

    creating data files from a query

    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...
  5. MizzGail

    "newbie" ... variable date in query

    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...

Part and Inventory Search

Back
Top