How can we load single row of data into teradata database.
please give me the process.

Answers were Sorted based on User's Feedback



How can we load single row of data into teradata database. please give me the process...

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

How can we load single row of data into teradata database. please give me the process...

Answer / subbareddy kake

You can use Insert statement for loading one row into
Database

Is This Answer Correct ?    2 Yes 0 No

How can we load single row of data into teradata database. please give me the process...

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

Post New Answer

More Teradata Interview Questions

What is the function of parser component in teradata?

0 Answers  


If a Node is busy what are the steps you can take to avoid ?

0 Answers   Teradata,


Why FLOAD does not support multiset tables??

3 Answers   TCS, Tesco,


What do you mean by tpt in teradata?

0 Answers  


What is database exceptions in teradata?

0 Answers  






Difference between multiload and tpump?

0 Answers  


What are the various reporting tools in the market?

0 Answers  


Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance

6 Answers   Cap Gemini,


Explain about Skew Factor?

6 Answers   TCS,


What is the difference between union and union all in teradata?

0 Answers  


how many modules are there in telecome domain?how to explain the architecture?

0 Answers  


Highlight the advantages of PPI(Partition Primary Index).

0 Answers  


Categories