#DateForumTypeThreadPost
29804 Apr 2014 @ 02:42 PDTDatabaseReplyHelp needed in Bteq ExportWhen you export data, you dont have a delimiter unless you export one as part of the query. When you say it does not work, what is happening; what error is reported from bteq. A couple of likely ...
29704 Apr 2014 @ 05:36 PDTDatabaseReplyHelp needed in Bteq ExportIts a problem with BTEQ - when you export report, any trailing space on a line is truncated - it does not show up on the paper! You need to change to export data. The separator, titles/ titledashe...
29603 Apr 2014 @ 07:39 PDTDatabaseReplyHelp needed in Bteq ExportWhen you multiply the inc-amt by 100 to get the pence, you are multiplying a decimal field with two decimal places by an integer, so the answer is still a decimal with two decimal places. You need...
29524 Feb 2012 @ 04:22 PSTDatabaseReplyWhy is a missing zero in the date's month a format problem in Teradata See http://forums.teradata.com/forum/enterprise/format-mdyy-column-as-ddmmyyyy#comment-8460
29414 Feb 2012 @ 11:31 PSTDatabaseReplyReturning to setting variables. snippet from previous discussion does not work on current teradata platform.     Create volatile Table TEMP As ( Select '1060401' (int) startdate, '1060431' (int) enddate ) ...
29306 Jan 2012 @ 03:45 PSTDatabaseReplyTpump Del Issue If you want to use row level locking, you will have to create a file of the primary keys of the records to be deleted and import that file into TPUMP. The delete will then be .DML DelRecs; ...
29229 Nov 2011 @ 03:57 PSTGeneralReplyHow to get entire database DDL structure in TeraData See http://forums.teradata.com/forum/tools/bteq-export-issue
29122 Nov 2011 @ 04:19 PSTToolsReplyLoading into Views using TPT   Steve Normally I would never question your word, but Multiload manual (V13 I am looking at) specifically says you can use Multiload into updatable views (generally single table vi...
29017 Nov 2011 @ 02:29 PSTDatabaseReplyROW LEVEL COMMITS IN TERADATA Not quite. You need two set of views - one for loading, another for user access. You have a user view pointing to T3 in your scenario and you run the upsert into T2 via the load view. ...
28917 Nov 2011 @ 01:59 PSTDatabaseReplyNumeric sizing when using aggregation I am with your developers - you always remember to do this after the query has failed and it is not always obvious how to recast the correct number in front-end query tools. Your Teradata Sa...
28817 Nov 2011 @ 01:54 PSTDatabaseReplyROW LEVEL COMMITS IN TERADATA If your bteq job does any sort of table-to-table copy (Insert/ Update/ Delete/ Upsert) then your target is locked for the duration of the copy. Access Locking will allow other to read the table ...
28715 Nov 2011 @ 11:49 PSTDatabaseReplyROW LEVEL COMMITS IN TERADATA If the data is loaded into a load table and updated to then copied inot your base table using bteq, then the base table will be locked for writing during the upsert operation and all the updates...
28607 Nov 2011 @ 12:59 PSTDatabaseReplyTruncation of Data while Bteq Export And you used the .WIDTH command to set the width of the report of course. If you did, post the script.  
28520 Oct 2011 @ 03:46 PDTToolsReplyLoading a table with BTEQ script using csv file having numeric field with thousand seperator. The Teradata load utilities dont recognise Microsoft's convention that anything within double quotes should be ignored when evaluating control type characters. (TPT may be different; I have ...
28420 Oct 2011 @ 07:22 PDTToolsReplyLoading a table with BTEQ script using csv file having numeric field with thousand seperator. If you save the Excel file as tab-delimited text, it should avoid the quotes. You can then specify the format in Fastload as 'zzz,zzz,zzz,zz9' to get it to accept tthe commas.
28320 Sep 2011 @ 04:51 PDTDatabaseReplyDate division - why? A date field is held as an integer internally, formatted as yyymmdd (yyy is years since 1900, so start of this year is 1110101). Divide by 100 removes the days, so your code get rid of Custo...
28206 Sep 2011 @ 11:54 PDTGeneralReplyORACLE TO TERADATA MIGRATION Put the keyword in double quotes. So:   CREATE TABLE xyz (       CSTMR_ID           ...
28130 Aug 2011 @ 02:22 PDTUDAReplyHow to remove non-numeric characters from a string? (Oracle TRANSLATE Equivlent function?)Get your DBA's to download and install the Oracle UDFs for Teradata ( http://downloads.teradata.com/download/extensibility/teradata-udfs-for-popular-oracle-functions ) Then you can use the otrans...
28018 Jul 2011 @ 01:30 PDTUDAReplyNumeric Overflow While SumYou are still adding it up as an integer and then casting the sum.You need to cast the individual values and the add them up. So: Sel sum(Cast(Col1 as decimal(38,0))) from tab1 group by col...
27914 Jul 2011 @ 02:36 PDTDatabaseReplyHow do I delete a comma at the end of a string?If the name field is a varchar, then: Select Trim(Trailing ',' From Namestr) From Table ; If it is not a varchar (ie it is char), then cast it as a varchar. So: Select PK,Trim(Trailing...
27806 Jul 2011 @ 05:24 PDTUDAReply TIMESTAMP in TeraDATAThe following code demonstrates answers to your problems: Create Volatile Table T1( PK Smallint Not Null, Update_DTS TimeStamp(0) Not Null) Unique Primary Index (PK) On Commit Preserve Rows;...
27701 Jul 2011 @ 03:26 PDTGeneralReplysource as table in utilities?Why on earth would you want to! You would have to export the data to a flat file. If you really need to, export tableA as IndicData. TPT can do it directly, but it is still mich faster to do a ...
27601 Jul 2011 @ 03:22 PDTDatabaseReplySQL help in summing only selected records based on max value within groupSelect D1.MMonth As Month, D1.Tran_Code, Sum(T1.Qty) As Qty From (Select Tran_Code, Max(Month) as MMonth From Table Group By 1) As D1 Join Table T1 On D1.Tran_Code = T1.Tran_Code And D1.MMo...
27501 Jul 2011 @ 08:09 PDTDatabaseReplyWhat will occur when a row level lock is requested in a macro and the Optimizer determines a table level lock is required? You can always request a row hash lock by putting "LOCKING ROW FOR ....". It will only be used if the SQL in the macro specifies the PI columns - ie you are updating some set of rows which have a ...
27401 Jul 2011 @ 04:25 PDTDatabaseReplySome Problem with Bteq !!!! It sounds like you have a Begin Transaction without a corresponding End Transaction. Post the script output.

Pages