Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 06 Apr 2009 @ 21:49:35 GMT

  <Prev Next>  
Next> Last>>  

Subj:   How to load data after BMC Unload
From:   Anomy Anom

<-- Anonymously Posted: Monday, April 06, 2009 5:27 -->

Teradata mainframe gurus please awake from your slumber.

I am trying to load up a dataset that has been unloaded from DB2 using BMC unload.

The options include



This means that each attribute is comma seperated but also that each comma is also enclosed in hexadecimal '01'.

I expect this is to allow for those attrubutes where a comma is part of the data.

I would be comfortable with plain comma delimited data but not sure how to handle the extra X'01's.

Does anyone have any suggestions? if not would FORMAT EXTERNAL be a preferable unload option?


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