db2 temp table

Operation:1. Export data from DB2 to TXT2. Change the delimiter in the file to ":"3. Create a new table in hive (you need to set a delimiter when building a table)4. Import data--------1. Export data from DB2 to TXTDb2-x "Select Col1,col2,col3 from tbl_name where xxx with ur" >filename.txt2. Change the delimiter in the

I. Dynamic execution of SQLPREPARE from ' Delete from Test ' ; EXECUTE S1;Second, using cursorsDECLARE CURSOR for SELECT from FJDC. V_i_dg_dm_zy_wl_zbhz_attr T; OPEN V_cursor; FETCH into V_deletesql,v_insertsql; CLOSE V_cursor;Third, while loop while true -do expression ENDwhile;Iv. DB2 query table data, generate dynamic SQL, and execute1 CREATE PROCEDURE" TEST". " TEST "()2 BEGIN3

Tags: io ar art SP on c ad Size EF--Buffer poolCREATE Bufferpool Emp_buf_poolIMMEDIATE All DbpartitionnumsSIZE 250Numblockpages 0PAGESIZE K;--Temporary table spaceCREATE Temporary tablespace emp_tmpIn DATABASE PARTITION GROUP ibmtempgroupPAGESIZE 32KMANAGED by DATABASEUSING (File '/home/db2inst1/db2inst1/node0000/ng2_app8/t0000000/emp_tmp/hefei.dat ' 2G)Extentsize 32Prefetchsize AUTOMATIC Bufferpool Emp_buf_poolOVERHEAD 7.50Transferrate 0.06DROPPED