Unanswered: DB2 select statement - prefix and append output with text
I am running DB2 v22.214.171.124 as the backend database to TSM 6.3.
I am working on a select statement where I could use your assistance.
select volume_name from volumes where DEVCLASS_NAME like 'LTO4' order by PCT_UTILIZED
The output from the statement is:
I would like to modify the select statement to:
1. Remove the VOLUME_NAME: from the output.
2. Remove the blank lines from the output
3. Prefix the data with a string (move data)
4. Append output with a string (wait=yes)
As an example I am looking for output that looks like: Move data L00855L4 wait=yes
Move data L00899L4 wait=yes
Move data L00821L4 wait=yes