Write file with EBCDIC format

prasad v · Post by **prasad v** » Thu Mar 17, 2011 10:21 am

Hi

I need to write a flat file with EBCDIC format. Can any body tell me how to do this?

AGStafford · Post by **AGStafford** » Thu Mar 17, 2011 11:36 am

Have you looked into the Complex Flat File stage?

FranklinE · Post by **FranklinE** » Thu Mar 17, 2011 11:52 am

In your file stage, the link properties Format tab (whether Input or Output): clear all attributes, right click on "Record level", open the "Format as" sub-menu and click on "Mainframe (COBOL)". The common default format properties for an EBCDIC flat file will be filled in. If your file is not intended for immediate transfer to a mainframe platform, you might have to adjust some of the attibutes. Record type=implicit means there is no end-of-line character provided or expected. If the next process to read the file is DataStage, all you have to do is use the default properties shown above.

Rule-of-thumb: A mainframe "flat" file is continuous data. Formatting is carried in a catalog which acts similarly to schema settings for DS datasets. Your table definition is your control point for the data.