#DateForumTypeThreadPost
115330 Nov 2011 @ 03:41 PSTToolsReplyFASTLOAD - Vartext Data - Error. If it's only before the first record it's not a record length. This seems to be a "Byte Order Mark" used for UNICODE files, indicating "UTF16 Little Endian" But y...
115230 Nov 2011 @ 03:21 PSTToolsReplyFastload DateTime, Timestamp You can't load a VarChar representing a Timestamp into a Date column using FastLoad. This would require two typecasts and only one is supported. Of course you could use MLoad or simply t...
115130 Nov 2011 @ 12:00 PSTGeneralReplyStored Procedures - how to handle dynamic result set You simply can't do that in TD12. Dieter
115029 Nov 2011 @ 11:58 PSTPrivate Forum
114929 Nov 2011 @ 11:46 PSTGeneralReplyWelcome to the Teradata Developer Exchange discussion forums! BTEQ doesn't support delimited output. You have to export in report format and concat all columns in your select: select   trim(col1) || '~' ||...
114829 Nov 2011 @ 11:41 PSTToolsReplyFASTLOAD - Vartext Data - Error. How is the flat file created? This might be a binary record length, open the file using a hex-editor and check. Dieter
114729 Nov 2011 @ 11:38 PSTUDAReply20 Padded in Data If you pad a string with 0x0 it will be stored as is, thus the data sent to Teradata seems not to be padded. But why do you want hex 0 as a pad character? Those 0x0 are usually shown by th...
114629 Nov 2011 @ 11:23 PSTDatabaseReplyWhy it is prohibited using the CURRENT_DATE value for a valid time column in a temporal database's VT table? "Remedy: Correct the statement by removing CURRENT_DATE and CURRENT_TIMESTAMP and resubmit the request." Maybe they should rephrase :-) Remedy: Correct the statement by rep...
114528 Nov 2011 @ 01:02 PSTDatabaseReplyParsing Help Statistics Output Hi Biren, of course the technique to extract those float values could be extended to retrieve row counts for partitions (i did something similar for dates once). But his would only be poss...
114428 Nov 2011 @ 09:03 PSTDatabaseReplyHow does Teradata store/retrieve Partition ID? Hi Pat, the table header is stored on each AMP as a special subtable, When you create a new empty table and query dbc.TableSizeV you'll see the same permspace used on each AMP, it's th...
114327 Nov 2011 @ 10:50 PSTDatabaseReplyHow does Teradata store/retrieve Partition ID? Hi Pat, the Hashmap is used to ditribute the rows across AMPs, partitioning simply changes the sort order within in each AMP from "sorted by hash" to "sorted by partition, then ...
114219 Nov 2011 @ 02:24 PSTDatabaseReplyrows unbounded preceding Is the data sorted by amt2? Rephrasing your desired result you need the current difference minus the previous difference, like this: (amt2 - amt1) - coalesce(sum (amt2 - amt1) ...
114119 Nov 2011 @ 01:05 PSTDatabaseReplyMulti-Value compression has increased the table size 25 Bytes of data + 2 Byte record length + 8 Byte ROWID + 2 Presence Bytes + 2 Bytes in the pointer array = 39 Bytes Rows are stored byte-aligned: 40 Bytes. Dieter
114019 Nov 2011 @ 09:45 PSTDatabaseReplyXplain pln ridiculuous Which functionality? I don't have a clue what this view is supposed to return: Cross joins plus a strange outer join... Dieter
113919 Nov 2011 @ 08:27 PSTDatabaseReplyMulti-Value compression has increased the table size According to you table definition the size of an uncompressed record would be 40 byte, so 3,5 billion rows calculate to 140GB. Dieter
113819 Nov 2011 @ 08:21 PSTDatabaseReplyDisableTD13CntStarEnh This seems to be a dbscontrol internal field only, maybe there's no diagnostic for it. You might ask TD support if exists as diagnostic command. Dieter
113719 Nov 2011 @ 08:17 PSTDatabaseReplyHow to disable IDENTITY COLUMN There's no syntax for disabling it. You can only set the value when it's defined using BY DEFAULT. Dieter
113616 Nov 2011 @ 09:39 PSTDatabaseReplyXplain pln ridiculuous There are several product joins with (1=1), which indicate missing join conditions. Additionally query and explain don't match: there are 3 outer joins in explain, but only 1 in your q...
113516 Nov 2011 @ 08:55 PSTDatabaseReplyUsing Length and Modulo within a Declare Cursor For statement There's no LENGTH function in Teradata, it's ODBC syntax. The ODBC driver might translate LENGTH to the correct CHAR_LENGTH in some cases, but not within an SP. Dieter
113404 Nov 2011 @ 06:21 PDTDatabaseReplyNeed teradata material Go to www.info.teradata.com and download individual manuals or the CD containing all manuals. Dieter
113304 Nov 2011 @ 06:18 PDTDatabaseReplyspool vs free cylinder in Ferret show space output A cylinder is used for spool OR temp OR perm OR Journal, but they are not pre-assigned. Whenever a new cylinder is needed it's taken from the FREE cylinders and when it's released it&#...
113204 Nov 2011 @ 05:37 PDTDatabaseReplyStored procedure and its dependency using Data Dictionary tables The system tables don't have that information, the only way to get it is using Teradata's Meta Data Services add-on. Dieter
113104 Nov 2011 @ 05:36 PDTDatabaseReplyHow to modify datatype of a column using alter table command You can't do that change using ALTER TABLE, you need a new table. Dieter
113004 Nov 2011 @ 05:34 PDTToolsReplyTTU - Windows Install - is it at the latest point versions? The install disks are not aöways updated to the latest patch level, you have to check the tools you actually need. Dieter
112904 Nov 2011 @ 05:32 PDTDatabaseReplyTune qry Hard to tell, just some remarks: Why do you use TRIM all the time, is your data quality that bad? It's a large overhead and the optimizer can't use existing stats. What steps (...

Pages