title: Exporting Data - IBM Data Studio DB2
body: <p>I am trying to export a large query from a DB2 database to a text file on my desktop using IBM Data Studio and I can't seem to get anything to work.  When I run the query and right click on the results tab->Export->All Results it only gives me the first 500 records.  This table is going to be in the range of 15 MM records so I can't just change the display settings to allow  it to display that many records.  I cannot use the unload utility because it won't let me save the file to my desktop.  Any ideas?</p>