Kourier Integrator Online Help
KT.SERVICE2SQLTABLE SERVICE_ID
This command is used to create a SQL DDL script that will create the SQL tables based upon the exports referenced in the service. It creates a script called create_tables.sql and writes it to the KT_IOTEMP file. Open this file in Microsoft SQL Enterprise Manager and run it to create the SQL tables.
This command is normally used as part of the process of moving multi-valued data to Microsoft SQL Server.
|
SERVICE_ID |
The name of the service to process. |
>>KT.SERVICE2SQLTABLE ODS_AR-INVOICE
Script "create_tables.sql" written to KT_IOTEMP.
In this example, the service ODS_AR-INVOICE is processed and the script is written to the KT_IOTEMP file. A parent export is created (ODS_AR-INVOICE) and several child exports (i.e. ODS_AR-INVOICE_F1, ODS_AR-INVOICE_F5, etc.).
>GET-LIST SERVICES
2 record(s) selected to SELECT list #0.
>>KT.SERVICE2SQLTABLE
Script "create_tables.sql" written to KT_IOTEMP.
In this example, an active select list of services was processed and the script was written to the KT_IOTEMP file.