Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

BCP

5 posts in Windows NT Last posting was on 2000-01-30 22:47:37.0Z
David Ma Posted on 2000-01-26 03:31:37.0Z
From: "David Ma" <changqing.ma@usa.net>
Subject: BCP
Date: Wed, 26 Jan 2000 16:31:37 +1300
Lines: 14
X-Newsreader: Microsoft Outlook Express 4.72.2120.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2120.0
Message-ID: <INt8P36Z$GA.303@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: ou075211.otago.ac.nz 139.80.75.211
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2637
Article PK: 1090087

I am a new user of sybase. I am using BCP (ASE12 on NT4.o Server SP5) to
input a text file to a table (tblTemperature) in database (Climate) with
following command:
bcp climate..tblTemperature in temp.txt -c -t, -r\n


I get an error message:
incorrect syntax near '.'

Thanks for your help

David


Mark A. Parsons Posted on 2000-01-26 05:16:05.0Z
Message-ID: <388E8315.CBCB1AB@compuserve.com>
Date: Wed, 26 Jan 2000 18:16:05 +1300
From: "Mark A. Parsons" <iron_horse@compuserve.com>
Organization: Pegasys Ltd
X-Mailer: Mozilla 4.61 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: BCP
References: <INt8P36Z$GA.303@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 15
NNTP-Posting-Host: p354.ipa1-n8-16.iconz.net.nz 210.48.25.98
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2636
Article PK: 1090082


David Ma wrote:
>
> I am a new user of sybase. I am using BCP (ASE12 on NT4.o Server SP5) to
> input a text file to a table (tblTemperature) in database (Climate) with
> following command:
> bcp climate..tblTemperature in temp.txt -c -t, -r\n
>
> I get an error message:
> incorrect syntax near '.'

A couple things ...

1) try putting your delimiters (, and \n) inside quotes to see if this
has a difference for your particular OS.

2) doublecheck the format of the arguments for bcp in ... what? ... an
NT DOS-command line environment?


--
Mark Parsons
Pegasys Ltd


David Ma Posted on 2000-01-27 00:45:30.0Z
From: "David Ma" <changqing.ma@usa.net>
References: <INt8P36Z$GA.303@forums.sybase.com> <388E8315.CBCB1AB@compuserve.com>
Subject: Re: BCP
Date: Thu, 27 Jan 2000 13:45:30 +1300
Lines: 38
X-Newsreader: Microsoft Outlook Express 4.72.2120.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2120.0
Message-ID: <ADuYG$Fa$GA.184@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: ou075211.otago.ac.nz 139.80.75.211
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2629
Article PK: 1090079


Mark A. Parsons wrote in message <388E8315.CBCB1AB@compuserve.com>...
>David Ma wrote:
>>
>> I am a new user of sybase. I am using BCP (ASE12 on NT4.o Server SP5) to
>> input a text file to a table (tblTemperature) in database (Climate) with
>> following command:
>> bcp climate..tblTemperature in temp.txt -c -t, -r\n
>>
>> I get an error message:
>> incorrect syntax near '.'
>
>A couple things ...
>
>1) try putting your delimiters (, and \n) inside quotes to see if this
>has a difference for your particular OS.
>
>2) doublecheck the format of the arguments for bcp in ... what? ... an
>NT DOS-command line environment?
>
>
>--
>Mark Parsons
>Pegasys Ltd

Thanks for help.

I still got the same problem. Even I write the fellow command:
bcp climate..tblTemperature out my_out -c

I got the same error message:
incorrect syntax near '.'

thanks

David


Mark A. Parsons Posted on 2000-01-27 06:45:42.0Z
Message-ID: <388FE996.F041CC19@compuserve.com>
Date: Thu, 27 Jan 2000 19:45:42 +1300
From: "Mark A. Parsons" <iron_horse@compuserve.com>
Organization: Pegasys Ltd
X-Mailer: Mozilla 4.61 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: BCP
References: <INt8P36Z$GA.303@forums.sybase.com> <388E8315.CBCB1AB@compuserve.com> <ADuYG$Fa$GA.184@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 54
NNTP-Posting-Host: p281.ipa1-n8-16.iconz.net.nz 210.48.25.25
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2627
Article PK: 1090075


> Thanks for help.
>
> I still got the same problem. Even I write the fellow command:
> bcp climate..tblTemperature out my_out -c
>
> I got the same error message:
> incorrect syntax near '.'

OK, let's see here ... your format (use) of the bcp command looks fine
... so when all else fails ... step back and look at the bigger picture
...

