Wednesday, July 2, 2008

Platinum commands

S COMMAND COMMAND DESCRIPTION

RC/QUERY TABLE REPORT OPTIONS
_ A - RQTA Table Alias
_ D - RQTD Table Detail
_ L - RQTL Table List
_ P - RQTP Table Plan Inquiry
_ S - RQTS Table Synonym Inquiry
_ I - RQTI Table Index Inquiry
_ C - RQTC Table Column Inquiry
_ V - RQTV Table View Inquiry
_ HL - RQTHL Table History List
_ HD - RQTHD Table Detail History
_ HS - RQTHS Table Stats. History
_ HP - RQTHP Table Partition History
_ O - RQOD Object Dependency
_ UA - RQTUA Table User Authorization Inq
_ PA - RQTPA Table Plan Authorization Inq
_ KA - RQTKA Table Package Authorization Inq
_ PK - RQTPK Table Package Inquiry
_ UC - RQTUCS Table Unique Constraint Inquiry
_ DI - RQTDI Table Drop Impact
_ LR - RQTLR Table Lob Relationships
_ TG - RQTTG Table Trigger

RC/QUERY AVAILABLE REPORT OBJECTS
_ C OPTIONS - Column
_ SY OPTIONS - System
_ RI OPTIONS - Referential Integrity
_ U OPTIONS - User

GENERAL LINE COMMANDS
_ COUNT - Display number of table rows
_ DDL - Create DDL for an object
_ DELETE - Jump to ISQL to delete from a table or view
S COMMAND COMMAND DESCRIPTION
_ DISPLAY - Jump to DB2C to display a DB/TS/IS/UDF or Stored Proc.
_ DISPLKS - Display database/tablespace/indexspace with LOCKS
_ DISPLPL - Display database/tablespace/indexspace with LPL
_ DISPUSE - Display database/tablespace/indexspace with USE
_ FSTART - Start a database and/or tablespace/indexspace
_ FSTOP - Stop a database and/or tablespace/indexspace
_ INSERT - Jump to ISQL to insert into a table or view
_ LGRANT - Grant privileges to users
_ LOAD - Create JCL for LOAD Utility
_ LREVOKE - Revoke privileges from users
_ REFRESH - Refresh Materialized Query Table
_ SELECT - Jump to ISQL to select from a table or view
_ START - Jump to DB2C to start a DB/TS/IS/UDF or Stored Proc.
_ STARO - Jump to DB2C to start a DB/TS/IS in READ ONLY status
_ STAUT - Jump to DB2C to start a DB/TS/IS in UTILITY status
_ STAFO - Jump to DB2C to start a DB/TS/IS with ACCESS FORCE
_ STOP - Jump to DB2C to stop a DB/TS/IS/UDF or Stored Proc.
_ UPDATE - Jump to ISQL to update a table or view
_ UNLOAD - Create JCL for the FAST UNLOAD utility

LICENSED LINE COMMANDS
_ ALTER - Jump to RC/Update to alter an object
_ BROWSE - Jump to RC/Update to browse a table
_ COPYD - Jump to RC/Update to copy a table
_ COPYAUTH - Jump to RC/Secure to copy authorizations
_ CREATE - Jump to RC/Update to create an object
_ DROP - Jump to RC/Update to drop an object
_ EDIT - Jump to RC/Update to edit a table
_ FBROWSE - Jump to RC/Update to browse a table
_ FEDIT - Jump to RC/Update to edit a table
_ GRANT - Jump to RC/Secure for GRANT services
_ QMIGRATE - Jump to RC/Migrator to perform Quick Migrations
_ REVOKE - Jump to RC/Secure for REVOKE services
_ TEMPLATE - Jump to RC/Update to template an object
_ LISTCAT - IDCAMS Listcat of tablespace/indexspace
_ EX - Execute Clist or REXX Exec
_ TESTEX1 - SAMPLE REXX EXEC
******************************* BOTTOM OF DATA ************




S COMMAND COMMAND DESCRIPTION

RC/QUERY SYNONYM REPORT OPTIONS
_ L - RQSL Synonym List
_ T - RQST Synonym Table Inquiry
_ V - RQSV Synonym View Inquiry
_ P - RQSP Synonym Plan Inquiry
_ PK - RQSPK Synonym Package Inquiry
_ DI - RQSDI Synonym Drop Impact

RC/QUERY AVAILABLE REPORT OBJECTS
_ T OPTIONS - Table
_ C OPTIONS - Column
_ SY OPTIONS - System
_ RI OPTIONS - Referential Integrity
_ U OPTIONS - User

1 comment:

PaPa said...

If you've created a list of say plans from your catalog and you want to create the bind parms for all of them, you can put a lbind cmd on the first line and an equal sign on each of the additional lines that you want the bind parms for, is there a way to process a block of them like in ISPF put an RR on the first and RR on the last line you want to repeat? Puting a "==" on the first and last doesn't do it.