|
|
Archives of the TeradataForum
Message Posted: Mon, 05 Apr 2010 @ 19:49:35 GMT
Subj: | | Re: Loading VSAM files using MLOAD |
|
From: | | Geoffrey Rommel |
| File is in binary format. | |
Yep, sure is. Every file is in binary. :-)
But seriously, folks, Mload will not read VSAM files directly, but you can write an INMOD to read the file and send each record to MultiLoad.
The files you want to read are very likely Indexed Sequential, so they can be read sequentially just like flat files. There is a white paper
describing how to use Cobol to write INMODs:
www.teradataforum.com/l030315a.htm
| Files have decimals with various compressiosns (COMP, COMP-3 etc) and character strings. | |
COMP is short for 'computational', not 'compression'. COMP fields are integers, COMP-3 are decimal. MultiLoad on z/OS will read all common
mainframe data types, so you probably won't have to change the records at all -- just pass them to MultiLoad and define the input fields as you
would for a flat file.
| |