5.10 Print output messages

 < Day Day Up > 



5.10 Print output messages

When converting the call statement of Oracle function dbms_out.put.put_line(), MTK provides only a function skeleton for you. You still need to implement the function, which will best suit your application needs.

We offer you a user-defined function (UDF) solution called PUT_LINE() that will enable file output from pure SQL, such as an SQL stored procedure. You can use it as a tool for debugging stored procedures, but it also allows you to write to a specified file for other purposes as well.

You can find the sources of the function and a installation guide as additional material on the IBM Redbooks Internet site. See details on Appendix G, "Additional material" on page 415.



 < Day Day Up > 



Oracle to DB2 UDB Conversion Guide2003
Oracle to DB2 UDB Conversion Guide2003
ISBN: N/A
EAN: N/A
Year: 2004
Pages: 132

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net