19 | 11 Sep 2013 @ 12:42 PDT | Database | Reply | ADD_MONTHS vs INTERVAL | Hi,
Interval is a data type in Teradata that represent displacement between two points in time.
ADD_MONTHS adds the months and years (Months * 12) to a specific date, while using Interval y... |
18 | 10 Sep 2013 @ 12:45 PDT | Database | Reply | Importing the large flat files failing | I would say it is not a limitation of Teradata, as Teradata can handle trillions of rows.
Rather it can be a limitation of SQL Assistant, ODBC and Network resources.
When you import f... |
17 | 09 Sep 2013 @ 12:34 PDT | Tools | Reply | how ot use a loop in btep? | In BTEQ there is a command available to repeat a stement multiple times.
.REPEAT INTEGER(how many times you want to repeat)
Example:
.Repeat 5
SELECT Data;
This will repeat this select 5 times... |
16 | 06 Sep 2013 @ 02:15 PDT | Database | Reply | Need Analytical window query help | Assuming the ID column as Primary_key I have made the following sample query:
SELECT
ID,
Status,
CASE
WHEN NEW_DATA.Status = OLD_DATA.STATUS
THEN 1
ELSE 0
END ... |
15 | 06 Sep 2013 @ 01:01 PDT | Database | Reply | Leading Spaces in answer set in SQLA | Hi Barani,
You are right the output will be in character using TO_CHAR, But upto my knowledge the to_char do not perform in implicit truncation while CAST perofrms imiplicit truncation and re... |
14 | 06 Sep 2013 @ 12:18 PDT | Database | Reply | Select Failed: 3504: Selected non_aggregate values must be part of the associated group | In fact you are using aggregate function in you query and forgot to use group by clause for non aggregate columns.
for example for the following part of your query the group by is missing:
-- ... |
13 | 06 Sep 2013 @ 12:01 PDT | Database | Reply | Leading Spaces in answer set in SQLA | Hi,
As Integer ranges from -2147483648 to +2147483647, So it needs 10 characters for digits and1 for sign. By default when you convert an integer to characters it is right justfied inside ch... |
12 | 04 Sep 2013 @ 11:38 PDT | Database | Reply | Titile Stacking? | My apologies, I just passed through a teradata documentation and came to know that Title Stacking occurs only in BTEQ. In SQL Assistant it occures only due to column width. If we expand the column ... |
11 | 04 Sep 2013 @ 09:56 PDT | Database | Reply | RANK | SELECT ALTKN, DOCNUM, KUNNR
FROM TABLE_NAME
QUALIFY ROW_NUMBER() OVER(PARTITION BY ALTKN ORDER BY DOCNUM DESC) = 1;
|
10 | 04 Sep 2013 @ 09:53 PDT | Tools | Reply | TPT script to move data from table to file | Hi Atul,
delete the checkpoint file, and rerun the job, it will be working fine.
|
9 | 02 Sep 2013 @ 05:48 PDT | Tools | Reply | TPT load source files with regular expression | Hi,
Appearantly this regular expression for file names should work, because the * means anything in the file name. Can you please paste the actual error you are facing.
Also consult the following... |
8 | 02 Sep 2013 @ 05:26 PDT | Database | Reply | VMWare Teradata 14.00 - Error while loading data into table | Hi,
Can you please confirm you are trying to connect from your host machine OR you are runnning this command iside VMWARE?
This error means that the TPT is unable to find the server. You ne... |
7 | 31 Aug 2013 @ 03:25 PDT | Database | Reply | ColumnName is missing with error messages | Hi,
Yes there is a method to identify the mismatch column. It might be a slow process, but always worked for me.
You can use the following statment.
SELECT
column1 ,
--column2 ,
--co... |
6 | 31 Aug 2013 @ 03:17 PDT | Database | Reply | Titile Stacking? | Hi,
Dieter is very right. I would like to add that the same can be acheived using the same statement in both BTEQ & SQL Assistant as well.
Khurram
|
5 | 10 Jun 2013 @ 12:00 PDT | Database | Reply | Creating a Soft RI | Hi,
To create references to existing tables, a REFERENCES privilege is needed.
use one of the following:
GRANT REFERENCES ON person_mst TO xyz; /* On all columns */
GRANT ... |
4 | 31 May 2013 @ 02:12 PDT | Database | Reply | CHR function fails | Hi,
This quesry is running fine at my end both at Bteq and SQL Assistant, and I have checked it at bother versions (13.10 & 14).
Can you please paste the actual query you are ... |
3 | 31 May 2013 @ 01:16 PDT | Database | Reply | Replace with carriage return/ line feed | Hi Nolan,
Try this it will solve your problem
SELECT REGEXP_REPLACE('A|b','\|','0D0A'XC);
In fact to replace a special character like | you have to precede it with a back... |
2 | 30 May 2013 @ 04:12 PDT | Database | Reply | Translate loop into Teradata Stored Procedure | Hi,
Hope this will work for you!
REPLACE PROCEDURE Test()
BEGIN
DECLARE logdate DATE;
DECLARE hrinput1 INTEGER;
DECLARE hrinput2 INTEGER;
SET logdate = '2013-03-01';
SET ... |
1 | 04 Oct 2012 @ 11:12 PDT | General | Reply | Informatica/ Teradata INSERT Access WITH GRANT Issue while Loading | Hi,
I am facing the same issue using TPT Stream Operator, The error message is:
TPT10508: RDBMS error 5315: An owner referenced by user does not have INSERT WITH GRANT OPTION acce... |