Answer Posted / 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;

What are the various reporting tools in the market?

841

---

Highlight the limitations of TPUMP Utility.

809

---

What is the meaning of Caching in Teradata?

896

---

Difference between stored procedure and macro?

932

---

Difference between inner join and outer join?

801

---

Discuss the advantages of using partitioned primary index in a query?

746

---

What are normalization, first normal form, second normal form and third normal form?

846

---

Give a justifiable reason why Multi-load supports NUSI instead of USI.

912

---

How to select first n records in teradata?

834

---

Explain the advantages of partitioned primary index in a query?

784

---

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3297

---

Describe the between keyword in teradata?

830

---

What is stored procedure in teradata?

797

---

Can you connect multiload from ab initio?

924

---

What is meant by a Channel Driver?

880

---