we are looking with great attention at your code... please be patient.. your entry has been recorded with priority 1
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be
[db2inst1@Myserver ixf]$ db2 connect to MyDB
Database Connection Information
Database server = DB2/LINUXX8664 10.1.2
SQL authorization ID = DB2INST1
Local database alias = MYDB
[db2inst1@Myserver ixf]$ db2 "call dbms_output.put_line('Hello there')"
Return Status = 0
[db2inst1@Myserver ixf]$ db2 set serveroutput on
DB20000I The SET SERVEROUTPUT command completed successfully.
[db2inst1@Myserver ixf]$ db2 "call dbms_output.put_line('Hello there everyone')"
Return Status = 0
Hello there everyone
[db2inst1@Myserver ixf]$ db2 disconnect all
DB20000I The SQL DISCONNECT command completed successfully.
Now I do not know if wrapping into a Stored Procedure will net the same results.
Thank you for all your responses.
I can view the result from my command prompt.
Can any one help me to view the output , when i am running my procedures through IBM data studio.
I mean how to SET SERVEROUTPUT ON in IBM DATA STUDIO.
That option only works when executed in a terminal like the db2clp (db2cmd.exe or any shell in Linux).
In data studio or similar applications do not work there, because they do not have standard output. The only thing they show is the result set, and the returned code from the routines.
The documentation is not very clear there, but when they talk about a "buffer" seems like the standard output, but it is not. A similar thing happens the with get_line procedure
Probably they work in CLP*Plus, but I have not tested.