#DateForumTypeThreadPost
1208 May 2012 @ 08:10 PDTToolsReplyDate conversion Oops. Forgot to explain that third approach—it simply uses brute force to make the year four digits before doing the cast.
1108 May 2012 @ 08:08 PDTToolsReplyDate conversion I have two solutions for you, but first a word as to what's going on. Teradata has to make assumptions in character string dates with two-digit years: is 19xx or 20xx meant? We provide a DBS...
1031 Jan 2012 @ 05:08 PSTAnalyticsReplyProblems with Hebrew display on TeraData-based SSAS cubes If all of your character data is Hebrew, then you might try using Session Character Set HEBREW1255_5A0 in the Connection Manager of the Data Source. If that doesn't work, then I think you ne...
930 Dec 2011 @ 02:25 PSTDatabaseReplyError in Merge: Syntax error, expected something like '(' between the 'USING' keyword and the word 'Database_2'.'. Looks OK to me. A suggestion: since your database names don't need the quotation marks (LOW LINE is valid in names without the quotes), try the query without them. If it works, then you have...
829 Dec 2011 @ 09:21 PSTUDAReplyI want to copy structure of a SET table to a New table as MULTISET. Is there any way we can do this? Sure. Simply use: CREATE MULTISET TABLE <new-multiset-table> AS <existing-set-table>; If the existing table has any UNIQUE indexes (or other UNIQUE constraints), you'l...
708 Mar 2011 @ 05:22 PSTToolsReplyHow to capture the rejected rows from BTEQ.IMPORTQ: Is there anyway to capture those rejected rows and write into another file ? A: No, sorry, not with BTEQ. If you have to capture the rejected rows, you'll have to use one of the load utilitie...
615 Jan 2011 @ 02:49 PSTToolsReplyfload script not working.Not directly on topic, but just to be sure you don't run into surprises later... I notice that you're creating a MULTISET table. I'm not sure whether or not you expect duplicate rows. You should...
515 Jan 2011 @ 02:42 PSTToolsReplyMultiload error"ERROR TABLES" should be "ERRORTABLES" (that is, one word, not two).
429 Dec 2010 @ 11:28 PSTToolsReplyDate Formating in Multiload ScriptDieter is correct. I suspect that the confusion arises because we normally think of FORMAT as specifying the output formatting. In this case, it is specifying a pattern to match the incoming data a...
316 Dec 2010 @ 08:53 PSTToolsReplyFailing loads in TpumpFirst, for MULTISET tables, MARK/IGNORE DUPLICATE ROWS has no effect (since duplicate rows are permissible in MULTISET tables). For SET tables, IGNORE DUPLICATE ROWS tells TPump to continue with...
216 Dec 2010 @ 08:41 PSTDatabaseReplyCLOB and FastExportCurrently, the FastExport protocol does not support LOB columns (the workaround given for 5674 applies to other protocols). There are a number of reasons for this which I won't go into. I can offer...
116 Dec 2010 @ 08:10 PSTDatabaseReplyTPump DML LabelThe short answer: if you're doing only INSERTs, you needn't worry about IGNORE MISSING/EXTRA ROWS, which only apply to UPDATEs and DELETEs. The long answer: TPump (and the TPT Stream Operator...