#DateForumTypeThreadPost
19808 Jul 2010 @ 09:16 PDTDatabaseReplyHelp Neeed: conditional execution in macroSelect col1, col2 from tab1 where :id = 2; Select col1, col2 from tab2 where :id 2;
19708 Jul 2010 @ 10:09 PDTUDAReplyNumeric Overflow errorOracle does not recognise the same implicit datatype conversion as Teradata. Try: Select Cast(Count(*) As Float) From Tablename; It is ANSI standard, so even Oracle should cope!
19608 Jul 2010 @ 09:37 PDTUDAReplyBT/ETIf everything is going OK, there is no difference. But if they are run in bteq, and there is a restart or deadlock during statement 2 (case 1), statement 1 is rolled back and statement 2 is resubm...
19501 Jul 2010 @ 03:00 PDTDatabaseReplyExpanding the column sizeIt is not a bug. When you define the table (or add a new column) it sets appropriate defaults - Format x(20) in this case for a Char(20) or Varchar(20) column. When you change a tables properties...
19428 Jun 2010 @ 03:32 PDTDatabaseReplyHow to select values based on variable name and primary key using SQLGo for the CASE. Volumes are trivial (if you are not using Teradata Express!) and it is easier to build. Something like: .Export Report file = bldextr.sql .Format Off .Foldlne on all .Width ...
19326 Jun 2010 @ 09:33 PDTDatabaseReplyTransaction Units across Multiple You can wrap BT/ ET around procedure calls as long as the procedures follow the rules. IE you cannot have DDL within a transaction unless the DDL comes immediately before the ET. So if any of the p...
19223 Jun 2010 @ 10:20 PDTDatabaseReplyHow to select values based on variable name and primary key using SQLI would go with CASE first too, but compare it against this plan B (Union) with your volumes: Select Var1 From Table1 Join Table2 On Table2.TrackId = Table1.TrackId And Table2.Attrbute = 'Va...
19123 Jun 2010 @ 04:31 PDTDatabaseReplyDynamic DDL3 hours ago You can run something like this in bteq. .Export Report File=crtab.txt .Format off Select 'Create Table dbname.tblname (Title '') ; Select 'Start_Dt Date Not Null' (Title ''...
19023 Jun 2010 @ 01:02 PDTAnalyticsReplyMAX() and MAX() OVER (PARTITION BY ....) in the same query produces error 3504The query below using derived tables will give you what you asked for, but it is probably not what you want! ------------------------------------------------ Select D1.employee_number, D1.max_dat...
18917 Jun 2010 @ 06:06 PDTToolsReplyUTY2403 An invalid statement was found before the .LOGON statementThere is often a clue in the script you submitted! Check your script had a .Logon, not Logon. Failing this, post your script.
18817 Jun 2010 @ 06:04 PDTToolsReplyTransaction Deadlock issue in BTEQ - Failure 3510 Too many END TRANSACTION statementsWhen you get the deadlock, the transaction is aborted but the session retries - so you are in a new transaction! I would do too things: Before the BT in both sessions, tell Bteq not to retry. Af...
18715 Jun 2010 @ 03:16 PDTDatabaseReplyDB link equivalent in TeradataThere is an Arcmain Copy facility which will copy databases/ tables from one system to another.
18608 Jun 2010 @ 06:44 PDTDatabaseReplyNeed help with Unicode in DDL issueYou can always put it in as a comment.
18508 Jun 2010 @ 02:29 PDTDatabaseReplyteradata sql helpThe two answers do not give the same results; it depends on your definition of overlapping dates. Consider a case where table1 has dates of 2010-03-14 and 2010-04-15; table2 has 2010-03-16 and 201...
18407 Jun 2010 @ 08:17 PDTDatabaseReplyNeed help with Unicode in DDL issueCannot try it on my machine, but try explicitly making the character constant a Unicode constant. By: _Unicode'Česká pošta' AS nazev_cpost
18307 Jun 2010 @ 12:54 PDTDatabaseReplyteradata sql helpTry this: Create Volatile Table Table1 (C1 Char , c2 Char, c3 Date Not Null, c4 Date Not Null, c5 Smallint Not Null) Unique Primary Index (c5) On Commit Preserve Rows ; Create Volat...
18204 Jun 2010 @ 03:01 PDTDatabaseReplyNeed help with Unicode in DDL issueWhat is the issue to be solved? When you created the view, your default character set must have been set to Unicode. When the view was set up, it stored the Ceska Polska as a Unicode string and e...
18104 Jun 2010 @ 02:45 PDTDatabaseReplyre: Help converting SQL Server Loop Query to Teradata!It may exist on your saystem; it did not on mine! I simply set up a table for testing and put a few records in it to test. As for the database/ tablenames, substitute your names accordingly.
18004 Jun 2010 @ 12:12 PDTToolsReplyDo MLOAD affect performanceYes. When you do a lot of work quickly, it affects your performance on other jobs! Mload will run as fast as it can. If it is run at the same priority as other jobs, the resource will be shared be...
17904 Jun 2010 @ 12:06 PDTDatabaseReplyre: Help converting SQL Server Loop Query to Teradata!You need to use a recursive query to determine the hierarchy in your Region_Cd table. The following will work: Create Volatile Table Region_CD (azcac Smallint Not Null, ALocClliCd Char(3) ...
17801 Jun 2010 @ 05:19 PDTToolsReplyFast ExportYou need to put your script in a bat file and run it from there. (I presume the date you want is yyyymmdd!) Try: for /F "tokens=1-3 delims=/ " %i in ('date /t') do set tddt=%k%j%i echo %tdd...
17701 Jun 2010 @ 04:32 PDTDatabaseReplyNumeric processor operand error...1. unitprice is probably zero on one of the records. 2. You have no join condition, so if either of your subqueries returns more than one row, you are going to do a product join. So, something li...
17620 May 2010 @ 03:42 PDTGeneralReplyQuery/SP to find unicode DBC.Columns.Chartype = 2 for unicode, 1 for latin.
17520 May 2010 @ 02:26 PDTDatabaseReplyHelp plz...No more spool space!You need to join your derived table t to tab1 on all the primary key values. (Note Primary KEY not primary index!) So: update DB.tab1 from (SELECT col1, col2, ROW_NUMBER() OVER (PARTITION BY c...
17420 May 2010 @ 02:20 PDTDatabaseReplyError -7423 while selectingIf User1 and User2 do not have the NOWAIT option set, the inserts will run consecutively. First one to send the statement gets in first; the second waits until the other user completes. You cannot...

Pages