|Oracle® OLAP DML Reference
10g Release 1 (10.1)
Part Number B10339-02
The names of one or more workspace objects, separated by spaces or commas. FULLDSC shows the full definition of each object specified. When you omit this argument, FULLDSC shows the definition of all objects in the current status of the NAME dimension.
The FULLDSC program is an extension to the DESCRIBE command. That is, the object definition that you list with FULLDSC includes the definition components that are listed by the DESCRIBE command, followed by any properties that are assigned to the object. Each property is listed on its own line with the word PROPERTY, the name of the property, and its value.
Normally, the status of NAME is ALL, so FULLDSC with no argument produces a report that includes the definitions of all objects in your current workspace. However, you can use the LIMIT command in combination with FULLDSC to report the definitions of a particular group of objects in your workspace. Use LIMIT first to limit the status of the NAME dimension to the names of the objects whose definitions you want to see. Then execute a FULLDSC command with no arguments to list the definitions.
You can produce paginated output with the FULLDSC command by setting PAGING to
YES before using FULLDSC.
You can use the output from the FULLDSC command to create objects in other workspaces, because each line of the output is a valid statement. For example, you can execute an OUTFILE command to send subsequent output to a file, and then execute the FULLDSC command. You can then access another workspace, and use the INFILE command to read the FULLDSC output. The same object will be created in that workspace.
The output produced by FULLDSC might not exactly reproduce the original PROPERTY commands that created the properties of the object because the original name and value expressions are not saved. In addition, FULLDSC sets the DECIMALS option to 255, which drops trailing zeros. See "Listing the Properties of a Variable".
See Also:Example 24-5, "Describing Triggers"
Example 13-33 Listing the Properties of a Variable
This example produces a report of the full definition of the
actual variable, to which the properties DECPLACE and REPPRG have been added. The statement
produces the following output.
DEFINE ACTUAL VARIABLE DECIMAL <LINE DIVISION MONTH> LD Actual $ Financials PROPERTY 'DECPLACE' 4 PROPERTY 'REPPRG' 'qtrrep'
Suppose the DECPLACE property had been specified with the following statement, where PRPNAME is a variable whose value is DECPLACE.
PROPERTY prpname 4.00
The output from FULLDSC would be the same as that shown in the preceding example; the value 4.00 would be shown as 4. Therefore, when you created an object using the INFILE technique with the FULLDSC output, the newly created property value would have a type of INTEGER (based on the value 4) even though the original property value had a type of DECIMAL (based on the value 4.00). In most cases, this difference is immaterial, because the appropriate conversions are performed when the property values are used.