#DateForumTypeThreadPost
46912 Jun 2016 @ 04:26 PDTToolsReplyArcmainHi, If you have access to tays, then you can download the Arcman cleint from downloads on Tays. The installation steps depends on your OS. you will find the installation guide there as well. Br, ...
46809 Jun 2016 @ 12:56 PDTDatabaseReplyTeradata demo version 13.1Hi, If you are looking for a free Teradata version for practice, you can download the VmWare edition from the below link: http://downloads.teradata.com/download/database/teradata-express-for-vmwa...
46729 Jul 2015 @ 11:33 PDTDatabaseReplyHow to get the statement that was used to create a table in Teradata? SELECT REQUESTTEXT FROM DBC.TABLES WHERE TABLENAME LIKE '%MYTABLE%';  
46602 Jul 2015 @ 01:40 PDTDatabaseReplyScript to compare two databases (Tables and Views definitions) I did it using the below query:   SELECT DatabaseName,TableName,requesttext FROM dbc.tables WHERE DATABASENAME = 'DATABAE_TO_COMPARE' AND TableKind = 'T' and req...
46516 Apr 2015 @ 01:11 PDTDatabaseReplyResponse Row size or Constant Row size overflowHi, I was facing the same issue in one of my queries, and I investigated and found that I used oreplace function multiple times, I removed the oreplace function and it worked without any issue. So...
46425 Jun 2014 @ 01:27 PDTGeneralReplyHow can we rectify spool space issues.If you are going out of spool spce, you need tune your query and check for the product joins in the explain plan. Generate the explain plan and then carefully analyze if there is any product join,...
46325 Jun 2014 @ 01:06 PDTGeneralReplyqueries on casting in teradataSamath, In the first query, as the count is Integer, and integer requires 11 char for its representation, when integer is converted into Char it is right aligned and result is only left sid 4 char...
46225 Jun 2014 @ 12:46 PDTToolsReplyTPT Load Operator Table LockI would like to advise you use Update operator, or Multiload to load load ready tables, and then use merge to apply data to target. In some cases, if the target table has been locked by update ope...
46125 Jun 2014 @ 12:35 PDTToolsReplyFastload exit code verificationyes you can do it using shell script. Put the following command in your shell script: ERROR_HANDLER() { echo " " echo "Error occured!!!" echo "ERRORLEVE...
46017 Jun 2014 @ 07:07 PDTDatabaseReplyMultiplication of DecimalsHi,   You have created the col in table X as varchar and while comparing this number to a decimal it will try for an implicit conversion into the default maxdecimal 38 percision. Real number...
45917 Jun 2014 @ 01:18 PDTUDAReplyImporting delimiter text file!!!!!!!!Ramesh, You can use TAB as {Tab} .IMPORT VARTEXT '{Tab}' FILE=D:\ABC.txt;  
45817 Jun 2014 @ 01:12 PDTDatabaseReplyHelp needed in Bteq ExportHi King, One possible option is to split the single large data set to mutiple file based on a condition. Can you please paste the TPT termination error message?  
45703 Apr 2014 @ 04:12 PDTUDAReplyLoading Unicode data from Oracle to teradataHi,   I am facing a similar issue while processing arabic text. In fact I have to process text files containing arabic text. The default file encoding is ASCII, I convert it into UTF8, that ...
45602 Mar 2014 @ 02:51 PSTGeneralReplySamples database and create databaseSundeep, It is quite simple, once you are logged in as DBC user, you can access all the databasees below it in hirarchy. DBC is the most powerfull user in Teradata. Further there is a database nam...
45525 Feb 2014 @ 08:44 PSTDatabaseReplySQL Issue - Qualify partition by issueTry this: CREATE VOLATILE SET TABLE OLB_CUST_SCL1 AS ( SELECT CAST ( C.ACCOUNTID as DECIMAL(18,0)) AS ACCOUNTID , C.SOR_ID , C.EMAIL FROM PEDW_SECURED.OLB_PRFL C INNER JOIN SE...
45425 Feb 2014 @ 09:55 PSTDatabaseReplyUnicode Substr issue with special charactersIrfan, Can you please tell what issue exactly you are facing?, I have tried the same code with a little change and it is working fine. The code I used is  SELECT CASE WHEN TRIM(price) ...
45325 Feb 2014 @ 09:27 PSTToolsReplyTTU 13.10Yes, it works :)  
45224 Feb 2014 @ 04:29 PSTGeneralReplyTeradata Express for WindowsAndre, Teradata 14 has discontinued an executable version on Windows or Linuex, the only option available is to use VM Ware. So in order to learn Teradata, you need to use VmWare version. Before t...
45122 Feb 2014 @ 03:21 PSTDatabaseReplyDelete table from within SSISGreat :)
45020 Feb 2014 @ 02:26 PSTDatabaseReplyOrder by DateAFAIK, You can not use Order by inside a view, You can only use Order by within a view with last select of a set operation e.g Union Create view Test ( SELECT.... UNION SELECT Order by 1,2,3....
44920 Feb 2014 @ 12:51 PSTDatabaseReplyODBC client on windowsI think your machine is 64 bit, please confirm, if you machine is 64 bit then you will not able to see any drivers in 64 bit ODBC, rather you should use 32 bit odbc. Go to the Start -> All progr...
44820 Feb 2014 @ 12:49 PSTGeneralReplyFYP ideasNatasha, I suggest you should go for a team, a team of two people will be good. The second thing is you can discuss it with your internal project coordinator. I would suggest you shold go for a c...
44720 Feb 2014 @ 12:45 PSTConnectivityReplyTeradata with SSISHi, The best way to use SSIS with Teradata is through Microsoft Attunity connector. You can get this driver from this URl, and it will help to use TPT operators through SSIS. http://www.microsoft...
44620 Feb 2014 @ 12:25 PSTDatabaseReplyKeep getting StatusCode="2802",ErrorMessage="SQLState =23505" after delete and reinsertThis jump around is normal, AFAIk TD generates id with gaps. So dont worry about that, but as long as the table is being deleted and reinserted the issue can occure.   
44519 Feb 2014 @ 11:46 PSTDatabaseReplyKeep getting StatusCode="2802",ErrorMessage="SQLState =23505" after delete and reinsertHi, AFAIK, The identity value is cached in PE, and also saved in some table, So it will start from 1 only when you recreate the the table, other wise the number might be repeated. you have defined...

Pages