Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 27 Dec 2002 @ 20:27:31 GMT

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

Subj:   Re: Inmod and Mload VARTEXT
From:   Rodrigo Cifuentes

How are you formatting the data? VARCHAR must have a VLI before contents.

Input format to Inmod routine is not necessarily related to input format to MLOAD. Inmods can change the format from anything to something readable by MLOAD. Your inmod can read a line, separate fields -in your example you can easily identify fields in your inmod, by detecting '|'s- and format them as needed by MLOAD. So, you can read variable length text and add VLIs, or just pass fieds as fixed length, adding spaces in the process.

Good luck!

  <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