Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2004
    Location
    Kansas
    Posts
    5

    Exclamation Unanswered: Exporting an .ixf flat file from a global temp table

    I am needing to know if on a DB2 version 8 database,

    Can I export a .ixf flat file from a global temporary table session??

    If I can, what exactly is the syntax. Thanks

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Yes, you can export, but you cannot import.

    Syntax:
    export to d:\arw.ixf of ixf messages d:\mess.out select * from session.fred

    Andy

  3. #3
    Join Date
    Jul 2004
    Location
    Kansas
    Posts
    5
    What about if I am using a java program to run sql on a UNIX box. How can I incorporate the export process to export the file out. Currently, this is one export that I have, but it exports a .dat file

    [INSERT]
    !!TABLE NAME = SESSION.TEMP_PRICE_DOM
    !!EXPORT = /markopt/data/
    INSERT into
    SESSION.TEMP_PRICE_DOM
    SELECT distinct
    'PAYLESSCORP',
    'PAYLESS',
    '1LT' || char(a.num_lt) as lot,
    'LOT',
    rtrim(char(a.num_co)) || '01S' || rtrim(char(a.num_str)) as store,
    'STORE',
    TIMESTAMP(@@DTWKE@@ - 6 days),CURRENT TIME),
    ' ',
    CURRENT TIMESTAMP,
    'A',
    a.amt_unt_rtl,
    TIMESTAMP('@@DTWKE@@',CURRENT TIME),
    'ACTUAL PRICE',
    'USD',
    'REG'
    FROM
    session.domestic a;

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You have a problem. Export is not SQL, it is a command and therefore cannot be executed through JDBC.

    Andy

  5. #5
    Join Date
    Jul 2004
    Location
    Kansas
    Posts
    5
    Thanks for your help Andy, I think I can work around this somehow. I was just trying to get it all in one job instead of breaking it down to 2. Thanks though.

    Rob

Posting Permissions

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