![]() |
|
![]() |
![]() |
Archives of the TeradataForumMessage Posted: Fri, 15 Jul 2011 @ 10:14:33 GMT
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)
| ||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
![]() | ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||