D File Types and Data Types

The Data Augmentation Scripts application supports these documented file types and data types.

Review these file types and data types that Data Augmentation Scripts supports.

File Types

You can create files in their respective folders for different purposes. You can create these types of files:
  • .param: The .param file (Parameter defiition file). contains one or more parameter definitions. Data Augmentation Scripts creates this file in the Parameter folder under the project root directory.

    For details on parameter definitions, see PARAMETER.

  • .mod: This is a read-only file. The .mod file contains the Data Augmentation Scripts application definition. Data Augmentation Scripts creates this file in the Source folder under the project root directory.
    Syntax
    module_definition ::= MODULE module_name
SOURCETYPE source_type
NAMESPACE namespace
PREFIX prefix
    Example of a main.mod file:
    MODULE TIME
SOURCETYPE FUSION
NAMESPACE TIME_
PREFIX DW_FA_X_
  • .hrf: The .hrf file contains the Data Augmentation Scripts program. The application creates this file is in the Source folder under the project root directory.
    Example of customers_d.hrf file:
    IMPORT SOURCE CUSTOMERS
DEFINE DATASET CUSTOMERS_D
  ROWSOURCE CUSTOMERS;
  THIS = CUSTOMERS;
END
  • .func : The .func file consists of user-defined function definitions. Data Augmentation Scripts creates this file in the Function folder under the project root directory.

    For more details, see User Defined Functions (UDFs) or Macros.

  • .qry: Use the .qry file to create a view using the query that's written in the file. Data Augmentation Scripts creates this file in the Query folder under the project root directory.

    For more details, see Query Files.

  • .conf: To improve the performance of reporting queries in the database, you can specify constructs such as indexes, column groups, and partitions in this file. Data Augmentation Scripts creates this file in the Conf folder under the project root directory.

    For more details, see Column Groups, Indexes, and Partitions.

Data Types

The Data Augmentation Scripts application functionality supports these data types:

Table D-1 Data Augmentation Scripts Supported Data Types

Data Type Declaration Value Example
NUMBER(precision, scale optional)optional

NUMBER

NUMBER (28,2)

3

28

-28
LARGEINT LARGEINT

5000

75000
BIGDECIMAL( precision, scale) BIGDECIMAL(28,2)

3.14

1.00

DATE 'yyyy-MM-dd'

or

DATE "yyyy-MM-dd"

DATE '1843-03-02'

or

DATE "1843-03-02"

‘1843-03-02'

"1843-03-02"

TIMESTAMP'yyyy-MM-dd HH:mm:ss.SSSS'

or

TIMESTAMP "yyyy-MM-dd HH:mm:ss.SSSS"

TIMESTAMP '1843-03-02 04:28:59'

or

TIMESTAMP "1843-03-02 04:28:59"

‘1843-03-02 04:28:59'

"1843-03-02 04:28:59"
VARCHAR2(unsigned_integer) VARCHAR2(38)

"Hello"

"Hello World”

‘Hello World’

“Hello World 101”