This command downloads the specified installed file or function.
DOWNLOAD FILE [[schema/]alias] filename
This is an example:
public void download_file_examples() { String stmt1 = "DOWNLOAD file uploadfile/'abc.txt' 'd:\\download-abc.txt'"; String stmt2 = "DOWNLOAD file uploadfile/'odbcng.zip' 'd:\\download-uploadfile-odbcng.zip'"; String stmt3 = "DOWNLOAD file 'odbcng.tar.gz' 'd:\\download-public-odbcng.zip'"; try { Statement s = conn_.createStatement(); s.executeUpdate(stmt1); s.executeUpdate(stmt2); s.executeUpdate(stmt3); s.close(); } catch (Exception e) { fail(e.getMessage()); } }