Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2006
    Posts
    2

    Unanswered: Dbaccess and Informix on AIX

    I am trying to pass parameter values in a dbaccess command line that will run a .sql file on an AIX platform running Informix Dynamic Srvr. 9.4.

    dbaccess (database name) file.sql (what is the syntax to pass parameter values to -- file.sql ?

    Thanx AOT

  2. #2
    Join Date
    Jul 2009
    Posts
    37
    You're probably better off doing a pre-process on your file using unix.

    eg. let's say you have this in your original ' unload to /tmp/jon/x.unl select * from customers where creation_date >= :creation_date '

    cat [original file] | sed 's/:creation_date/01-04-09/g' > /tmp/jon/tmp.sql

    dbaccess dbname /tmp/jon/tmp.sql

    rm -f /tmp/jon/tmp.sql

  3. #3
    Join Date
    Aug 2009
    Posts
    4
    You're probably better off doing a pre-process on your file using unix.

Posting Permissions

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