Skip to content

/AWS1/CL_DMGPOSTGRESQLDATAPV00

Provides information that defines a PostgreSQL data provider.

CONSTRUCTOR

IMPORTING

Optional arguments:

iv_servername TYPE /AWS1/DMGSTRING /AWS1/DMGSTRING

The name of the PostgreSQL server.

iv_port TYPE /AWS1/DMGINTEGEROPTIONAL /AWS1/DMGINTEGEROPTIONAL

The port value for the PostgreSQL data provider.

iv_databasename TYPE /AWS1/DMGSTRING /AWS1/DMGSTRING

The database name on the PostgreSQL data provider.

iv_sslmode TYPE /AWS1/DMGDMSSSLMODEVALUE /AWS1/DMGDMSSSLMODEVALUE

The SSL mode used to connect to the PostgreSQL data provider. The default value is none.

iv_certificatearn TYPE /AWS1/DMGSTRING /AWS1/DMGSTRING

The Amazon Resource Name (ARN) of the certificate used for SSL connection.

iv_s3path TYPE /AWS1/DMGSTRING /AWS1/DMGSTRING

The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.

iv_s3accessrolearn TYPE /AWS1/DMGSTRING /AWS1/DMGSTRING

The ARN for the role the application uses to access its Amazon S3 bucket.


Queryable Attributes

ServerName

The name of the PostgreSQL server.

Accessible with the following methods

Method Description
GET_SERVERNAME() Getter for SERVERNAME, with configurable default
ASK_SERVERNAME() Getter for SERVERNAME w/ exceptions if field has no value
HAS_SERVERNAME() Determine if SERVERNAME has a value

Port

The port value for the PostgreSQL data provider.

Accessible with the following methods

Method Description
GET_PORT() Getter for PORT, with configurable default
ASK_PORT() Getter for PORT w/ exceptions if field has no value
HAS_PORT() Determine if PORT has a value

DatabaseName

The database name on the PostgreSQL data provider.

Accessible with the following methods

Method Description
GET_DATABASENAME() Getter for DATABASENAME, with configurable default
ASK_DATABASENAME() Getter for DATABASENAME w/ exceptions if field has no value
HAS_DATABASENAME() Determine if DATABASENAME has a value

SslMode

The SSL mode used to connect to the PostgreSQL data provider. The default value is none.

Accessible with the following methods

Method Description
GET_SSLMODE() Getter for SSLMODE, with configurable default
ASK_SSLMODE() Getter for SSLMODE w/ exceptions if field has no value
HAS_SSLMODE() Determine if SSLMODE has a value

CertificateArn

The Amazon Resource Name (ARN) of the certificate used for SSL connection.

Accessible with the following methods

Method Description
GET_CERTIFICATEARN() Getter for CERTIFICATEARN, with configurable default
ASK_CERTIFICATEARN() Getter for CERTIFICATEARN w/ exceptions if field has no valu
HAS_CERTIFICATEARN() Determine if CERTIFICATEARN has a value

S3Path

The path for the Amazon S3 bucket that the application uses for accessing the user-defined schema.

Accessible with the following methods

Method Description
GET_S3PATH() Getter for S3PATH, with configurable default
ASK_S3PATH() Getter for S3PATH w/ exceptions if field has no value
HAS_S3PATH() Determine if S3PATH has a value

S3AccessRoleArn

The ARN for the role the application uses to access its Amazon S3 bucket.

Accessible with the following methods

Method Description
GET_S3ACCESSROLEARN() Getter for S3ACCESSROLEARN, with configurable default
ASK_S3ACCESSROLEARN() Getter for S3ACCESSROLEARN w/ exceptions if field has no val
HAS_S3ACCESSROLEARN() Determine if S3ACCESSROLEARN has a value