|
Home > Archive > IQ Server > October 2005 > Using ASE's BCP utility for taking data out from IQ
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Using ASE's BCP utility for taking data out from IQ
|
|
| Jayeesh 2005-10-27, 8:23 am |
| Hi All,
Does any one know how to take data out from IQ using ASE's
BCP utility.
I add IQ server info in the sql.ini file and try to take the
BCP out from IQ but I got an error.
ASA Error -83: Specified database not found
and the command I used is
bcp iqdb..test_34 out test_34.bcp -UDBA -PSQL -SIQSERVER -c
Is there any other steps which I missed out.
Thanks in advance.
Regards,
-Jayeesh.
| |
| Peter Yu 2005-10-27, 8:23 am |
| Be sure that the server name in sql.ini must be the same as the IQ server
name.
<Jayeesh> ¼¶¼g©ó¶l¥ó·s»D:4343e
1d0.8bd.1681692777@sybase.com...
> Hi All,
>
> Does any one know how to take data out from IQ using ASE's
> BCP utility.
>
> I add IQ server info in the sql.ini file and try to take the
> BCP out from IQ but I got an error.
>
> ASA Error -83: Specified database not found
>
> and the command I used is
>
> bcp iqdb..test_34 out test_34.bcp -UDBA -PSQL -SIQSERVER -c
>
> Is there any other steps which I missed out.
>
> Thanks in advance.
>
> Regards,
> -Jayeesh.
| |
| Jayeesh 2005-10-27, 8:23 am |
| Thanks,
Yes after giving the database name as the server name in the
sql.ini. I'm able to take the BCP out.
Regards,
-Jayeesh.
> Be sure that the server name in sql.ini must be the same
> as the IQ server name.
>
> <Jayeesh>
=bc=b6=bcg=a9=f3=b6l
=a5=f3=b7s=bbD:4343e
1d0.8bd.1681692777@sybase.com...
Hi[color=darkred]
> All, >
> -c >
>
>
|
|
|
|
|