Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 13 Jul 2004 @ 18:52:51 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Representing Nulls in Bteq Export on MVS
From:   Dempsey, Mike

That facility is available in SQL Assistant (Queryman) but you would have to execute the statement on a Windows PC then move the file to MVS if that's where you need the data.

(The data would be in character representation - not internal numeric format. You would however be able to specify the field delimiter and use of quotes.)

Mike Dempsey
Teradata Client Tools

If not BTEQ is this facility available in MLOAD? i.e. replacing nulls with a predefined value. (Do you mean FastExport?)

  <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