In order to load XML requests from flat sequential files, comma separated value (CSV) files and from database tables, you need to create a staging control record. The name of this table is CI_XML_STG_CTL. The following table describes each column on this table.
| Column Name | Length | Req'd | Data Type | Comments |
|---|---|---|---|---|
| XML_STG_CTL_ID | 10 | Y | N | This is the unique identifier of the record. This value does NOT have to be a random number, but it does need to be unique. If your process that inserts records on this table is capable of calling a COBOL routine, call CIPCKEYG and it will supply a 12 digit random number for you. |
| RUN_DTTM | 26 | N | Date/Time | Date and time this record was executed. |
| XAI_IN_SVC_ID | 10 | Y | A/N | This is the XAI service associated with this record. This service should have an adapter of CISStagingUpload. |
| XML_STG_FILE_NAME | 250 | N | A/N | This is the location and name of the file containing the data to be uploaded. This is used for comma delimited files and flat sequential files. |
| XML_INTFC_NAME | 30 | N | A/N | The name of the interface used to populate this table. This is simply information and is not used by the system. |
| XML_STG_STATUS_FLG | 2 | Y | A/N | Must be set to P (Pending). |
| NT_XID_CD | 30 | N | A/N | This field is not in use. |
| NT_UP_XTYPE_CD | 30 | N | A/N | This field is not in use. |
| USER_ID | 8 | Y | A/N | The ID of the user who created this record. |
| COMMENTS | 254 | N | A/N | Use the free format comments, if necessary. |
| NBR_RECORD_UPLD | 10 | N | A/N | Leave this blank. This will be populated by the process which creates upload staging records for this control record. |
Copyright © 2000, 2015, Oracle and/or its affiliates. All rights reserved. Documentation build: 2.19.2015 16:18:51 [F1_1424305131000]