DSXchange

Hi All,
My input data is present in Mainframe Flat files.So, I would like to know , is there a way to access Mainframe Flat Files in a Parallel Job .I chanced upon 'Complex Flat File Stage' in Designer.Is that the stage i should look into? If not, how do one normally access data from MainFrame Flat File?

Your Inputs and Suggestions would be highly appreciated.

Thanks in advance,
Raja R P

Yes, that is precisely what the CFF stage is for.

You can easily use the sequential file stage too...

Set the NLS (IBM01142 or check with the mainframe admin)
Set the format (fixed length, binary, Packed decimal)

Mainframe Admin? Who's that?

I know! Just didn't know what else to call it...

I have not used the CFF stage before but now may have an opportunity to. Suppose DataStage is on UNIX, must you first FTP the flat file off the mainframe or how do most people make that communication happen--does the stage fetch the file or assume it's local? Is there a way to map a UNIX file system to the mainframe, something like Samba for mapping Windows drives to UNIX? Thanks in advance. This may be the one new thing I learn today.