SQL Anywhere database replication - dbxtract and Syntax error near 'if'

Author

dbxtract and Syntax error near 'if'

Oliver Schulze L.

2006-02-06, 7:23 am

Hi,
I have ASA 6.0.4 on WinXP and recently and started getting this
error when extracting a remote DB.

The command I use is this:
dbxtract.exe -n -an db2 -v -f -j 2 -c " eng=mydb;uid=dba;pwd
=sql" user2

The error I get is this:
....
Writing option settings
Creating userids and granting user permissions
Creating userids and granting user permissions
Creating user-defined types
Installing user-defined classes
Granting user memberships
Creating external servers
Creating tables
Adding foreign key and index definitions
Creating functions
Creating views
Creating views
Creating user messages
Creating procedures
***** SQL error: Syntax error near 'if'

If I do a unload, create the new .db and later reload the reload.sql
script using dbisql, all works fine.
So, the problem appear when I pass the -an switch to dbxtract.

How can I solve this issue?

Many thanks
Oliver

Reg Domaratzki $iAnywhere Solutions$

2006-02-06, 9:23 am

I can see a whole bunch of fixes to dbunload -an/-ar/-ac that were never
fixed in v604, since they were discovered after v604 was End-of-lifed.

Do you have any comments (single or multi-line) in your stored procedures
that include "go" in the comment? This could be causing your problem, and
was never fixed in v604.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

"Oliver Schulze L." <news.oliver@samera.com.py> wrote in message
news:43e731a8$1@foru
ms-2-dub...
> Hi,
> I have ASA 6.0.4 on WinXP and recently and started getting this
> error when extracting a remote DB.
>
> The command I use is this:
> dbxtract.exe -n -an db2 -v -f -j 2 -c " eng=mydb;uid=dba;pwd
=sql" user2
>
> The error I get is this:
> ...
> Writing option settings
> Creating userids and granting user permissions
> Creating userids and granting user permissions
> Creating user-defined types
> Installing user-defined classes
> Granting user memberships
> Creating external servers
> Creating tables
> Adding foreign key and index definitions
> Creating functions
> Creating views
> Creating views
> Creating user messages
> Creating procedures
> ***** SQL error: Syntax error near 'if'
>
> If I do a unload, create the new .db and later reload the reload.sql
> script using dbisql, all works fine.
> So, the problem appear when I pass the -an switch to dbxtract.
>
> How can I solve this issue?
>
> Many thanks
> Oliver

Oliver Schulze L.

2006-02-10, 9:23 am

Hi Reg,
thanks for the reply.

I never use 'go' in my sp, but I do have many commented code.
I have if, call, for, execute, grant, etc commented out in
multi-line comments.

I will check the updates that I have done to the sp in the last
couple of week and delete the comments.
Thats the time frame where the error showed.

Many thanks
Oliver

Reg Domaratzki (iAnywhere Solutions) wrote:
> I can see a whole bunch of fixes to dbunload -an/-ar/-ac that were never
> fixed in v604, since they were discovered after v604 was End-of-lifed.
>
> Do you have any comments (single or multi-line) in your stored procedures
> that include "go" in the comment? This could be causing your problem, and
> was never fixed in v604.
>

Sponsored Links