How can we load single row of data into teradata database.
please give me the process.
- 3 Answers
- 9326 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 |
Differentiate database data and data warehouse data?
Explain the term 'foreign key' related to relational database management system?
List out some of the primary characteristics of teradata.
What is partitioned primary index (ppi)?
Highlight the points of differences between the database and user in Teradata.
Why do Hash joins usually perform better than Merge Joins?
what are the file sizes in your project?
What are the various indexes in teradata? How to use them? Why are they preferred?
What are default access rights in teradata? What explicit right can be given to a user?
Why do you get spool space errors? How do trouble-shoot them?
If table have access lock.In the same table write lock is posible or not?
Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?
Teradata 
