Interview Questions   Tutorials   Discussions   Programs   

Teradata - How can we load single row of data into teradata database? Please give me the process?




612
views
asked mar September 20, 2014 06:37 AM  

How can we load single row of data into teradata database? Please give me the process?


           

1 Answers



 
answered By vishnoiprem   0  
BTEQ orMmultiload(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.


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;
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert