All Forums

Covers Teradata-developed applications such as TRM, DCM, etc. For articles, blogs and more, see the Applications section of the site.

You must login to post to the forums.
Teradata FAST LOAD RDBMS Error 3706 : Syntax error: expected something between ';' and the 'using' keyword Topic by suseegirl 28 Mar 2016 teradata fast load

Hi I am new to Teradata and using the fast load to load a table, however I am unable to execute this script as I am getting RDBMS Error 3706 : Syntax error: expected something between ';' and the 'using' keyword
Below is my query

SET RECORD VARTEXT '|';

DEFINE 

AB (VARCHAR(24))

,CD (VARCHAR(24))

,MD (VARCHAR(50))

FILE = C:\FL\1.dsv;

266 views
0 replies
T-PUMP DML ERROR Topic by kumarvaibhav1992 26 Mar 2016 #database #teradata express #support utilities
.LOGTABLE  etlt5.EMP_TPUMP_LOG;
.logon ttdbia/LOGIN DETAILS;

.BEGIN LOAD;
PACK 5
RATE 10
ERROR TABLE Etlt5.TPUMPERROR;



 .LAYOUT RECLAYOUT;

 .FIELD    id        * varchar(10);
.FIELD    name      * varchar(20);
.FIELD    country   * varCHAR(30);


.DML label INST;

INSERT INTO etlt5.infa_source12
(id,name,country)
VALUES 
(:id, :name, :country)

194 views
3 replies, 3 years ago
Problem to reset date column in a scenario Topic by AnuJoseph 21 Mar 2016

Hi,
I have an issue with a particular data scenario. Below is the initial data set:

127 views
2 replies, 3 years ago
TPUMP NOT WORKING Topic by kumarvaibhav1992 20 Mar 2016 #database #teradata
I have the below code For T-PUMP WHICH IS not working .Please help me because t-pump has very less number of 
posts online

bteq<<eof1
SESSIONS 1;
LOGTABLE Etlt5.EMP_TPUMP_LOG;
.logon ttdbia/a0c9sx,blue@126;
BEGIN LOAD
PACK 5
RATE 10
ERROR TABLE EMPDB.TPUMPERROR;
 
.LAYOUT RECLAYOUT;
.FIELD id * varchar(10);
.FIELD name * varchar(20);
.FIELD country * varCHAR(30);
 
256 views
4 replies, 3 years ago
M-load Error while executing script Topic by kumarvaibhav1992 12 Mar 2016 #database #teradatam

Hi All,
 
When executing the below script for MLOADm getting the below error:
 
output:
$ ./multiload.sh
./multiload.sh: .LOGTABLE:  not found.
./multiload.sh[2]: .logon:  not found.
./multiload.sh[4]: .begin:  not found.
./multiload.sh[5]: .layout:  not found.

282 views
9 replies, 3 years ago
Multiple sessions in Fastload Topic by kumarvaibhav1992 06 Mar 2016 teradata

i tried making two sessions in fasload 1st got passed with inserion and 2nd didnt showed any such behaviour.
so why cant we have multiple sessions in fastload to load multiple tables?

214 views
1 reply, 3 years ago
Teradata Syntax Trouble Topic by smart351 27 Mar 2013

Hello!  I am using Teradata release 13.00.01.03. I am having a terrible time with some syntax. I was hoping someone could help?
 

4886 views
12 replies, 3 years ago
How to see Information In Data Dictionary in teradata after stats collections Topic by kumarvaibhav1992 27 Feb 2016 teradata

There are 3 locations. DBC.ColumnStats, DBC.IndexStats, and DBC.MultiColumnStats where the information for the stats used to get stored.i'm giving the below query to find that info regarding no of rows in a table or average row size  etc.
SEL* FROM DBC.COLUMNSTATS WHERE TABLENAME LIKE'%INFA_SOURCE12%'

157 views
1 reply, 3 years ago
Import Tab delimited file through Teradata fast load utility is not working. Topic by Jayakumar.mm 24 Feb 2016 fast load, teradata, scripts

