dbTalk Databases Forums  

Re: BCP with SYBASE variable defined

comp.databases.sybase comp.databases.sybase


Discuss Re: BCP with SYBASE variable defined in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
ane4ka
 
Posts: n/a

Default Re: BCP with SYBASE variable defined - 07-27-2004 , 06:57 PM






I'm trying to bcp a file from UNIX server to Sybase Database.

I get the following error if I specify SYBASE variable in the Per
script (SYBASE=/opt/sybclient-12.5).

nyrndprd1% /opt/sybclient-12.5/bin/bcp delivery..otc_download i
/home/rndftp/rnd/capsdl/otcstg.upd -SNJDBUDSYB1 -Uautodl -Pautodl -
-t"|"
CSLIB Message: - L0/O0/S0/N131/5/0:
ct_init(): network packet layer: internal net library error: Failed t
open Net-Library localization file
nyrndprd1%

If I do not specify the path for SYBASE, it works fine:
nyrndprd1% bcp delivery..otc_download i
/home/rndftp/rnd/capsdl/otcstg.upd -SNJDBUDSYB1 -Uautodl -Pautodl -
-t"|"
Starting copy...

48 rows copied.
Clock Time (ms.): total = 1 Avg = 0 (48000.00 rows per sec.)


Can you tell me why? And also what should be set up on the server s
that bcp will work with SYBASE variable setup?

Please let me know if you need any additional information.

Thanks in advance
-
ane4k
-----------------------------------------------------------------------
Posted via http://www.webservertalk.co
-----------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message323399.htm


Reply With Quote
  #2  
Old   
Michael Peppler
 
Posts: n/a

Default Re: BCP with SYBASE variable defined - 07-28-2004 , 01:03 AM






On Tue, 27 Jul 2004 23:57:56 +0000, ane4ka wrote:

Quote:
I'm trying to bcp a file from UNIX server to Sybase Database.

I get the following error if I specify SYBASE variable in the Perl
script (SYBASE=/opt/sybclient-12.5).

nyrndprd1% /opt/sybclient-12.5/bin/bcp delivery..otc_download in
/home/rndftp/rnd/capsdl/otcstg.upd -SNJDBUDSYB1 -Uautodl -Pautodl -c
-t"|"
CSLIB Message: - L0/O0/S0/N131/5/0:
ct_init(): network packet layer: internal net library error: Failed to
open Net-Library localization file
nyrndprd1%
This probably means that the /opt/sybclient-12.5/locales/ directory is
incomplete.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html



Reply With Quote
  #3  
Old   
Minoru Aoki
 
Posts: n/a

Default Re: BCP with SYBASE variable defined - 07-30-2004 , 02:02 AM



Hi

Quote:
CSLIB Message: - L0/O0/S0/N131/5/0:
ct_init(): network packet layer: internal net library error: Failed to
open Net-Library localization file
I've ever seen this kind of message on 12.5 when I do not setenv SYBASE_OCS.

Did you set the environment variable, SYBASE_OCS?

it is generally "OCS-12_5", and

$SYBASE/$SYBASE_OCS must point your bcp command directory.

Aoki



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.