Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367

    Unanswered: create file from trigger

    Is there a way to create / write to a file from a trigger (in v9.1 and v9.7).

    Found the following discussion on google, but it's 4 yrs old:
    CREATE TRIGGER -> writing to file??? - DB2 Database answers

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    In 9.7 you can use UTL_FILE from the Oracle compatibility package. In 9.1 you'll have to call an external (e.g. Java) SP from the trigger.

Posting Permissions

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