I am facing an issue in executing below scritp  through fast load utility for tab delimited .txt file
1. First issue in .RECORD 1;
2. IF I remove .RECORD 1; from the code, I am getting "Specified string does not have matchSpecified string does not have match FDL4800 Invalid FastLoad statement" 

380 views
4 replies, 3 years ago
Same ROW-Hash Value for all the record Topic by kumarvaibhav1992 21 Feb 2016 # teradata

Hi All,
When i tried finding the Row hash value for the unique column which have all unique values ,i saw that all row hash value matches for every single record present there.
http://www.teradatatech.com/?p=470 this link suggest that row hash values cannot be same for unique as well as non unique columns.
please clarify me on this question.

126 views
2 replies, 3 years ago
*** Failure 6760 Invalid timestamp. in bteq import Topic by n@new1 05 Feb 2016

Hi All,
While importing data from INDICDATA file I m getting following error :
 *** Growing Buffer to 4757
 *** Failure 6760 Invalid timestamp.
                Statement# 1, Info =0
 
Export Script :
 

.EXPORT INDICDATA FILE='data.txt'

.decimaldigits 38

.SET WIDTH 9000

.SET SESSION CHARSET "UTF8"

 

 

165 views
0 replies
SQL Assistant - # of rows updated Topic by gopal_rama 21 Jan 2016

When I update records using SQL Asst in a iSeries file , the # of records updated is neither showing in the task bar nor in History.
Same is the case with deletes and inserts.  Please help as to how to make this work.     Thanks.

264 views
0 replies
Varchar expanding to its maximum length in fexp - ALSO USING THIS FIELD IN ORDER BY Topic by ABHITD 13 Jan 2016 #varchar expansion in fexp, #FASTEXPORT #FEXP, # teradata

hi all ,
I increased the varchar length from 255 to 1500 in a table:
before :the column was declared with varchar(255) in table_A
after :i changed it to varchar(1500) in table_A
but this simple change degraded fexp's performence.
FEXP was something like :
 
select 

283 views
8 replies, 3 years ago
Problems loading fixed length file via TPT Load operation (TTU 15.10) Topic by richhalp 07 Jan 2016

I am trying to use TPT to load a fixed length file via Linux client (TTU 15.10).
The "problem" is that the file though defined as fixed length, sometimes does not have a value in FIELD3, in which case there is a line feed ending the record.
Is there still a way to use TPT to load the file?
Here is VARCHAR WorkingDatabase
);

124 views
1 reply, 3 years ago
Multiple files in Fastload script Topic by malli111 20 Jul 2015

Hi Dieter,
can you please help me to load the data from two files to single target table using FASTLOAD.
below is the code:
 

sessions 2;

errlimit 25;

.logon username/password;

database supportdb;

drop table SUPPORTDB.emp_f1;

drop table supportdb.err_f1;

drop table supportdb.uv_f1;

 

912 views
2 replies, 3 years ago
DOT CHARACTER FOR BTEQ, FASTLOAD AND MULTILOAD COMMANDS Topic by p12345 08 Jan 2016

Hi,
I just want to know whether dot character used before bteq , fastload and multiload commands is mandatory or not.
I have been searching about it for a past couple of days, but I am getting mixed response. In the teradata official website, it is written that dot character is optional but recommended, whereas in the bteq manual it is written that dot character is mandatory.

184 views
5 replies, 3 years ago
parllel processing in bteq and fastload Topic by p12345 08 Jan 2016

I came to know from Internet materials that Fastload uses sessions to process data in parallel, where bteq works on row by row. But in bteq also we can specify no. of sessions, then bteq should also process data in parallel.
 
Please clarify on the issue.

