Results 1 to 2 of 2

Thread: informix query

  1. #1
    Join Date
    Feb 2004
    Posts
    30

    Unanswered: informix query

    i need to run a query where it will read all the name from my text file and pull out the age from informix table according to the names in my text file.The names are the primary key in my database.

    Is there a way i can get this through a script?

  2. #2
    Join Date
    Aug 2004
    Posts
    99
    Hope this is what you are looking for:

    create temp table names (name varchar(20));
    load from names.txt insert into names;
    select a.name, a.age
    from <your table> a, names b
    where a.name = b.name;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •