Hi, I wonder what could be the need. If you need to import from a single IXF file then create a single IXF file from source.

Secure Moving the University to Microsoft Outlook, a single email and calendaring system, will increase the security of communications across Penn State. With a full suite of integrated tools available on any device, Office 365 helps you to stay organized while saving time. Office mail 365. Productive The wide range of Office 365 tools make it easy to boost productivity in the classroom and workplace. With access to the same professional applications used outside of Penn State, students can prepare for the future by developing the digital fluency skills needed for successful careers. Penn Staters can create stunning presentations, documents, and spreadsheets using PowerPoint, Word, and Excel or share notes and gather project data using OneNote and Flow.

DB2 is smart enough to load data in a smart way for you. If there are multiple IXF files then it's a normal Db behaviour to get all ixf files loaded in serial order as data may not be appropriate from different sources.

If at all all data extracted from source is as per the destination table specification and that you have no choice than to extract multiple times, then better extract it in del format from all sorces, make a one file and then load from this single file. You can create a smart script to pickup up multiple ixf files and load in your db2 database. Choice is yours.

Have you ever tried cursore load new feature, egere you can directly load data into a remote db2 database? Cheers, Vijay. Hi, try this in this format, it could work. IMPORT from /appldata/dwins25p/cryr3_1/DART0002/TS1116T2.IXF, /appldata/dwins25p/cryr3_1/DART0003/TS1116T2.IXF, /appldata/dwins25p/cryr3_1/DART0004/TS1116T2.IXF, /appldata/dwins25p/cryr3_1/DART0005/TS1116T2.IXF of IXF Method P (1,2,3,4,5,6,7,8,9,10) messages.and so on. We usually give multiple Input files for load or import for partitioned environment. I have not tried that in ESE setup and but u can give and try and let me know if it works. Cheers Pramod.

I would like to port my SQL DB2 - java application to BlueMix. Current DB2 tables contain XML and CLOB columns and the export has been done in IXF format with a command like. Mar 29, 2018 - In this example, some of the data in the EMP table will be exported to an IXF output file, and then that data will be used to create a new table.