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
- 9886 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 |
Where we use PPI in real time??? What is the disadvantages of PPI?
How to select first n records in teradata?
Why Fload doesn’t support multiset table?
What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .
what is the difference between filter and router transmissions
What is meant by a Least Cost Plan?
what is identity columns in TD?
What is partitioned primary index (ppi)?
Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M
Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?
what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)
How can you track login parameters of users in teradata?
Teradata 
