All Forums Database
sparan 19 posts Joined 05/06
16 Aug 2006
Bteq Export LImitation???

Hello,i am trying to export 34M records into a flat file of record length 97 using BTEQ export.I am getting error after exporting 24M records and says "output FIle is to large"Please let me know if there is any limitation on bteq export and also any alternative for this.thanks,Sparan

leo.issac 184 posts Joined 07/06
25 Aug 2006

There is an option called RetLimit in BTEQ. You can specify the number of records that bteq can export.The maximum can be 2,147,483,407 records. So if you are exporting beyond the maximum limit I hope you will get the error.

BBR2 96 posts Joined 12/04
27 Aug 2006

I think there is a file limitation of 2 GB.You cannot create a file greater that 2 GB.Vinay

williamdieter 15 posts Joined 03/06
11 Sep 2006

Vinay is correct. A file with 34MM 97 byte rows is about 3GB. If you are exporting to Unix, there is a 2GB limitation within Unix. If you are exporting to Windows or MVS, you should have no problem going over 2GB.

XTUPIE 42 posts Joined 11/05
26 Oct 2006

HiWell divide the file into two parts by using a where clause in the EXPORT SQL and create two individually files.

Regards
Divvy

You must sign in to leave a comment.