Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2002
    Posts
    11

    Unanswered: SQL Stored Procedure and Output file

    Using DB2 Sql Stored Procedure is it possible to write the output into a file ?.

  2. #2
    Join Date
    Feb 2002
    Posts
    3
    VSAM files and flat files can be accessed directly by stored procedures, as long as the files are made available to the SPAS with appropriate JCL DD statements. In such cases, the userid associated with the SPAS address space is used to check authorizations.

  3. #3
    Join Date
    Jan 2002
    Posts
    11
    Thanks for your response.
    I was actually refering to SQL Stored procedure in DB2 UDB 7.2 .

    I called up IBM tech support and this is what they suggest.
    In order to write the output into a flat file, the store procedure needs to be coded in C, Java etc.
    The SQL Stored procedure for DB2 UDB does not support writing or reading from a flat file.

Posting Permissions

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