Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    5

    Unanswered: Run dbexprot for only 1 table

    Hello,

    Does anyone know the syntax of dbexport command if I need to unload only 1 table from Informix database? I could not find it anywhere.

    Appreciate the help very much -- Anna

  2. #2
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    dbexport unloads data in the pipe delimited format.
    you can do dbschema -d "dbname" -t "tabname" -ss > "tabname.sql"

    and the run

    dbaccess "dbname" <<!!
    unload to "tabname.unl"
    select * from "tabname"
    !!


    that way you will have the schema and the unload file.
    if you need to do this for multipule tables you can script this.

    Cheers

Posting Permissions

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