Interested to Buy Any Domain ? << Click Here >> for more details...
How can we load single row of data into teradata database.
please give me the process.
- 3 Answers
- 10025 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / yuvaevergreen
BTEQ or multiload(loaded tables) or fastload (empty table)
can be used to load a single row. But BTEQ would be a good
option if you load a single row from a file.Below is a example.
//STEP1 EXEC PGM=BTQMAIN
//LOGON DD DSN=TEST.LOGON(DEVLOGON),DISP=SHR
//SYSIN DD DSN=TEST.PARMLIB(BTEQ1),DISP=SHR
//*TEST.PARMLIB(BTEQ1)
BTEQ MAINFRAME IMPORT SCRIPT EXAMPLE – DATA MODE
.SESSIONS 1
.RUN FILE LOGON
.IMPORT DATA DDNAME=REPORT
REPEAT *
USING
EMP_NO (INTEGER)
INSERT INTO EMPLOYEE
VALUES
(:EMP_NO);
.QUIT;
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / subbareddy kake
You can use Insert statement for loading one row into
Database
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / tdguy
bteq could be a better option when it comes to loading a
single row. Other utilities are unnecessary as those are
designed for mass loading and unloading.
| Is This Answer Correct ? | 2 Yes | 0 No |
During the Display time, how is the sequence generated by Teradata?
What is the use of virtual processor connectivity in teradata?
What is Join Index in TD and How it works?
The transaction exceeded the maximum number of rowhash locks allowed
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Highlight a few of the advantages that ETL tools have over Teradata.
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
how can we analyze the locks ?
Comment whether bottleneck is an error or not.
what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)
we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.
5 Answers Accenture, Cognizant,
Differentiate database data and data warehouse data?
Teradata 