81 views
0 replies
Performance tuning question Topic by satyanarayanatera 02 Jan 2016
SELECT
TRAN_ID.SRC_TRAN_ID,
TRAN_ID.SRC_SYS_ID,
TRAN_ID. SRC_TRAN_DT,
TRAN_ID.TRAN_ID,
TRAN_ID.ROW_STAT_CD
FROM
RD_GBS_WIR RD
INNER JOIN
TGT_TRAN_ID TRAN_ID
ON
RD.SRC_TRAN_ID =TRAN_ID.SRC_TRAN_ID
WHERE
TRAN_ID.ROW_STAT_CD=‘A’
AND TRAN_ID.SRC_SYS_ID=‘SOR1’
QUALIFY ROW_NUMBER () OVER (PARTITION BY TRAN_ID.SRC_TRAN_ID 
272 views
3 replies, 3 years ago
Load Flat File using TDE 12.1.5.0 Topic by JKB 26 Dec 2015 tpt, tde
#!/bin/ksh
TBUILD <<EOF
DEFINE JOB FILE_LOAD
DESCRIPTION 'Load a Teradata table from a file'
(
DEFINE SCHEMA Trans_n_Accts_Schema
(
Account_Number VARCHAR(50),
Trans_Number VARCHAR(50),
Trans_Date VARCHAR(50),
Trans_ID VARCHAR(50),
Trans_Amount VARCHAR(50)
);
 
DEFINE OPERATOR DDL_OPERATOR
TYPE DDL
ATTRIBUTES
(
VARCHAR PrivateLogName = 'ddl_log',
339 views
2 replies, 3 years ago
activate Nontemporal operations with DBS CONTROL or Teradata Administrator Topic by FN186005 11 Dec 2015 #dbscontrol, #nontemporal

Hi there! I'm quite new by teradata.
After researching i understood that DBS CONTROL is an Utility that can be also executed wit Linux command, so i searched for such a directory it in the terminal of my
virtual machine but  i wasn't able to find it.

505 views
2 replies, 3 years ago
Terdata BTEQ script ERROR: Topic by Govind3331 06 Dec 2015 #BTEQ, #database #teradata
####################################
bteq <<EOF
.LOGON servername/username,********
/* sql code on next line(s) */
select  databasename from dbc.databases where databasename="P_EIW_S_LIS_01";
.export reset
.LOGOFF ;
EOF
###################################

Above is the BTEQ Script:
When i am executing the above script i am getting below error:
310 views
2 replies, 3 years ago
How to create BTEQ Script in LINUX environment?? Topic by Govind3331 04 Dec 2015 #BTEQ, #database #teradata

HI ,
Could someone hep in creating BTEQ Scripts in LINUX Operating system(NOT in UNIX). can we execute BTEQ script in LINUX or is their any issue while running in LINUX environment.
 
Help me creating .RUN file, if servername/username,password --> are credentials.
select * from dbc.tables-->is select statement

240 views
5 replies, 3 years ago
UTY3403 Only one statement per line is allowed. Extra characters were detected beginning in column '10'' Topic by nani_hero 26 Oct 2014

hi ,
im getting the  above error while running the script but i cant find any mistakes in the script plz, help me where it went wrong. it shows in begin import task .
.run file d:\practise\conn.txt;
.LOGTABLE ablog;

2513 views
5 replies, 3 years ago
Teradata Addition Issue Topic by BOA 15 Oct 2015

Hello!
Any ideas why the following would not work?
     (cast(totalweight as decimal(20,2))/60) + (cast(q4.totalwork as decimal (6,2))/60) + (cast(q5.totalloansqcd as decimal (6,2))/60) as TotalWork
Broken up, these two work separately....
     (cast(totalweight as decimal(20,2))/60) + (cast(q4.totalwork as decimal( (6,2))/60)
and

530 views
3 replies, 3 years ago
DataBase Migration from Teradata to Oracle and viceversa Topic by rohit.lalwani1 08 Oct 2015

HI 
We are working in project where we need to reuse some of ETL jobs of one project into another project but the only issue is Target DB is different in both projects but ETL tool is same (Data stage). 
Current XML : Souce : Oracle ,Target : Teradata, ETL tool : Data Stage
New XML : Source : Oracle ,Target : Oracle ,ETL tool : Data Stage

646 views
0 replies

Pages