Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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


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.



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

  <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