Updated on 2023-04-03 GMT+08:00

Netezza Configuration

Netezza parameters are used to customize rules for Netezza script migration.

Open the features-netezza.properties file in the config folder and set parameters in Table 1 as required.

Table 1 Parameters in the features-netezza.properties file

Parameter

Description

Value Range

Default Value

Example

  • rowstoreToColumnstore

Whether to convert row-store tables to column-store tables.

  • true
  • false

false

rowstoreToColumnstore=false

  • cstore_blob

The options are as follows:

  • bytea
  • none
  • bytea
  • none

bytea

cstore_blob=bytea

  • keywords_addressed_using_as

The options are as follows:

  • OWNER
  • ATTRIBUTE
  • SOURCE
  • FREEZE
  • OWNER
  • ATTRIBUTE
  • SOURCE
  • FREEZE

OWNER

keywords_addressed_using_as=OWNER

  • keywords_addressed_using_doublequote

Possible values of addressed_using_doublequote

FREEZE

FREEZE

keywords_addressed_using_doublequote=FREEZE