Loading a table from multiple files using fastload.

Tools
N/A

Loading a table from multiple files using fastload.

Hi Guys,

I need to know how to load a table using multiple files in a single script using fastload.
If you know any link or thread can also help.

Thanks in advance,
Kapil
2 REPLIES
N/A

Re: Loading a table from multiple files using fastload.

Depends on your environment.
On Unix/ Linux, cat the files together by:

cat infile*.dat >>newfile.dat

(will take infile1.dat, infile2.dat, etc and put them all in newfile.dat.)

On mainframe, use jcl to specify all the input as multipart files, so fastload thinks it is just reading a single file.

On Windows, you can use cygwin (available free - just google it) to use Unix/ Linux commands, so use the above method.
Or you can use DOS copy command in a DOS prompt or .bat file.
For this,

copy infile*.dat newfile.dat

If the filenames are such that you cannot use a wildcard, use:

copy afile.dat+anofile.dat+yetanofile.dat newfile.dat

HTH
N/A

Re: Loading a table from multiple files using fastload.

Thanks Jimm gr8 help ,appreciate it man...
Let me try with it and get back to you ,if nay prob comes.

Thanks,
Kapil