Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Exporting large tables
- Thread starter PLMAAT
- Start date
RogerCruse
MIS
I can't help you too much but you should be able to use Fast Export. However, I've never managed to get this to work via Windows.
It works fine via our mainframe connection.
I'll be interested if you have more success...
Roger...
It works fine via our mainframe connection.
I'll be interested if you have more success...
Roger...
You can use BTEQ or Fastexport if it is done on a server. Since you are mentioning Queryman, I think you are working on a desktop? If so, I don't think you will be able to export something as big as this to your desktop. Be aware that you have your limitations of memory on your desktop, which will be probable exceeded by an export of 3 million rows with 60 fields. Besides, such files are hardly useful except for exchanging it to other systems?
- Status