SQL Anywhere database - UNLOAD SELECT

Author

UNLOAD SELECT

Luis Telles

2005-12-20, 3:23 am

hi friends i am migrating data from asa5 to asa 9.
I need to make a file with the next select

unload SELECT nro_libelect, isnull(cod_proy,'200
')
FROM pl_personal to 'c:\query.txt'

I tri to use unload select but to show this error:

syntax error near 'SELECT'

Thanks

Luis Telles

Greg Fenton

2005-12-20, 3:23 am

Luis Telles wrote:
>
> unload SELECT nro_libelect, isnull(cod_proy,'200
')
> FROM pl_personal to 'c:\query.txt'
>
> I tri to use unload select but to show this error:
> syntax error near 'SELECT'

Which version of SQLAnywhere are you trying this on?

I recommend starting up the v5 database on a v9 engine, connecting with
the v9 DBISQL and running the above.

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Luis Telles

2005-12-20, 9:23 am

hi, i am using ASA5..!!!

"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> escribió en el mensaje
news:43a79265@forums
-1-dub...
> Luis Telles wrote:
>
> Which version of SQLAnywhere are you trying this on?
>
> I recommend starting up the v5 database on a v9 engine, connecting with
> the v9 DBISQL and running the above.
>
> Hope this helps,
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/

Dmitri

2005-12-20, 9:23 am

Luis Telles wrote:

> hi, i am using ASA5..!!!

There never existed such an animal as ASA 5 ;). If you mean SA 5, then
the feature you're trying to use didn't exist until ASA7.

Dmitri.

Greg Fenton

2005-12-20, 8:24 pm

Luis Telles wrote:
> hi, i am using ASA5..!!!
>

But you are trying to migrate to ASA 9 (as per your original post).

The "right" way to migrate is to use the newer tools (ASA 9.x) to
connect to the older database and unload.

All of this is documented in the ASA 9.x online documentation:

What's New in SQL Anywhere Studio
Upgrading Software and Databases
- Upgrading Adaptive Server Anywhere

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links