#DateForumTypeThreadPost
2014 Jul 2016 @ 06:42 PDTTeradata StudioReplyUnable to connect to the database using Teradata Studio Express.Hi, The way how it worked for me:   1. Run your VM. 2. Click on Computer (look at the low corner left) 3. Click on Network Wired 4. Choose Traditional Method with ifup 5. Verify the opt...
1902 Jun 2016 @ 12:12 PDTDatabaseReplyNo spool space error,when running SP in BTEQ.Hi There are some points you need to consider to avoid "no more spool space" - Verify if the SQL you are using has been written correctly. It means you use the proper  PI, PPI, NUS...
1802 Jun 2016 @ 07:31 PDTDatabaseReplyBTEQ: If Else condition bteq<<BTEQ>$FILELOG .logon $vServer/$vUser, $vPassword .SET DEFAULTS .SET TITLEDASHES OFF .SET WIDTH 254 SEL DATE,TIME; SELECT tablename FROM dbc.tables WHERE databasename =...
1705 Apr 2016 @ 08:06 PDTDatabaseReplyJoining varchar to integerWhat about if you try to create a new table, could be a volatile one with the needed information of  DB_2.BKEY_CARD and then join with the one you have in FROM.   Regards,
1629 Mar 2016 @ 09:58 PDTToolsReplyTools and Utilities 15.000 Download for LinuxIt may help you --> https://downloads.teradata.com/download/tools   Cheers,
1511 Mar 2016 @ 10:18 PSTDatabaseReplyHow to update the current row value based on the previous row value of the same columnYou may try to enumarate every single row. When you are done, try to group by the criterias you decide, so that's one way you can control what the preview row is and what the next one is. &nbs...
1411 Mar 2016 @ 08:07 PSTDatabaseTopicFind a way to standardize addressesHi Guys, I would like to know if there is a way or function in Teradata which allows me to standardize addresses. For instance, I have the following scenarios: Address #1 Street 111 William...
1317 Jul 2013 @ 03:30 PDTDatabaseReplyI want to separate the full name in two partsYou may check the following link   http://forums.teradata.com/forum/enterprise/split-delimited-column-into-separate-rows
1217 Jul 2013 @ 01:27 PDTDatabaseReplyModify the partitionDixxie, thanks so much for your response :) it worked :)
1116 Jul 2013 @ 07:52 PDTDatabaseTopicModify the partitionHi Everyone,   I have a table which has a partition by a date field as it follows: PARTITION BY RANGE_N(RestoreDate BETWEEN DATE '2008-04-01' AND DATE '2012-12-31' EACH I...
1006 Jun 2013 @ 02:56 PDTDatabaseReplyTeradata SWI dont know where you are located so I cannot tell you a good Institute, but I suggest you to check some manuals by going to http://www.info.teradata.com/ it may help you
906 Jun 2013 @ 06:23 PDTDatabaseReplyAbout renaming a columnThanks Harpreet for your suggestion :) Thanks Chinmay :)
806 Jun 2013 @ 06:21 PDTDatabaseReplyConvert string into dateYou may try to cast the string value to date format...   cast (string_value as date format 'YYYY/MM/DD')   Since you have 4/6/2013 you could concatenate a zero (0) to the firs...
705 Jun 2013 @ 04:46 PDTDatabaseTopicAbout renaming a columnHi everyone   I've created a table and I want to modify the datatype to one field from Char(4) to Char(5) but it is not possible....I tried to rename the column using the following state...
603 May 2013 @ 07:52 PDTDatabaseReplyTeradata basicsHi, By clicking on the following link you can find a lot of information related with Teradata. http://www.info.teradata.com/   And also feel free to post any doubt on the forum :)   ...
530 Apr 2013 @ 10:03 PDTDatabaseReplyAbout Partitioned Primary Index (PPI) Hi Vikas, thanks for ur response...So, what You say is that If I add a new range by  People_Subscription_Start_DT, Do I need to include People_Subscription_Start_DT as part o...
429 Apr 2013 @ 10:26 PDTDatabaseReplySecondary indexesI agree Adeel. It depends how the table is gonna be accessed, in addition the fields you are crossing when creating the query...also if is a table that stores a lot data....you should consider this...
329 Apr 2013 @ 10:18 PDTDatabaseTopicAbout Partitioned Primary Index (PPI)Hi everyone.. Well, I have a table with the following structure and I need to add  a new RANGE by adding the field People_Subscription_Start_DT: PARTITION BY RANGE_N (People_Subscription_Sta...
212 Apr 2013 @ 07:57 PDTDatabaseReplyTeradata - How to create a partitionHi, I've realized and I was trying to create the partition on a table which contains data, so What I did was create a new table with the same structure and the partition and it worked fine :) t...
111 Apr 2013 @ 02:41 PDTDatabaseTopicTeradata - How to create a partitionHi everyone... I've started learning about Teradata and I have a doubt on how to create a partition....The table already exists and I suppose I need to do the Alter table sentence, however, I ...