Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 05 Apr 2010 @ 19:49:35 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

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:


  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.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023