The DATASTORE command is used to specify the characteristics of source and target datastores. An Engine script may reference only one primarysource such as COLLATION DATASTORE. Typically, a parameter file or may write or "apply" to multiple target datastores.
Note: When using COLLATION as a source, the target CCSID is 1208 (UTF-8). For more information, refer to Aurora PostgreSQL collations for EBCDIC.
Syntax
DATASTORE <file_name>
| file://[<relative_path.> | <full_path.>] <file_name>
| <DD:ddname>[* | (<member_name>)]
| <table_name>
| RDBMS
| cdc://[<host_name_or_address>[:<port_number>]]/<agent_name>/<engine_name>
| cdcs://[<host_name_or_address>[:<port_number>]]/<agent_name>/<engine_name>
| tcp://<hostname>/<tcpip_port>
| mqs://[<qmgr_name>]/<queue_name> [:<correl_id>]
| kafka://[<hostname>[:<port_number>]] / [<kafka_topic_id>][/<partition> | key | root_key]
| hdfs://<hostname>[:<port_number>]/<hdfs_file_name>
OF <DATASTORE_TYPE> AVRO | BINARY | DB2LOAD | DELIMITED | HSSUNLOAD | IMSCDC | IMSDB | JSON | ORACLECDC | RELATIONAL | UTSCDC | VSAM | VSAMCDC | XMLCDC
[CHRDEL(‘<delchr>’)]
[COLDEL(‘<delchr>’)]
[RECDEL(‘<delchr>’)]
[CCSID <code> | ASCII | EBCDIC ] [COLLATION <collation_name>]
[STAGING SIZE <nG>] -- file size in Gigabytes
[STAGING DELAY <mm>] -- rotate every mm minutes
AS <datastore_alias>
DESCRIBED BY <description_alias1> [,<description_alias2>,…, <description_aliasn>] | DUMMY
DESCRIBED BY GROUP <group_name>
Supported CPS Collations in AWS Aurora PostgreSQL
| Specific EBCDIC collations | Micro Focus specific EBCDIC collations | BluAge specific EBCDIC collations |
|---|---|---|
| da-DK-cp1142-x-icu | da-DK-cp1142m-x-icu | da-DK-cp1142b-x-icu |
| da-DK-cp277-x-icu | de-DE-cp1141m-x-icu | da-DK-cp277b-x-icu |
| de-DE-cp1141-x-icu | en-GB-cp1146m-x-icu | de-DE-cp1141b-x-icu |
| de-DE-cp273-x-icu | en-US-cp1140m-x-icu | de-DE-cp273b-x-icu |
| en-GB-cp1146-x-icu | es-ES-cp1145m-x-icu | en-GB-cp1146b-x-icu |
| en-GB-cp285-x-icu | fi-FI-cp1143m-x-icu | en-GB-cp285b-x-icu |
| en-US-cp037-x-icu | fr-FR-cp1147m-x-icu | en-US-cp037b-x-icu |
| en-US-cp1140-x-icu | it-IT-cp1144m-x-icu | en-US-cp1140b-x-icu |
| es-ES-cp1145-x-icu | nl-BE-cp1148m-x-icu | es-ES-cp1145b-x-icu |
| es-ES-cp284-x-icu | es-ES-cp284b-x-icu | |
| fi-FI-cp1143-x-icu | fi-FI-cp1143b-x-icu | |
| fi-FI-cp278-x-icu | fi-FI-cp278b-x-icu | |
| fr-FR-cp1147-x-icu | fr-FR-cp1147b-x-icu | |
| fr-FR-cp297-x-icu | fr-FR-cp297b-x-icu | |
| it-IT-cp1144-x-icu | it-IT-cp1144b-x-icu | |
| it-IT-cp280-x-icu | it-IT-cp280b-x-icu | |
| nl-BE-cp1148-x-icu | nl-BE-cp1148b-x-icu | |
| nl-BE-cp500-x-icu | nl-BE-cp500b-x-icu |