Teradata SQL Assistant is a Windows client software tool primarily intended to run queries against a Teradata SQL Engine (Relational DBMS). It can also be used with ODBC drivers or .NET data providers from other database vendors. Note: Teradata SQL Assistant is being deprecated by Teradata in favor of multi-platform Eclipse / Java / JDBC based Teradata Studio / Teradata Studio. Express.
Questions tagged [teradata-sql-assistant]
360 questions
0
votes
0 answers
How to enter NULL and Date values into table?
I transfer the data into Tera Data with fastload now in one column 'ENDDATE' There are 2 values stored 'NULL' and Timestamp value like format
YYYY-MM-DDBHH:MI:SS
I want to transfer both values into new table
I want to NULL value replace with…
![](../../users/profiles/7125762.webp)
Ramiz Tariq
- 379
- 5
- 22
0
votes
1 answer
How to convert VARCHAR DATE to Date Format in teradata 15?
I loaded data from csv file with fastload in Tera Data Express 15. In csv file my ModifiedDate format is 6/12/2004 0:00 and in fastload script my Date type is varchar
I create a new table now I want to load data from one table to another table
How…
![](../../users/profiles/7125762.webp)
Ramiz Tariq
- 379
- 5
- 22
0
votes
0 answers
Teradata 15: how to FAST LOAD xlsx?
I'm trying to load data to Teradata directly from xlsx with FAST LOAD.
Receiving the empty table and following error in CTL log:
**** 16:09:28 Number of recs/msg: 10
**** 16:09:28 Starting to send to RDBMS with record 1
**** 16:09:28 Error on piom…
![](../../users/profiles/8725180.webp)
Grigory P
- 165
- 5
- 21
0
votes
0 answers
Viewing A Teradata Alias
I wrote a query where I misspelled the alias I was using (this is pseudocode)
SELECT
ma.name
FROM mytable my
Teradata SQL Assistant did not give its usual error message saying ma does not exist, but ran for a long time and spooled out. I…
![](../../users/profiles/5730226.webp)
Peter
- 181
- 2
- 8
0
votes
0 answers
SQL-Script to Automatically build pallets
I have code that I am using to call out how many pallets an item would be able to build. The issue I am having is I cannot figure out how to then automatically build pallets based on this number.
For example, if I have an item that can build 3.50…
![](../../users/profiles/5806469.webp)
MrLockett
- 95
- 2
- 10
0
votes
1 answer
REGEXP_REPLACE in Teradata SQLA
I am trying to remove the date part at the end of comment data in text in a column. The date at the end is like 21FEB,2004/21FEB and 21FEB18.
I used
RegExp_Replace(X, ' [0-9]{1,2}[A-Z]{3}$','',1,1,'i')
to remove 21FEB at the end of a comment like…
![](../../users/profiles/7371506.webp)
Jude92
- 157
- 2
- 4
- 13
0
votes
1 answer
REGEXP in Teradata SQL
I have a column in a table which has text like "ADDED EMAIL ADDRESS FROM CTCE DATA 21FEB", RMESTIMATE0, 'REQUESTED TKT NUMBERS ON 21FEB' etc. As they are manually entered remarks they don't have any maximum character length. I am required to exclude…
![](../../users/profiles/7371506.webp)
Jude92
- 157
- 2
- 4
- 13
0
votes
1 answer
Alternative to Case when with subqquery to avoid error (Illegal expression in When clause within case statement)
My table structure looks similiar to this
Customer_id Country item_type Order_Size Dates Codes
A401 US Fruit Small 3/14/2016 11
A401 US Fruit Big 5/22/2016 12
A401 US …
![](../../users/profiles/5165649.webp)
viji
- 293
- 3
- 15
0
votes
2 answers
what is the difference between collect statistics multi column or single column in teradata
collect statistics column(column1,column2,column3) on table ;
and
collect statistics column(column1) on table ;
collect statistics column(column2) on table ;
collect statistics column(column3) on table ;
What is the difference in both ways of…
![](../../users/profiles/4195987.webp)
Rakshit Sakhuja
- 45
- 7
0
votes
0 answers
Stored procedure is trying to call to the database inside the database it is created in Teradata
I created a procedure in teradata
REPLACE PROCEDURE ABC.SHOWTABLE (my_table VARCHAR(30),my_database VARCHAR(30))
BEGIN
DECLARE sqlstr VARCHAR(500);
SET sqlstr = 'SHOW TABLE ' || my_database ||
'.' || my_table ;
EXECUTE IMMEDIATE…
![](../../users/profiles/4195987.webp)
Rakshit Sakhuja
- 45
- 7
0
votes
1 answer
Sort data by date & time and then select the next min date to update the other date column in informatica
Have Data like this This is a teradata table which is my source in informatica
S_ID A_ID START_DATE END_DATE STATUS
1 a 01-02-2017 01-03-2017 CLOSED
1 a 01-03-2017 …
![](../../users/profiles/4781552.webp)
Prianka Singh
- 5
- 3
0
votes
0 answers
importing to a volatile table in Teradata
I am trying to import data into a volatile table in teradata using the import feature. My initial creation of the table used:
create volatile table OG_Call
(trans_id int,
EmpID int,
ROUTER_CALLKEY int,
CallDate DATE)
on commit preserve rows;
This…
![](../../users/profiles/3920529.webp)
adidashawn6
- 49
- 1
- 6
0
votes
1 answer
TeradataSQL: How to Standardize Times that are in Both 24 and 12 Hour Format
I'm using a database which is a complete mess and need to figure out the best way to fix it. Right now I have times that are coming into this table that are in 12 hour and 24 hour format (some are 01:30 PM and some are 13:30 PM). To properly compare…
![](../../users/profiles/8379811.webp)
SkywalkerPadawan
- 17
- 5
0
votes
2 answers
TeradataSQL: Time to String, Add to Date and Compare to Another Time and Data
I'm trying to figure out the cleanest way to do a comparison in Teradata SQL Assistant. I have the scheduled start date (TimeStamp), the Schedule start time (varchar), actual start and end times (TimeStamp). I need to consolidate the scheduled start…
![](../../users/profiles/8379811.webp)
SkywalkerPadawan
- 17
- 5
-1
votes
0 answers
Teradata export SQL of millions line to several files
I am trying to export a SQL query with Teradata SQLA. My query returns 15 millions of lines. The output files is too big to be used after.
I want to split in several files the output of the query and in the fastest way.
Best regards,
Jouvzer
![](../../users/profiles/14501053.webp)
Jouvzer
- 55
- 4