I am using the function which is converting my data well however the output is uncompressed. my input file is compressed & after exporting i noticed that my 2g file has ballooned to 10g. I have tried compress statements but they are ignored.
is there anyway I can compress this data when exporting it? The goal is to upload this data onto a flash drive.
Since you appear to be on a Windows platform, you can just use the OS to do the compression. Use Windows Explorer to navigate to the directory, right click on the directory name, select "properties", select "general", select "advanced", check the box to compress the directory contents. That compresses all files in, or newly created in, the directory.
You can also compress a single existing file the same way.
Once a file or directory is compressed, you can look at the properties again to see how much space is actually used on the disk for the file.