Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Posts
    76

    Unanswered: Informix Export Schema and Data

    Hi,

    I'm a newbie in Informix and therefore my next questions may appear too simple. I would appreciate any kind of help.

    I would like to know if there is any way to export an Informix Schema to a flat file and export data to another, separetely!
    And what is the syntax for those two cases.

    Thanks.

    Master Aucrun

  2. #2
    Join Date
    Jun 2009
    Location
    Lisboa, Portugal
    Posts
    78
    If you use dbexport, this tool will create a directory with an sql inside like the name of database and that sql as the schema. The data will be in files separated each one as its table.

    LS

  3. #3
    Join Date
    Dec 2003
    Posts
    76
    Hi Luis,

    Thanks for your response.
    By other words you say that with the usage of DBExport, I will manage to have both schema and data in separate files?

    For instance, an example where I have two tables (TABLE_1 and TABLE_2):
    - If I understood correctly, I would have three files:
    - Database Schema with TABLE_1, TABLE_2, Indexes, Views, ...
    - Data from TABLE_1
    - Data from TABLE_2
    Is that right?

    When using DBExport the data files are generated automatically, right? Is there any way of identifying any character delimeter for fields?
    For instance to get me the same result of the following sentence: "UNLOAD to flatfilename DELIMITER ',' SELECT * FROM TABLENAME"

    Thanks!
    Last edited by aucrun; 01-12-11 at 10:22.

  4. #4
    Join Date
    Jun 2009
    Location
    Lisboa, Portugal
    Posts
    78
    Hi aucrun,

    You can read the reference Informix site at:

    IBM Informix Dynamic Server v10 Information Center

    About the delimiter for default is pipe "|", but you can specify one-other using DELIMITER yes. You have to set one Informix variable for export with that.

    Luís.
    LS

  5. #5
    Join Date
    Dec 2003
    Posts
    76
    Thanx.

    I've gathered the Export files from DBexport, and they look like exactly as you've told, with "|" separating the fields.
    Now, reading it onto an Oracle table should be easy with SQL Loader, right?

    Thanks!

Tags for this Thread

Posting Permissions

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