Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    55

    Unanswered: DB2 commit and export question

    Two questions:

    1 How can I turn the auto commit off for the SQL I input. ( instead of
    DB2 -c "update tablexxx set colxx=A"

    2. I want to export data to a format without " " as delimiter, just BLANK,
    How can I do that.

    Thanks for advice.

    Hansen

  2. #2
    Join Date
    May 2002
    Location
    Pune, India
    Posts
    23
    Hi guyang2000,

    1.
    a. Try setting db2set variable DB2OPTIONS to +c .
    b. from CLP run this : update command options using c off

    The later one did not work for me on NT. but the first method does.

    2.
    Check the export command documentation, it specifies something known as chardel (character delimiter) which might be of interest to you.

    Regards
    Sumeet

Posting Permissions

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