04-29-2010
how can i find the absolute path of the bcp command ??
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I am importing data into a new database using bcp (ASE 11.0) on Solaris 5.7. I keep getting a core dump error when my ksh script attempts to load one table. All other tables load fine. If I load the table directly from the command line without a script the table loads fine.
Does anybody know... (1 Reply)
Discussion started by: gerald_agoi
1 Replies
2. Solaris
After dumping data from an Oracle database running on Solaris into a flat file, we need to run bcp and isql for MS SQL Server on the same Solaris box. Does Microsoft provide some tools that run on Unix?
Thanks for your assistance. (2 Replies)
Discussion started by: tomstone_98
2 Replies
3. UNIX for Advanced & Expert Users
I want to create the format file for bcp in a file to the table.
My Versions are:
Unix: Sun OS,
DB: Sybase.
How can i create the format file.
Is there any way to create the format by bcp command
or some system sp.
Please help. (3 Replies)
Discussion started by: Arunprasad
3 Replies
4. UNIX and Linux Applications
To begin:
I use Linux
The Problem:
I need bcp functionality for scripts. Perl modules, such as Sybase:xfer, require ctlib which comes with Sybase Open Client. Talking with Sybase sales
reps is an exercise in futility and hate. They know absolutely nothing about their own products and will... (0 Replies)
Discussion started by: Bubnoff
0 Replies
5. Shell Programming and Scripting
Hi All,
I am trying to bcp in data file into database. now there is bcp command available in unix and another perl module Sybase::BCP is also available.
Can anyone please let me know if there is any limitations of bcp command in unix. whichever is good to use? (1 Reply)
Discussion started by: Deei
1 Replies
6. Shell Programming and Scripting
I am trying to bcp in using sybase::bcp perl module. I can find we can give user, pwd and server name in the parameters.
How can I give database and table name? (1 Reply)
Discussion started by: Deei
1 Replies
7. Shell Programming and Scripting
hi all,
Getting error while working on sybase::bcp as below,
DB-Library error:
Attempt to convert data stopped by syntax error in source field.
Code is like,
my $bcp_files = new Sybase::BCP $usr, $pass, $server;
---------- Post updated at 02:05 AM ---------- Previous update... (0 Replies)
Discussion started by: Deei
0 Replies
8. Shell Programming and Scripting
Hi
I am using SQSH to construct 10-20 bcp commands that I would like to execute. I can write all to file and open and do a for loop in the file.
My question is if there is some way I can skip the file part and somehow pipe out the resulting dataset from SQSH and execute those directly?
My... (1 Reply)
Discussion started by: bicm_mike
1 Replies
9. UNIX for Dummies Questions & Answers
Hello,
I am facing a typical problem in my code . If I run bcp alone it is working fine if I run BCP with cat it is not working . Not able to find where the error is occurring in cat . Can you please help
bcp ${_DBName}..logfile in ${_currdate} -f$PANEL_HOME/format/logfile.fmt -Q -U$_UserId... (11 Replies)
Discussion started by: arunkumar_mca
11 Replies
10. Shell Programming and Scripting
Hi All,
I had an issue in executing bcp command to connect to Sybase from Unix script for uploading the data from file to table.
I have a file called vrs_temp.txt (with two columns):
22055;20181001
21088;20181001
93840;20181001
30990;20181001
50990;20181001
50950;20181001Created a... (4 Replies)
Discussion started by: Suresh
4 Replies
LEARN ABOUT OPENSOLARIS
pwd
pwd(1T) Tcl Built-In Commands pwd(1T)
__________________________________________________________________________________________________________________________________________________
NAME
pwd - Return the absolute path of the current working directory
SYNOPSIS
pwd
_________________________________________________________________
DESCRIPTION
Returns the absolute path name of the current working directory.
EXAMPLE
Sometimes it is useful to change to a known directory when running some external command using exec, but it is important to keep the appli-
cation usually running in the directory that it was started in (unless the user specifies otherwise) since that minimises user confusion.
The way to do this is to save the current directory while the external command is being run:
set tarFile [file normalize somefile.tar]
set savedDir [pwd]
cd /tmp
exec tar -xf $tarFile
cd $savedDir
SEE ALSO
file(1T), cd(1T), glob(1T), filename(1T)
KEYWORDS
working directory
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+--------------------+-----------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+--------------------+-----------------+
|Availability | SUNWTcl |
+--------------------+-----------------+
|Interface Stability | Uncommitted |
+--------------------+-----------------+
NOTES
Source for Tcl is available on http://opensolaris.org.
Tcl pwd(1T)