#DateForumTypeThreadPost
39605 Jun 2009 @ 12:43 PDTConnectivityReplyodbc/ sql server linked server connection problemDoes 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...
39530 May 2009 @ 06:27 PDTUDAReplyMS access link to Teradata subset of views that is granted from a roleThat'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...
39430 May 2009 @ 06:08 PDTDatabaseReplyRecursive Query and substring errorLEFT() 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 ...
39330 May 2009 @ 05:46 PDTToolsReplymLOAD DELETE JOBJim 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...
39227 May 2009 @ 11:38 PDTToolsReplymLOAD DELETE JOBTo record pending NUSI deletes as the table rows are deleted.
39127 May 2009 @ 11:30 PDTConnectivityReplyConnect Teradata to MS AccessOLE DB Provider ... Provider=TDOLEDBorODBC Driver ... Provider={Teradata}
39021 May 2009 @ 01:38 PDTDatabaseReplyPad the leading zerosCAST(CAST(CLNT_I AS FORMAT'-9(10)') AS CHAR(11))
38919 May 2009 @ 02:35 PDTUDAReplyPerformance issue with the queryMy 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...
38815 May 2009 @ 12:46 PDTAnalyticsReplyConvert Decimal to Signed Numeric valueUse "Teradata style" cast:field1 (FORMAT '-(12)9') (CHAR(13))
38715 May 2009 @ 12:35 PDTUDAReplyTeradata 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...
38626 Apr 2009 @ 11:50 PDTDatabaseReplyDIGITSUse 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 <&...
38522 Apr 2009 @ 11:45 PDTDatabaseReplysetting up hosts file entries in such a way to avoid giving TPID in BTEQ scriptsI 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...
38417 Apr 2009 @ 11:35 PDTDatabaseReplyhow to set the HEADER OFFWhat 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...
38315 Apr 2009 @ 08:37 PDTDatabaseReplyPrinting/displaying to screen in ProcedureFor 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 ...
38205 Apr 2009 @ 12:47 PDTDatabaseReplyComplex Sequence NumberThis 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 ...
38104 Apr 2009 @ 07:58 PDTDatabaseReplyHow can I use a reserved keyword as a common field?Use quoted identifier syntax:SELECT "RELEASE", FIELD1 FROM TABLE1;
38003 Apr 2009 @ 03:15 PDTDatabaseReplyProblems 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;
37901 Apr 2009 @ 11:21 PDTDatabaseReplyLARRY HIGA MACROSLog 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...
37830 Mar 2009 @ 06:38 PDTDatabaseReplyLockingThe 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...
37728 Mar 2009 @ 03:26 PDTDatabaseReplyLockingNote 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...
37624 Mar 2009 @ 06:32 PDTToolsReplydelete and delete allNo difference, other than the noise word "ALL".
37519 Mar 2009 @ 05:56 PDTDatabaseReplybahaviour of primary index with two columnsTeradata 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...
37418 Mar 2009 @ 11:56 PDTDatabaseReplyThe owner referenced by user does not have Create table with grant optionThe 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...
37318 Mar 2009 @ 11:53 PDTDatabaseReplyCPU Skew / IO SkewTypical calculation for skew factor is (1 - (AVG/MAX))*100.QryLog has MAX and Total values; to get "AVG", divide total by NumOfActiveAMPs.
37210 Mar 2009 @ 12:08 PDTAnalyticsReplysubstring(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.

Pages