Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 15 Jul 2011 @ 10:14:33 GMT

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

Subj:   Re: What is dataparcel?
From:   DWellman

Hi Sukul,

I think that what you're seeing here is SQL Assistant's interpretation of a fairly large column.

One of the options within SQLA is a minimum size of column that should be treated as a LOB (Large Object). SQLA saves LOBs as files on your pc. The answer set grid then contains a 'hyperlink' that when clicked will open the data file.

From this and earlier emails, I'm guessing that you're trying to read the Fastload error tables. One of the columns in the error table is (if I'm correct) called DataParcel. This is where SQLA gets this name from.

The actual data in this column is BYTE data which I think you'll find gets returned/written to the data file as a string of byte values, i.e. "ABC" would get written out as "414243" (or maybe "656667" - the decimal equivalents).



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

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