#DateForumTypeThreadPost
2418 Aug 2015 @ 01:05 PDTDatabaseReplyTable Lock Issue..Try removing  dbname.tablename.   Just BEGIN LOADING and END LOADING.   --Aarsh Dave
2323 Feb 2015 @ 02:54 PSTDatabaseReplyNeed help to get the SQL logicCheck this... Select T1.Col1,   CASE         WHEN ACTCNT = MATCNT             Then T2.Col5    &n...
2205 Dec 2014 @ 12:45 PSTTeradata StudioReplySetup host server for Studio ExpressThank you fgrimmer for your reply. Can you please also let me know what VMWare should I install on my machine?   Thanks, Aarsh
2107 Nov 2014 @ 02:20 PSTTeradata StudioTopicSetup host server for Studio ExpressHi All, I installed Studio express on my personal machine for practice purpose. When I try to create a new data source, it asks the server host name. I was wondering if I can give my machine's...
2018 Aug 2014 @ 02:11 PDTDatabaseTopicRetrieving value for multiple records into single recordHi All, I need to retrieve data from multiple records and store it into a single column seperated by ';'. For example, the table test_vt has column A and two records. A 5 10 I need to...
1922 May 2014 @ 06:58 PDTDatabaseReplyString pattern match using regular expressionsHi Dieter, Thank you very much for your reply. However, what I want is that only the 10 digit number be considered whether +1 is there or not. The regular expression you gave gives me the second...
1822 May 2014 @ 10:30 PDTDatabaseTopicString pattern match using regular expressionsHi All, I am fairly new to Teradata 14 and want to use the Regular Expressions. I have a column that has values as below. COL_A ------------------- <ABC:+15419928832> <ABC:54199285...
1726 Mar 2014 @ 08:48 PDTDatabaseTopicGetting average using inbuilt Teradata functionsHI, I have a table that stores a timestamp field, START_TM. What I want to do is find average number of records on this table for the past one month. I wrote the following query and it works. S...
1627 Jan 2014 @ 10:54 PSTDatabaseReplyFormatting CURRENT_TIMESTAMPThanks Khurram and Raja. It helped :)
1523 Jan 2014 @ 11:11 PSTDatabaseTopicFormatting CURRENT_TIMESTAMPHi All, I want to select the current_timestamp in a specific format 'YYYYMMDDHH24MISS'. Can you please let me know how I should go about it?
1420 Jan 2014 @ 12:27 PSTData ModelingTopicUsing a PPI column in PIHi All, I have a table that has PI consisting of Col_A and Col_B. Col_C is a timestamp(6) field which is a PPI. As per the current data, the table has a skew factor of 75%. Therefore, I created ...
1320 Jan 2014 @ 12:26 PSTData ModelingTopicUsing a PPI column in PIHi All, I have a table that has PI consisting of Col_A and Col_B. Col_C is a timestamp(6) field which is a PPI. As per the current data, the table has a skew factor of 75%. Therefore, I created ...
1226 Dec 2013 @ 11:04 PSTToolsReplyTPT job fails, Log refers to a completely seperate unrelated jobNot sure if you are doing it, but have seperate log names for each job. That would help as well. Thanks, Aarsh
1126 Dec 2013 @ 11:00 PSTToolsReplyTPT with Unicode columns in source.Hi Indrajit, The column definition should have the layout of the target table. I believe you should define column Source_Col1 as INTEGER instead of NUMBER(38).   Thanks, Aarsh
1026 Dec 2013 @ 10:41 PSTToolsTopicWhen are secondary indexes required?Hi All, I understand that a Secondary Index is a 2-AMP or an all-AMP operation, and also the subtable that is created and its contents. However, I am not sure in what scenarios should a secondary...
905 Sep 2013 @ 02:39 PDTDatabaseReplyENCODING Error in Teradata v14Additionally, the database on which it fails has the below characteristics: RELEASE    14.00.03.08 VERSION    14.00.03.07 LANGUAGE SUPPORT MODE    ...
805 Sep 2013 @ 02:36 PDTDatabaseTopicENCODING Error in Teradata v14Hi, I need to convert hexadecimal value to a decimal value. FOr that purpose, I have created the following query. SELECT ZEROIFNULL(CAST(FROM_BYTES( TO_BYTES('0' || SUBSTR(col_a ,9,5),...
705 Sep 2013 @ 02:36 PDTDatabaseTopicENCODING Error in Teradata v14Hi, I need to convert hexadecimal value to a decimal value. FOr that purpose, I have created the following query. SELECT ZEROIFNULL(CAST(FROM_BYTES( TO_BYTES('0' || SUBSTR(col_a ,9,5),...
605 Mar 2013 @ 05:01 PSTDatabaseTopicCrash Code 3701 encountered while creating a volatile tableHi All, I am trying to create a volatile table by selecting data from an existing table. However, when I execute the CREATE TABLE query, I get the following error. CREATE TABLE failed. Ple...
512 Dec 2012 @ 01:07 PSTDatabaseReplyConvert integer to TIMEYes ... it does work in BTEQ ...  if nothing else works, I will use this one ... However, am still looking for a more generalised solution :)
412 Dec 2012 @ 11:28 PSTDatabaseReplyConvert integer to TIME@Dieter ... It gives an error ... multiple 'FORMAT' options .
312 Dec 2012 @ 10:51 PSTDatabaseReplyConvert integer to TIME@Mohan, The values will remain 4 digit, like 1256 or 0330 and it will be in 12 hour format.   @Harpreet, What you say is correct. However, I need to insert the column A in to column B. I a...
211 Dec 2012 @ 01:54 PSTDatabaseTopicConvert integer to TIMEHi,   I need to insert data from a field A which is an integer to field B which is TIME(6). The data in field A is something like this:   1. 1256, which means 12:56:00 2. 0145, whic...
109 Nov 2012 @ 01:20 PSTDatabaseTopicMultiload data from a table to anotherHi, For an upcoming project, I am required to pull data from a table on database A and load it into a table on database B. I used FASTLOAD in my scipt for this purpose. It works fine, but in case...