IC5Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Topic
  • 3 replies
  • Latest Post - ‏2012-07-30T19:47:37Z by SystemAdmin
SystemAdmin
SystemAdmin
5837 Posts

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

    Re: Write to a file from a Stored Procedure

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

    Regards.
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: Write to a file from a Stored Procedure

    ‏2012-07-21T00:56:52Z  
    Set your database in Oracle compatibility mode then use UTL_FILE.

    Regards.
    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

    Re: Write to a file from a Stored Procedure

    ‏2012-07-30T19:47:37Z  
    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.
    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.