Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2002
    Posts
    12

    Unanswered: how to capture import utilty output

    Hi,

    I am using messages as one of the command parameter for the import.
    but i am able to see some statements ( descriobed below ) on the console.

    Number of rows read = 12
    Number of rows skipped = 0
    Number of rows inserted = 12
    Number of rows updated = 0
    Number of rows rejected = 0
    Number of rows commited = 12

    How can i capture the above mentioned information to a specific file.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: how to capture import utilty output

    If I understand your question right,

    Redirect the output to a file, like

    IMPORT from .................. replace into table1 > table1.out

    HTH

    Cheers

    Sathyaram

    Originally posted by bondalapati100
    Hi,

    I am using messages as one of the command parameter for the import.
    but i am able to see some statements ( descriobed below ) on the console.

    Number of rows read = 12
    Number of rows skipped = 0
    Number of rows inserted = 12
    Number of rows updated = 0
    Number of rows rejected = 0
    Number of rows commited = 12

    How can i capture the above mentioned information to a specific file.

  3. #3
    Join Date
    Oct 2002
    Posts
    11

    Re: how to capture import utilty output

    Hi,

    You can also use the '-z' DB2 option along with the output file name while giving the import command.

    HTH,

    Ashtyu

    Originally posted by bondalapati100
    Hi,

    I am using messages as one of the command parameter for the import.
    but i am able to see some statements ( descriobed below ) on the console.

    Number of rows read = 12
    Number of rows skipped = 0
    Number of rows inserted = 12
    Number of rows updated = 0
    Number of rows rejected = 0
    Number of rows commited = 12

    How can i capture the above mentioned information to a specific file.

  4. #4
    Join Date
    Sep 2002
    Posts
    12

    Re: how to capture import utilty output

    Originally posted by sathyaram_s
    If I understand your question right,

    Redirect the output to a file, like

    IMPORT from .................. replace into table1 > table1.out

    HTH

    Cheers

    Sathyaram
    Thanks for every one.

Posting Permissions

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