IBM Support

How to import records from flat file to YFS_Export table

Question & Answer


Question

How to import records from flat file to YFS_Export table

Answer


Solution:
To import the records from any flat file to "yfs_export" table, following need to be performed

1) A custom service needs to be created to read the xml data from the flat file (an xsl component can be used for the purpose)
2) In the service, createExportDataEx api can be used to insert the data into YFS_export table.

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

HTG2532

Document Information

Modified date:
16 June 2018

UID

swg21562493