IBM Support

ISCDC Flat File name convention

Question & Answer


Question

What is the flat file name convention when CDC/IIDR is creating flat files for DataStage?

Cause

Understand the file name convention

Answer

Currently CDC/IIDR for DataStage's FlatFile file name format uses date+timestamp combination where:

- The date is the day of the year,
- The timestamp is in UTC format..

It has the following format:

{tablename}_Dyyyyddd_ThhmmssSSS

E.g. STAFF table's flatfile was generated on Oct20, 2010, 09:23:56 562 milliseconds AM in EDT timezone.

The corresponding file name is:

STAFF.D2010293.T132356562

Explanation:
-2010 is current year
-293 means Oct 20th is the 293th day of the year.
-032356562 is the timestamp converted to UTC time

[{"Product":{"code":"SSX3HK","label":"InfoSphere Change Data Capture"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Change Data Capture for DataStage","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"6.5.1;10.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
11 February 2020

UID

swg21689154

Page Feedback