db2 print message within procedure

[dsener]

Hi all :)

I like to be able to print messages throughout my long procedure statement.

I can currently use "!echo my message@" outside of my procedure BUT not able to figure out how to do this inside the procedure.

Any help would be greatly appreciated.

Deniz

[sakumar9]

You cannot print directly to standard output device from a stored procedure. However, you can redirect your output to a file. Again, this is possible only if your stored procedure definition is written in a language than SQL/PL.

You can implement file handling.

By the way, what do you want to achieve from doing this?

Regards
-- Sanjay

[docdiesel]

Hi,

Deniz, as far as I can guess you'd like to echo some debug messages, like "stored procedure at point 3", right?

Now that a direct output isn't possible (Thanks Sanjay, I wouldn't have known), I suggest another approach. Create a separate table "debugtext" with columns (when datestamp, txt varchar(255)) and insert your messages into it while inside the stored procedure:

INSERT INTO
  debugtext
VALUES
  ( current_datestamp, 'stored proc at point 7' );

Sanjay, this should be possible, shouldn't it?

Regards,

Bernd

[sakumar9]

Yes Bernd, this is possible....... .....

Regards
-- Sanjay