|
|
|
By default, dbdump interprets the query in the command file, converts it to lowercase, and wraps everything that is considered an identifier with double-quotes. If the command file contained functions, dbdump was wrapping the functions in double-quotes resulting in a syntax error.
The dbdump -p command-line switch activates the new query passthru mechanism, which does not perform any major change in the query. When this switch is in use, anything that is not in double-quotes gets converted to lowercase without adding double-quotes.
For example, consider the following statement:
SELECT RTRIM(cm_custnumb),...
The default behavior of dbdump resulted in the following statement, which would cause a syntax error:
select "rtrim" ( "cm_custnumb" ) ,...
Using the new dbdump -p switch results in this statement, which does not cause an error:
select rtrim ( cm_custnumb ) ,...
