doubt in creating a csript

[@euevolui]

Hi Guys, first of all, sorry about my english, is not my first language.

I need to create a script for daily maintenance more or less like this:

DEFINE SCRIPT CONFERENCIA DESC="Conferencia diaria AMM Paraná - Thiago Bassan"
UPDATE SCRIPT CONFERENCIA "/* --------------------------------------------*/"
UPDATE SCRIPT CONFERENCIA "/* Script Name: CONFERENCIA */"
UPDATE SCRIPT CONFERENCIA "/* Description: Conferencia diaria AMM Paraná */"
UPDATE SCRIPT CONFERENCIA "/* Realizado por Thiago Bassan */"
UPDATE SCRIPT CONFERENCIA "/* --------------------------------------------*/"
UPDATE SCRIPT CONFERENCIA "/* ----- NOME DA LIBRARY ----------*/"
UPDATE SCRIPT CONFERENCIA "SELECT LIBRARY_NAME, LIBRARY_TYPE FROM libraries"
UPDATE SCRIPT CONFERENCIA "/* ----- QUANTIDADE DE FITAS PRIVATE ----------*/"
UPDATE SCRIPT CONFERENCIA "SELECT LIBRARY_NAME,COUNT(*) FROM LIBVOLUMES WHERE STATUS='Private' GROUP BY LIBRARY_NAME"
UPDATE SCRIPT CONFERENCIA "/* ----- QUANTIDADE DE FITAS SCRATCH ----------*/"
UPDATE SCRIPT CONFERENCIA "SELECT LIBRARY_NAME,COUNT(*) FROM LIBVOLUMES WHERE STATUS='Scratch' GROUP BY LIBRARY_NAME"
UPDATE SCRIPT CONFERENCIA "/* ----- QUANTIDADE DE FITAS CLEANER ----------*/"
UPDATE SCRIPT CONFERENCIA "SELECT LIBRARY_NAME,COUNT(*) FROM LIBVOLUMES WHERE STATUS='Cleaner' GROUP BY LIBRARY_NAME"
UPDATE SCRIPT CONFERENCIA "/* ----- DRIVES OFF-LINE ----------*/"
UPDATE SCRIPT CONFERENCIA "SELECT LIBRARY_NAME, DRIVE_NAME, ONLINE FROM DRIVES WHERE ONLINE='NO'"
UPDATE SCRIPT CONFERENCIA "/* ----- PATHS OFF-LINE ----------*/"
UPDATE SCRIPT CONFERENCIA "SELECT SOURCE_NAME, DESTINATION_NAME, SOURCE_TYPE, DESTINATION_TYPE, LIBRARY_NAME, NODE_NAME, DEVICE, ONLINE FROM PATHS WHERE
ONLINE='NO'"
UPDATE SCRIPT CONFERENCIA "/* ----- VOLUMES Unavailable ----------*/"
UPDATE SCRIPT CONFERENCIA "q vol access=unavailable"
UPDATE SCRIPT CONFERENCIA "/* ----- VOLUMES ESTADO DE ERRO ----------*/"
UPDATE SCRIPT CONFERENCIA "SELECT VOLUME_NAME, STGPOOL_NAME, ERROR_STATE FROM VOLUMES WHERE ERROR_STATE='YES'"
UPDATE SCRIPT CONFERENCIA "/* ----- FALSO PRIVATE ----------*/"
UPDATE SCRIPT CONFERENCIA "SELECT VOLUME_NAME FROM LIBVOLUMES WHERE STATUS='Private' AND LAST_USE IS NULL AND VOLUME_NAME NOT IN (SELECT VOLUME_NAME FROM VOLUMES )
order BY LIBRARY_NAME"
UPDATE SCRIPT CONFERENCIA "/* ----- SCHEDULES NÃO EXECUTADOS ----------*/"
UPDATE SCRIPT CONFERENCIA "q ev * * begindate=-1 ex=yes"
UPDATE SCRIPT CONFERENCIA "/* ----- SCHEDULES ADMINISTRATIVOS NÃO EXECUTADOS ----------*/"
UPDATE SCRIPT CONFERENCIA "q ev * t=a begindate=-1 ex=yes"


So far so good, the script was created and I can run it successfully, but when I run it, I wish that the comments appear in the script before each command screen, something like this:

run CONFERENCIA
...

/* ----- NOME DA LIBRARY ----------*/
LIBRARY_NAME LIBRARY_TYPE
-------------------------------- -------------
TS3100 SCSI
...

and not like this happening now:

LIBRARY_NAME LIBRARY_TYPE
-------------------------------- -------------
TS3100 SCSI


LIBRARY_NAME Unnamed[2]
-------------------------------- ------------
TS3100 16


LIBRARY_NAME Unnamed[2]
-------------------------------- ------------
TS3100 2
ANR2034E SELECT: No match found using this criteria.
ANR2034E SELECT: No match found using this criteria.
ANR2034E SELECT: No match found using this criteria.


Volume Name Storage Device Estimated Pct Volume
Pool Name Class Name Capacity Util Status
------------------------ ----------- ---------- --------- ----- --------
LTO002L4 STG_OFF_QUA LB_TS3100 1,6 T 12,3 Filling
LTO011L4 STG_OFF_QUI LB_TS3100 1,0 T 0,0 Full
LTO040L4 STG_OFF_SEX LB_TS3100 1,0 T 0,0 Full
ANR2034E SELECT: No match found using this criteria.
ANR2034E SELECT: No match found using this criteria.
ANR2034E QUERY EVENT: No match found using this criteria.
ANR2034E QUERY EVENT: No match found using this criteria.
ANR2034E QUERY EVENT: No match found using this criteria.
ANR2034E QUERY EVENT: No match found using this criteria.
ANR1462I RUN: Command script CONFERENCIA2 completed successfully.



Getting insert these comments between commands, it's easy for anyone to know what is means each response.


Can anyone help me?

 

[Holliefant]

Maybe this could be of help:
http://publib.boulder.ibm.com/tividd/td/ITSML/GC23-4691-01/en_US/HTML/anrlrf51152.htm

 

[CoMaboy]

Alternatively you can use a select on a table with just one record like DB or OPTIONS.

/* select an empty string as something from db */
SELECT '' AS NOME_DA_LIBRARY FROM db
SELECT LIBRARY_NAME, LIBRARY_TYPE FROM libraries

/* select some text as something from db */
SELECT 'Lists the names of all libraries' AS NOME_DA_LIBRARY FROM db
SELECT LIBRARY_NAME, LIBRARY_TYPE FROM libraries

 

[@euevolui]

Hello, thanks guys, you saved my life!


I used the 'ISSUE' command:


UPDATE SCRIPT script_name "ISSUE MESSAGE i '___________'"


The result was just perfect!