10 More Discussions You Might Find Interesting
1. 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
2. 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
3. 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
4. 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
5. Shell Programming and Scripting
Hi,
When i execute a script in unix, the result i got is ::
./purgeErrors.ksh: bcp: not found
What is the meaning of that output ?
--- Aditya (9 Replies)
Discussion started by: chaditya
9 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 Guys,
I wonder if possible to execute a Db2 commands within a perl scripts without installing or invoking the DBI modules. I have a script that is written in kron shell and it looks like :
DB=`db2 list db directory | egrep "Database alias|Directory entry type"|awk '{printf $0 ;... (0 Replies)
Discussion started by: arizah
0 Replies
8. 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
9. Linux
Hi all,
I am working on USB data monitoring on Fedora Core 9. Kernel 2.6.25 has a built-in module (the one that isn't loadable, but compiles and links statically with the kernel during compilation) to snoop USB data. It is in <kernel_source_code>/drivers/usb/mon/.
I need to know if I can... (0 Replies)
Discussion started by: anitemp
0 Replies
10. 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