Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 24 Oct 2001 @ 13:38:48 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Reading MVS Pack fields in a mutliload
From:   Catherine Thompson

I have used this scenerio.

Create Table - define column as Decimal(x) ( no second parameter)
Define         Define the incoming field as Char(x)
Insert         Use Format on the insert  '9(x)s'.

I take no credit - straight from Brian Marshalls book on how to handle conversions for signed fields. page 95 application and archive recovery utilities.

Works for me every time in the MVS environment.

Catherine Thompson-Britt

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