Holds information needed for transaction log translation using the DBTools library.
typedef struct a_translate_log { unsigned short version; const char * connectparms; const char * logname; const char * sqlname; const char * encryption_key; const char * logs_dir; p_name userlist; a_sql_uint32 since_time; MSG_CALLBACK confirmrtn; MSG_CALLBACK errorrtn; MSG_CALLBACK msgrtn; MSG_CALLBACK logrtn; MSG_CALLBACK statusrtn; char userlisttype; a_bit_field quiet : 1; a_bit_field remove_rollback : 1; a_bit_field ansi_sql : 1; a_bit_field since_checkpoint : 1; a_bit_field replace : 1; a_bit_field include_trigger_trans : 1; a_bit_field comment_trigger_trans : 1; a_bit_field debug : 1; a_bit_field debug_sql_remote : 1; a_bit_field debug_dump_hex : 1; a_bit_field debug_dump_char : 1; a_bit_field debug_page_offsets : 1; a_bit_field omit_comments : 1; a_bit_field use_hex_offsets : 1; a_bit_field use_relative_offsets : 1; a_bit_field include_audit : 1; a_bit_field chronological_order : 1; a_bit_field force_recovery : 1; a_bit_field include_subsets : 1; a_bit_field force_chaining : 1; a_bit_field generate_reciprocals : 1; a_bit_field match_mode : 1; a_bit_field show_undo : 1; a_bit_field extra_audit : 1; a_sql_uint32 debug_dump_size; a_sql_uint32 recovery_ops; a_sql_uint32 recovery_bytes; const char * include_source_sets; const char * include_destination_sets; const char * include_scan_range; const char * repserver_users; const char * include_tables; const char * include_publications; const char * queueparms; const char * match_pos; a_bit_field leave_output_on_error : 1; } a_translate_log; |
Member | Description | ||||||
---|---|---|---|---|---|---|---|
version | DBTools version number. | ||||||
connectparms |
Parameters needed to connect to the database. They take the form of connection strings, such as the following:
The database server would be started by the connection string START parameter. For example:
A full example connection string including the START parameter:
For a list of connection parameters, see Connection parameters. |
||||||
logname | Name of the transaction log file. If NULL, there is no log. | ||||||
sqlname | Name of the SQL output file. If NULL, then name is based on transaction log file name (-n sets this string). | ||||||
encryption_key | Specify database encryption key (-ek sets string). | ||||||
logs_dir | Transaction logs directory (-m dir sets string); sqlname must be set and connect_parms must be NULL. | ||||||
userlist | A linked list of user names. Equivalent to -u user1,... or -x user1,... Select or omit transactions for listed users. | ||||||
since_time | Output from most recent checkpoint prior to time (-j <time> sets this). The number of minutes since January 1, 0001. | ||||||
confirmrtn | Callback routine for confirming an action. | ||||||
errorrtn | Callback routine for handling an error message. | ||||||
msgrtn | Callback routine for handling an information message. | ||||||
logrtn | Callback routine to write messages only to the log file. | ||||||
statusrtn | Callback routine for handling a status message. | ||||||
userlisttype | Set to DBTRAN_INCLUDE_ALL unless you want to include or exclude a list of users. DBTRAN_INCLUDE_SOME for -u, or DBTRAN_EXCLUDE_SOME for -x. | ||||||
quiet | Set to TRUE to operate without printing messages (-y). | ||||||
remove_rollback | Normally set to TRUE; Set to FALSE if you want to include rollback transactions in output (equivalent to -a). | ||||||
ansi_sql | Set to TRUE if you want to produce ANSI standard SQL transactions (equivalent to -s). | ||||||
since_checkpoint | Set to TRUE if you want output from most recent checkpoint (equivalent to -f). | ||||||
replace | Replace existing SQL file without confirmation (equivalent to -y). | ||||||
include_trigger_trans | Set TRUE to include trigger-generated transactions (equivalent to -g, -sr or -t). | ||||||
comment_trigger_trans | Set TRUE to include trigger-generated transactions as comments (equivalent to -z). | ||||||
debug | Reserved; set to FALSE. | ||||||
debug_sql_remote | Reserved, use FALSE. | ||||||
debug_dump_hex | Reserved, use FALSE. | ||||||
debug_dump_char | Reserved, use FALSE. | ||||||
debug_page_offsets | Reserved, use FALSE. | ||||||
use_hex_offsets | Reserved, use FALSE. | ||||||
use_relative_offsets | Reserved, use FALSE. | ||||||
include_audit | Reserved, use FALSE. | ||||||
chronological_order | Reserved, use FALSE. | ||||||
force_recovery | Reserved, use FALSE. | ||||||
include_subsets | Reserved, use FALSE. | ||||||
force_chaining | Reserved, use FALSE. | ||||||
generate_reciprocals | Reserved, use FALSE. | ||||||
match_mode | Reserved, use FALSE. | ||||||
show_undo | Reserved, use FALSE. | ||||||
debug_dump_size | Reserved, use 0. | ||||||
recovery_ops | Reserved, use 0. | ||||||
recovery_bytes | Reserved, use 0. | ||||||
include_source_sets | Reserved, use NULL. | ||||||
include_destination_sets | Reserved, use NULL. | ||||||
include_scan_range | Reserved, use NULL. | ||||||
repserver_users | Reserved, use NULL. | ||||||
include_tables | Reserved, use NULL. | ||||||
include_publications | Reserved, use NULL. | ||||||
queueparms | Reserved, use NULL. | ||||||
match_pos | Reserved, use NULL. | ||||||
leave_output_on_error | Set to TRUE if you want to leave the generated .SQL file if corruption detected (equivalent to -k) |
The members correspond to features accessible from the dbtran utility.
See the dbtools.h header file for additional comments.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |