Open topic with navigation

Kourier Integrator Online Help

KT.SCHEMA2EXPORT

Syntax

KT.SCHEMA2EXPORT INTEGRATION_ID FILE_NAME {OVERWRITING} {SQL-COL-DICTID}

Description

This command is used to create Kourier exports from the information stored the KT_SCHEMA file. An export will be created for all single-valued fields (the parent export), all multi-valued fields and all associated multi-valued fields (the child exports).  This command also creates a Kourier service that can be used to run all the exports.

This command is normally used as part of the process of moving multi-valued data to Microsoft SQL Server. 

Options

INTEGRATION_ID

The name of the integration associated with these exports/services.

FILE_NAME

The name of the file to process.

OVERWRITING

Overwrites existing records in the KT_EXPORTS and KT_SERVICES file.  If this command line option is not used and information exists for a file a prompt is displayed before overwriting the existing data.

SQL-COL-DICTID

If the keyword is specified, the dictionary ID will be used as the export column heading instead of the dictionary column heading.  The export column heading will become the SQL column name if you build SQL DDL from the export.

Examples

ClosedExample 1

>KT.SCHEMA2EXPORT ODS AR-INVOICE


AR-INVOICE
Created export ODS_AR-INVOICE
Created export ODS_AR-INVOICE_F1
Created export ODS_AR-INVOICE_F5
Created export ODS_AR-INVOICE_63
Created export ODS_AR-INVOICE_F83
Created export ODS_AR-INVOICE_122
Created export ODS_AR-INVOICE_148
Created export ODS_AR-INVOICE_LI_INFO1
8 exports created in 0.291 seconds.

In this example, the file AR-INVOICE is processed and a parent export is created (ODS_AR-INVOICE) and several child exports (i.e. ODS_AR-INVOICE_F1, ODS_AR-INVOICE_F5, etc.).  

ClosedExample 2 
>KT.SCHEMA2EXPORT ODS AR-INVOICE

Overwrite all AR-INVOICE exports/service for integration ODS (Y,N=<CR>,A): Y
AR-INVOICE
Created export ODS_AR-INVOICE
Created export ODS_AR-INVOICE_F1
Created export ODS_AR-INVOICE_F5
Created export ODS_AR-INVOICE_63
Created export ODS_AR-INVOICE_F83
Created export ODS_AR-INVOICE_122
Created export ODS_AR-INVOICE_148
Created export ODS_AR-INVOICE_LI_INFO1
Created service ODS_AR-INVOICE
8 exports created in 0.310 seconds.

In this example, the file AR-INVOICE is processed.  Since information had been previously written to the KT_EXPORTS file about the AR-INVOICE file the command prompts for the overwrite option.  Valid answers are Y for yes, N for no, or A for yes to all. 

ClosedExample 3 
>GET-LIST FILES
2 record(s) selected to SELECT list #0.
>>KT.SCHEMA2EXPORT ODS
AR-INVOICE
Created export ODS_AR-INVOICE
Created export ODS_AR-INVOICE_F1
Created export ODS_AR-INVOICE_F5
Created export ODS_AR-INVOICE_63
Created export ODS_AR-INVOICE_F83
Created export ODS_AR-INVOICE_122
Created export ODS_AR-INVOICE_148
Created export ODS_AR-INVOICE_LI_INFO1
Created service ODS_AR-INVOICE
8 exports created in 0.501 seconds.
ARLI
Created export ODS_ARLI
Created export ODS_ARLI_F12
Created export ODS_ARLI_F21
Created export ODS_ARLI_F41
Created export ODS_ARLI_LI_INFO1
Created export ODS_ARLI_LI_INFO2
Created service ODS_ARLI
6 exports created in 0.430 seconds.

In this example, an active select list of files was processed and exports and services were created for each file. 

Related Topics: 

Kourier TCL Commands Overview