When converting (using the SC interface) a sqla9 db to sqla 10, using my 64
bit installation on vista, the load process is generating a "Syntax Error
Near 'Quotes' on Line 3... Please see the sql cited below.

Why is the unload process creating sql that cannot be executed by the load
process?
Thanks,
Doug
p.s. On an xp box, with 32 bit sqla 10, i was able to unload and load
without a problem.


LOAD TABLE "DBA"."groups"
("group_id","short_descr","descr","fiscal_yr_start _dt","first_sched_dt","nbr_wks_in_sched_cycle","fi rst_pay_period_dt","nbr_wks_in_pay_period","std_hr s_ft_emp_per_wk","uploaded_staff_reqd","float_grou p","parent_id","first_shift_of_day","notes","delet ed","display_order","ta_replace_time","nbr_wks_mas ter","extra_fld1","extra_fld2","extra_fld3","extra _fld4","selfsched_nbr_days1","selfsched_nbr_days2" )
FROM 'C:/des/data/resq/clients/prm/unload/217.dat'
FORMAT 'TEXT' QUOTES ON
ORDER OFF ESCAPES ON
CHECK CONSTRAINTS OFF COMPUTES OFF
STRIP OFF DELIMITED BY ','
ENCODING 'cp1252'

Version 10 and earlier dbunload uses FORMAT 'ASCII' QUOTES ON

Version 11 dbunload uses FORMAT 'TEXT' QUOTES ON

So, it is possible you (accidentally?) executed version 11 dbunload,
perhaps by relying on the PATH.

Personally I like using command files with full filespecs...

"%SQLANY10%\win32\dbunload.exe" ...

Breck



On 23 Oct 2009 20:56:03 -0700, "Doug Stone" <doug.stone (AT) res-q (DOT) com>
wrote:

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter (AT) risingroad (DOT) com

Yes, that is possible. Thanks!

"Breck Carter [TeamSybase]" <NOSPAM__breck.carter (AT) gmail (DOT) com> wrote in
message news336e5t7j2p13hrkkbqa24310ccso67t4r (AT) 4ax (DOT) com...