https://community.qlik.com/t5/Talend-Studio/DB-DB2-AS400-Bulk-insert/m-p/2244912#M30922 Hi there, <BR /> <BR />I have to insert millions of records from table A into table B (same server). It take ages to copy that data via tDbOutput. Is there a way to do bulk insert for As400? <BR /> <BR />Thanks a lot. <BR /> <BR />pepito <BR /> <BR />tha Sat, 16 Nov 2024 04:40:17 GMT Anonymous 2024-11-16T04:40:17Z https://community.qlik.com/t5/Talend-Studio/DB-DB2-AS400-Bulk-insert/m-p/2244912#M30922 Hi there, <BR /> <BR />I have to insert millions of records from table A into table B (same server). It take ages to copy that data via tDbOutput. Is there a way to do bulk insert for As400? <BR /> <BR />Thanks a lot. <BR /> <BR />pepito <BR /> <BR />tha Sat, 16 Nov 2024 04:40:17 GMT https://community.qlik.com/t5/Talend-Studio/DB-DB2-AS400-Bulk-insert/m-p/2244912#M30922 Anonymous 2024-11-16T04:40:17Z https://community.qlik.com/t5/Talend-Studio/DB-DB2-AS400-Bulk-insert/m-p/2244913#M30923 the quickest way is to build dbLink (if you do not have access to B from A)<BR />then run a query.<BR />for me there is no bulk in db2400 only in db2. Mon, 16 Sep 2019 08:21:03 GMT https://community.qlik.com/t5/Talend-Studio/DB-DB2-AS400-Bulk-insert/m-p/2244913#M30923 fdenis 2019-09-16T08:21:03Z