DB2 Print analog

Question

What's the DB2 Version of TSQL Print?

I've tried

Print 'TableName:X'

And

Select 'X' As 'TableName'

Answer 1

Uggh...DB2. My condolances. ;-)

I don't think that there is a PRINT command. Have a look here for a similar thread.

Answer 2

Would VALUES 'Tablename=X' work for you?

Answer 3

Use sysibm.sysdummy1. It is a dummy table you can use to print constants values. Print 'TableName:X' would be:

select 'TableName:X' from sysibm.sysdummy1;

And Select 'X' As 'TableName' would be:

select 'X' as TableName from sysibm.sysdummy1;

Similarly if you want to print the current date, etc you can use:

select current date FROM sysibm.sysdummy1;