Archives of the TeradataForum

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

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

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).

Cheers,

Dave

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

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