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
- 9968 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 |
How do you set the session mode parameters in bteq?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
how do you handle ET and UV errors ?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Diff b/w v2r5 and v2r6 ?
Syntax for case when statement?
What is teradata? Also, list out some of the primary characteristics of teradata.
What is meant by MATCHTAG in multiload utility?
Why is the case expression used in teradata?
List out some of the primary characteristics of teradata.
Why does varchar occupy 2 extra bytes?
What is meant by a Virtual Disk?
Teradata 
