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
- 9993 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 |
List out all forms of LOCKS that are available in Teradata.
What is the basic syntax for teradata select statement?
Explain teradata architecture in detail with a diagram.
What is the opening step in basic teradata query script?
What exactly do you know about catching in teradata?
Highlight the need for Performance Tuning.
What are the design features involved in teradata?
How do you create a table with an existing structure of another table with data and with no data?
What is basic teradata query language?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.
Where is teradata rdbms used?
Teradata 
