Complex Flat File Stage Datastage Example Programs
HI Ashsish As per my knowldge here is usage Complex flat file useful in complex logic handling from the mainframes Data source stage that extracts data from a flat file containing complex data structures, such as arrays, groups, and redefines Usage is specifically handling Huge data in various kinds of formats of data like eg: EBCDIC/BINARY Variable length of records Data contains Unusual characters Multiformat file handling with external source (Mainframe to db2,cics etc) 5. Key expressions in relational data For Data in Ebcidic/Binary Format its very difficult to view the data and position of field TIA Vasudev Koti From: ascential-l@Groups.ITtoolbox.comTo: vkoti@hotmail.comDate: Thu, 24 Apr 2008 05:23:13 +0000Subject: ascential-l Usage of Complex flat file in data stage Can anyone expain the usage of the complex flat files extarcted from mainframes in data stage. Hi complex flat file is some thing that we get from an IBM/AS400 machine etc in order to use u need to have a cobol copy book which is used to load the meta data. You also need to have a data file for this cobol copy book. All fields from cobol copy book are usually chars for furthe r information read the parallel job developers guide from ascential - Original Message - From: ashishbatra2003 via ascential-l To: balasubrahmanyam85 Sent: Thursday, April 24, 2008 10:53:13 AM Subject: ascential-l Usage of Complex flat file in data stage Can anyone expain the usage of the complex flat files extarcted from mainframes in data stage. I don't understand what is your question exactly but CFF stage is one of the file stage it is used to read the data from a file or write data to a file but you cannot use the same stage instance to do both. As a source, the CFF stage can have multiple output links and a single reject link.
External Target Stage In Datastage
Difference Stage In Datastage
The source data can contain one or more of the following clauses: - GROUP - REDEFINES - OCCURS - OCCURS DEPENDING ON CFF source stages run in parallel mode when they are used to read multiple files. When a CFF stage is defined as a source, you must provide details about the file that the stage will read, create record definitions for the data, define the column metadata, specify record ID constraints, and select output columns.
What Is Datastage
If you are reading data from a file that contains multiple record types, you must create a separate record definition for each type.
Comments are closed.