If we think about it ... your error message looks more like an OS error
and not a 'bcp' error.

What happens if you type 'bcp' all by itself on the command line and
then hit <Enter>?

What happens if you type 'bcp -v' at the command line and then hit
<Enter>?

If both of these give errors ... and especially if the 'bcp -v' doesn't
give you a description of the version of 'bcp' ... then we have an OS
problem.

What kind of OS problem?

The OS doesn't know where to find the 'bcp' command ... so you have to
define this in the PATH environment variable. Check your documentation
for specifics ... but I believe the PATH variable should include
pointers to $SYBASE\bin and $SYBASE\ddl (or something similar). You
might as well verify that your other OS environment variables are also
set properly, e.g., SYBASE (check your documentation for specifics ...
you're either looking for the 'Utilities' manual and/or the
'Installation' manual).

See if this gets you closer.

----------------------

On the same lines ...

Can you get 'isql' to run ok from the command line?

If not, this is because of the same reason ('bcp' and 'isql' are
typically in the same directory so they would use the same pointer in
the PATH variable) I mentioned above ... so look into setting up the
PATH variable.

If you *can* get 'isql' to run (no errors) but not 'bcp' (errors) ...
there may be an issue of the 'bcp' executable not existing in the proper
directory. The quickest way to fix this would be to do a new install of
the Sybase client code. In this case I'd suggest you talk with the
person who installed your version of Sybase and have them look into
getting all of the executables/binaries installed.


--
Mark Parsons
Pegasys Ltd


David Ma Posted on 2000-01-30 22:47:37.0Z
From: "David Ma" <changqing.ma@usa.net>
References: <INt8P36Z$GA.303@forums.sybase.com> <388E8315.CBCB1AB@compuserve.com> <ADuYG$Fa$GA.184@forums.sybase.com> <388FE996.F041CC19@compuserve.com>
Subject: Re: BCP
Date: Mon, 31 Jan 2000 11:47:37 +1300
Lines: 73
X-Newsreader: Microsoft Outlook Express 4.72.2120.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2120.0
Message-ID: <ky8d8P3a$GA.223@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: ou075211.otago.ac.nz 139.80.75.211
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2609
Article PK: 1090062


>OK, let's see here ... your format (use) of the bcp command looks fine
>... so when all else fails ... step back and look at the bigger picture
>...
>
>If we think about it ... your error message looks more like an OS error
>and not a 'bcp' error.
>
>What happens if you type 'bcp' all by itself on the command line and
>then hit <Enter>?
>
>What happens if you type 'bcp -v' at the command line and then hit
><Enter>?
>
>If both of these give errors ... and especially if the 'bcp -v' doesn't
>give you a description of the version of 'bcp' ... then we have an OS
>problem.
>
>What kind of OS problem?
>
>The OS doesn't know where to find the 'bcp' command ... so you have to
>define this in the PATH environment variable. Check your documentation
>for specifics ... but I believe the PATH variable should include
>pointers to $SYBASE\bin and $SYBASE\ddl (or something similar). You
>might as well verify that your other OS environment variables are also
>set properly, e.g., SYBASE (check your documentation for specifics ...
>you're either looking for the 'Utilities' manual and/or the
>'Installation' manual).
>
>See if this gets you closer.
>
>----------------------
>
>On the same lines ...
>
>Can you get 'isql' to run ok from the command line?
>
>If not, this is because of the same reason ('bcp' and 'isql' are
>typically in the same directory so they would use the same pointer in
>the PATH variable) I mentioned above ... so look into setting up the
>PATH variable.
>
>If you *can* get 'isql' to run (no errors) but not 'bcp' (errors) ...
>there may be an issue of the 'bcp' executable not existing in the proper
>directory. The quickest way to fix this would be to do a new install of
>the Sybase client code. In this case I'd suggest you talk with the
>person who installed your version of Sybase and have them look into
>getting all of the executables/binaries installed.
>
>
>--
>Mark Parsons
>Pegasys Ltd

bcp -v does not works. I have checked the path. it is fine. also I have
reinstall the client, The error message come again.

I install ASE12 into NT4.0 workstation SP5 computer without license
information, I got an error message:

The dynamic link library CLUSAPI.dll could not be found in the specified
path c:\sybase\OCS-12_0\bin; c:\WINNT\system32; c:\WINNT\system; c:\winnt;
c:\sybase\OCS-12_0\dll............

When I install client on the same mechine, I got the same message.

I want to use bcp uility to input data into a databse. I can not use bcp
but I can use isql uility. Does I must have a license to use bcp function.

Thanks