Accessing Auxiliary Storage: FILE › FILE Capabilities

FILE Capabilities

Use FILE to perform the following functions. Each main function is an option on the Auxiliary Storage Menu.

Note: The functions you perform depend on your security authorization.

• Files (VSAM and BDAM)
  • View, add, update, and delete records
  • Browse a file
  • Search for data
  • Mass insert records into a VSAM file
• DB2 and SQL/DS Databases
  • View a table
  • Update columns in a table
  • Delete rows from a table
  • Insert a row in a table
  • Issue other SQL commands, including CREATE, ALTER, DROP, COMMENT ON, LABEL ON, GRANT, and REVOKE
• DL/I Databases
  • Retrieve segments
  • Add, update, and delete segments
• Transient Data
  • Retrieve a transient data record
  • Add a transient data record
  • an intrapartition data queue
• Temporary Storage
  • View or add a temporary storage record
  • View or add a temporary storage queue record
  • Search a temporary storage queue for data
  • Purge a temporary storage queue

In addition to the previous listed functions, use FILE to perform tasks that would otherwise require specially written programs.

Example

Use FILE to do the following tasks:

• Copy a record from one file to another
• Create test data from production files

FILE performs these tasks because it retains retrieved record and segment data in its own WORK AREA.

The CA InterTest for CICS FILE transaction is comprehensive. It enables you to perform interactively any function that is supported by CICS File Control and DL/I, and most DB2 functions. FILE uses CICS services exclusively; it does not use the operating system's data access methods directly.