Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Thu, 07 Nov 2002 @ 09:21:35 GMT





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




Subj:   Re: Retrieve data from TPUMP Error table
 
From:   David Wellman



Hi,

Yes you can. Check the TPump Reference Manual, chapter 7 which describes the error table layout. This is 'just a table' so you can write a select statement to retrieve data from it.

Note that the HostData column will be in the data type/format of the client system where it was loaded from. So if you ran Tpump from the mainframe, this data will be in EBCDIC, if you ran it from unix/windows etc it will be in ASCII. This means that you can't (well, it's difficult) run Tpmup from say Unix and then export the data to a mainframe and look at it.


Cheers,

Dave

Ward Analytics Ltd: Information in motion
( www.ward-analytics.com )





     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008