Hello,
Am using below IQUNLOAD command on a Linux server and the command isn't executing. Unable to debug since the tool isn't pointing out the error.
Both variants does nothing and the log file has the syntax of IQUNLOAD redirected. Please help on how to find out where the syntax error is.
iqunload –n -c "UID=DBA;PWD=password;DBF=/opt2/sybaseiqdata/xyz.db" –r /tmp/DDL_xyz_schema.sql -v -o /tmp/DDL_xyz_schema.log
iqunload –n -c "UID=DBA;PWD=password;ENG=10.000.000.000_xyz;DBF=/opt2/sybaseiqdata/xyz.db" –r /tmp/DDL_xyz_schema.sql -v -o /tmp/DDL_xyz_schema.log
iqunload –n -c "UID=DBA;PWD=password;DBF=/opt2/sybaseiqdata/xyz.db" –r /tmp/DDL_xyz_schema.sql -v -o /tmp/DDL_xyz_schema.log
=================================OUTPUT : onto screen and in the log file=======================
SAP IQ Unload Utility Version 16.1.24.1129
Usage: iqunload [options] <directory>
@<data> expands <data> from environment variable <data> or file <data>
Options (use specified case, as shown):
-ap <size> set page size of rebuilt database
-au unload and reload schema
-c "keyword=value;..."
supply database connection parameters
-dc redo computed columns
-ms_filename specify filename for new IQ_SYSTEM_MAIN store
-ms_reserve specify reserve for new IQ_SYSTEM_MAIN store
-ms_size specify size for new IQ_SYSTEM_MAIN store
-n no data - unload schema only
-o <file> append output messages to file
-q quiet: do not display messages or show windows
-r <file> path of reload SQL file (default "reload.sql")
-ru <file> path of unprocessed SQL file (default "unprocessed.sql")
-new_startline <command line>
specify command line parameters for reload engine
-t <list> only output the listed tables
-tl <pattern_list>
only output tables matching the given pattern string
-tld <pattern_list>
restrict the data extracted
-ul <pattern_list>
only output users matching the given pattern string
-null_string <string>
specify the null string string to use on extracted ascii character data
-up unload password hashes (not permitted with -no)
-v verbose messages
-y replace existing SQL script file without confirmation
<directory> must be specified as a path meaningful to the database
server unless an external unload is used.