396 | 05 Jun 2009 @ 12:43 PDT | Connectivity | Reply | odbc/ sql server linked server connection problem | Does the ODBC driver work outside of SQL Server?Did you install the corequisite Teradata GSS component along with the driver?Do you have more than one copy of terasso.dll installed, in different pa... |
395 | 30 May 2009 @ 06:27 PDT | UDA | Reply | MS access link to Teradata subset of views that is granted from a role | That's what the "Use X Views" driver option is for; those views restrict the metadata APIs to return only objects for which the user has some access. You will likely need to set the "No HELP DATABA... |
394 | 30 May 2009 @ 06:08 PDT | Database | Reply | Recursive Query and substring error | LEFT() is not a Teradata SQL function. SUBSTRING(ID FROM 1 FOR 3) or SUBSTR(ID,1,3) should work.By the way, LENGTH() - in your comments - is not a Teradata function either; use CHARACTER_LENGTH or ... |
393 | 30 May 2009 @ 05:46 PDT | Tools | Reply | mLOAD DELETE JOB | Jim has already provided the correct answer. Fastload does have two phases, rather unimaginatively named "Phase 1" and "Phase 2". There is nothing to "apply" so no Application phase; Phase 1 and Ph... |
392 | 27 May 2009 @ 11:38 PDT | Tools | Reply | mLOAD DELETE JOB | To record pending NUSI deletes as the table rows are deleted. |
391 | 27 May 2009 @ 11:30 PDT | Connectivity | Reply | Connect Teradata to MS Access | OLE DB Provider ... Provider=TDOLEDBorODBC Driver ... Provider={Teradata} |
390 | 21 May 2009 @ 01:38 PDT | Database | Reply | Pad the leading zeros | CAST(CAST(CLNT_I AS FORMAT'-9(10)') AS CHAR(11)) |
389 | 19 May 2009 @ 02:35 PDT | UDA | Reply | Performance issue with the query | My guess would be the same ID is present in many different rows, either in the existing table or in the subquery or both. Duplicate row checking will be required for INSERT into a non-empty SET tab... |
388 | 15 May 2009 @ 12:46 PDT | Analytics | Reply | Convert Decimal to Signed Numeric value | Use "Teradata style" cast:field1 (FORMAT '-(12)9') (CHAR(13)) |
387 | 15 May 2009 @ 12:35 PDT | UDA | Reply | Teradata Default date format Issue. | Teradata is returning the TIMESTAMP in the binary format specified by the API, and your application is formatting it on the client side.If you prefer Teradata to do the display formatting before re... |
386 | 26 Apr 2009 @ 11:50 PDT | Database | Reply | DIGITS | Use CAST(CAST(COLUMN1 AS FORMAT '9(p)') AS CHAR(p))Where p is the number of digits in the result.By the way, lengths used by DB2 are:SMALLINT - 5INTEGER - 9BIGINT - 19For DECIMAL(p,s) where s <&... |
385 | 22 Apr 2009 @ 11:45 PDT | Database | Reply | setting up hosts file entries in such a way to avoid giving TPID in BTEQ scripts | I find it odd that you mention inclusion of TDPID as a security issue but you're OK with including username and password both in clear text.BTEQ uses CLI so ignores odbc.ini. And you should never s... |
384 | 17 Apr 2009 @ 11:35 PDT | Database | Reply | how to set the HEADER OFF | What you are seeing is probably the column title, not page heading. Specifying a blank column title should solve your issue..set format off.set titledashes off .export file /root/nvfiles/create_BKP... |
383 | 15 Apr 2009 @ 08:37 PDT | Database | Reply | Printing/displaying to screen in Procedure | For external Stored Procedures and User-Defined Functions there is special "trace table" functionality available for debugging. For SQL SPs, you can add regular INSERT statements; GLOBAL TEMPORARY ... |
382 | 05 Apr 2009 @ 12:47 PDT | Database | Reply | Complex Sequence Number | This may be the general approach you are looking for:INSERT table2SELECT act_no, c2, c3, ROW_NUMBER() OVER (PARTITION BY act_no ORDER BY c2) as SeqFROM table1;But if you require the exact sequence ... |
381 | 04 Apr 2009 @ 07:58 PDT | Database | Reply | How can I use a reserved keyword as a common field? | Use quoted identifier syntax:SELECT "RELEASE", FIELD1 FROM TABLE1; |
380 | 03 Apr 2009 @ 03:15 PDT | Database | Reply | Problems with "WITH(NOLOCK" | WITH(NOLOCK) is SQL Server syntax. Teradata equivalent is LOCKING modifier requesting downgrade to ACCESS locks.LOCKING ROW FOR ACCESS SELECT FIELD FROM SOME_TABLE WHERE FILD > 0; |
379 | 01 Apr 2009 @ 11:21 PDT | Database | Reply | LARRY HIGA MACROS | Log in to Teradata @ Your Service and search for the knowledge article. There are attachments including the macros themselves, spreadsheets that display the results, etc. for various releases of Te... |
378 | 30 Mar 2009 @ 06:38 PDT | Database | Reply | Locking | The RENAME will be blocked by the SELECT. I can't say why the SELECT is not releasing the lock. For example, you could be running in ANSI mode and have not done explicit COMMIT. Or you could have a... |
377 | 28 Mar 2009 @ 03:26 PDT | Database | Reply | Locking | Note that in your examples the LOCKING modifier is NOT part of the view definition, rather it is being applied prior to executing the DDL statement - CREATE or REPLACE.While updating "through" a vi... |
376 | 24 Mar 2009 @ 06:32 PDT | Tools | Reply | delete and delete all | No difference, other than the noise word "ALL". |
375 | 19 Mar 2009 @ 05:56 PDT | Database | Reply | bahaviour of primary index with two columns | Teradata calculates a RowHash based on the values of the Primary Index fields, and uses that to determine the AMPs (via hash map "buckets"). The same set of values always has the same RowHash.Inves... |
374 | 18 Mar 2009 @ 11:56 PDT | Database | Reply | The owner referenced by user does not have Create table with grant option | The stored procedure is in effect attempting to convey the right to rename tables in database B to a third party calling the SP. So A must hold the necessary rights (i.e. CREATE TABLE) on B "WITH G... |
373 | 18 Mar 2009 @ 11:53 PDT | Database | Reply | CPU Skew / IO Skew | Typical calculation for skew factor is (1 - (AVG/MAX))*100.QryLog has MAX and Total values; to get "AVG", divide total by NumOfActiveAMPs. |
372 | 10 Mar 2009 @ 12:08 PDT | Analytics | Reply | substring(accno,7,10) | Either substr(accno,7,10) or substring(accno from 7 for 10) will work.The substring(accno,7,10) is ODBC function syntax - i.e. valid only if you are using ODBC driver and have SQL Extensions enabled. |