Hi,

I'm using SQL Anywhere 9.0.2.3546. I do not want "COMMENT TO PRESERVE
FORMAT" statements in "reload.sql" created from dbunload because I do
impact analysis by text-searching "reload.sql".

I have tried to execute the following, but subsequent dbunload
executions still contain the "Comment to Preserve Format" statements :

SET OPTION "PUBLIC"."Preserve_source_format" = 'Off'
go

It seems there is a corresponding database property db_property (
'PreserveSource' ). This property remains 'On' even after setting
option "Preserve_source_format" to off.

I suspect I would have what I need if property 'PreserveSource" were
'Off', but the only way I can find to set it off (option
"Preserve_source_format") does not seem to do the trick.

Thanks in advance for any help!

After setting the preserve_source_format database option to 'off', you will need
to cause the preserved source to be discarded for each procedure. This can be
done by executing:
comment to preserve format on procedure owner.procname is null
for each procedure. You could do this for all procedures in the database using a
FOR statement and EXECUTE IMMEDIATE. Of course, by doing so you will lose the
ability to view the procedures as they were originally formatted when using
Sybase Central.

Alternatively, you could just post-process the reload.sql file using a Perl or
Python script to strip out the COMMENT statements.

SQL Anywhere Developer Community:
http://www.sybase.com/developer/libr...ere-techcorner


SQL Anywhere Blog Center: http://www.sybase.com/sqlanyblogs




EJ wrote: