BPSIA prints the schema SIA report or the subschema SSIA report in the form of a table.
The SIA report may be of assistance to the user, for instance:
when storing records in the database using BINILOAD,
when printing out certain tables using BSTATUS, or
when printing out the contents of the database using BPRECORD.
The SSIA report, by contrast, is intended more as an aid for the programmers of DB applications.
BPSIA can be used to print the following:
the user schema and the user subschemata
the compiler schema and the compiler subschema
the PRIVACY-AND-IQF schema and the PRIVACY-AND-IQF subschema
In order to print a schema or subschema, BPSIA selects the appropriate Schema Information Area (SIA) or Subschema Information Area (SSIA) from the DBDIR and lists them in the form of tables.
A printout of the user SIA or a user SSIA in the same form can also be obtained by entering a DISPLAY statement at the time of SIA/SSIA generation with the BGSIA utility routine, or with the BGSSIA utility routine, respectively.
In addition to outputting the data to SYSLST, you can also output it to a file in CSV format. The use of CSV format facilitates the further processing of the data in other system environments (e.g. in spreadsheet applications). The output in CSV format is described in the manual “Database Operation“, section “Outputting database information in a neutral format“.