CA RC/Query offers the possibility to to define user-defined line commands. These are line commands that you create.User-defined line commands are instrumental when you want to achieve a certain focus for a report. For example, you can view information about an indexed column's DB2 catalog information. Or, you can view space usage information from IDCAMS. You can access the DB2 catalog and IDCAMS information by creating user-defined line commands.
What could be a possible reason of error message
RQ078E - COMMAND REQUESTED IS NOT VALID FOR SELECTED OBJECT
when executing a user defined line command?
Sample of an active user defined command amed TESTEX1 and TESTEX2
USMLINE1 'ARZ USER-DEFINED LINE COMMANDS'
'IDCAMS Listcat of tablespace/indexspace'
USMLINE2 FLDSTAT,(C,T), *
'Most frequent index column values'
USMLINE2 EX,(T,V,C,S,U,P,I,A,VC,SG,DB,TS,BP,DR,CL,PK,DT,R,RI, *
'Execute Clist or REXX Exec '
USMLINE2 TESTEX1,(T,V,C,S,U,P,I,A,VC,DT), *
'SAMPLE REXX EXEC ',TYPE=R
USMLINE2 TESTEX2,(TS), *
'SAMPLE REXX EXEC TS ',TYPE=R
Please note that in the above sample the first 5 characters of the user defined command TESTEX1 and TESTEX2 are the same. This is not allowed. The initial five character for the user defined line command should not the same.