Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
3 replies Latest Post - ‏2012-07-30T19:47:37Z by SystemAdmin
SystemAdmin
SystemAdmin
5837 Posts
ACCEPTED ANSWER

Pinned topic Write to a file from a Stored Procedure

‏2012-07-20T15:21:03Z |
Hi,

I am trying to use files from a stored procedure (SQL PL), but I found that this is not possible in DB2 Express-C edition:

http://publib.boulder.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.apdv.sqlpl.doc/doc/c0053670.html

How can I do that?

I do not want to call an external Java Stored Procedure just to deal with files and return the control to SQL PL stored prodedure.
I do not want to use C stored procedure neither, I want to use something native.

Is there any plan to allow this feature in Express-C edition? In version 9.7 it was not available for Personal edition, but in 10.1 it is.

Do you have any ideas?

Thanks.
Updated on 2012-07-30T19:47:37Z at 2012-07-30T19:47:37Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    5837 Posts
    ACCEPTED ANSWER

    Re: Write to a file from a Stored Procedure

    ‏2012-07-21T00:47:25Z  in response to SystemAdmin
    Set your database in Oracle compatibility mode then use UTL_FILE.

    Regards.
    • SystemAdmin
      SystemAdmin
      5837 Posts
      ACCEPTED ANSWER

      Re: Write to a file from a Stored Procedure

      ‏2012-07-21T00:56:52Z  in response to SystemAdmin
      Thanks for the answer, however, if you see the link that I included, you will see that this built-in module is NOT available with Express-C edition. Thus, your solution does not solve my problem.
      • SystemAdmin
        SystemAdmin
        5837 Posts
        ACCEPTED ANSWER

        Re: Write to a file from a Stored Procedure

        ‏2012-07-30T19:47:37Z  in response to SystemAdmin
        Express-C 10.1 haves full Oracle.

        Did you at least tried before posting?

        I did a test before answering you and can assure that Oracle support is there!

        Regards.