|
|
Sponsored Content
Operating Systems
Solaris
bcp and isql for MS SQL Server on Solaris?
Post 302237941 by reborg on Thursday 18th of September 2008 05:25:41 PM
|
|
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. Shell Programming and Scripting
let me save everyone the pain that it caused me.
This is all free. And make sure it is in this order
1) make sure you have the latest version of perl installed
2) make sure you have NET:aemon installed
3) make sure you have RPC::PlServer & PlClient (the bundle has both)
4) make sure... (3 Replies)
Discussion started by: Optimus_P
3 Replies
3. Shell Programming and Scripting
Hello,
my problem is, that I want to send an SQL-Statement via ksh-Shell to an MS-SQL-Database based on SQL Server 2005. I want to receive a file, which can be used for further actions on UNIX (Sun OS 5.9). ODBCUnix and JDBC and FreeTDS are not allowed. Does anybody have a suggestion?
Br,... (0 Replies)
Discussion started by: usagi67
0 Replies
4. Shell Programming and Scripting
I've got:
isql -U $USERID -S $SERVER -D $DATABASE -i inputfile.sql -o outputfile.txt
in inputfile I have:
go
sql#1
go
sql#2
go
sql#3
go
I also tried without "go" and with";" instead which did not work
SQL statements will work if I paste them directly into the script and use EOF
... (0 Replies)
Discussion started by: Cailet
0 Replies
5. Shell Programming and Scripting
Hi,
I am using isql and putting the output in a file in a shell script in Linux.
However in my output i am getting the banner and a SQL prompt(at the start and the end of query output)
+---------------------------------------+
| Connected! |
| ... (6 Replies)
Discussion started by: lifzgud
6 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,
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
8. 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
9. Windows & DOS: Issues & Discussions
New to using sql server and unix, but say I have here /home/foo/file.txt
Can I use some kind of process to push that .txt into a sql server?
Or
Is there a sql server utility that can be configured to find a unix box and go into /home/foo/file.txt and slurp it up:)
Or is there any PC and... (5 Replies)
Discussion started by: sas
5 Replies
10. Shell Programming and Scripting
need to create shell script to read the table's name from file and connect SQL SERVER using isql (odbcunix)
i 'm able connect to database with below command line syntex but i could not get working in shell script with SQL and storing the row count in variable.
isql -v DSN USERNAME PASSWD
... (6 Replies)
Discussion started by: pimmit22043
6 Replies
LEARN ABOUT DEBIAN
sql::reservedwords::sqlserver
SQL::ReservedWords::SQLServer(3pm) User Contributed Perl Documentation SQL::ReservedWords::SQLServer(3pm) NAME
SQL::ReservedWords::SQLServer - Reserved SQL words by SQL Server SYNOPSIS
if ( SQL::ReservedWords::SQLServer->is_reserved( $word ) ) { print "$word is a reserved SQL Server word!"; } DESCRIPTION
Determine if words are reserved by SQL Server. METHODS
is_reserved( $word ) Returns a boolean indicating if $word is reserved by SQL Server 7, 2000 or 2005. is_reserved_by_sqlserver7( $word ) Returns a boolean indicating if $word is reserved by SQL Server 7. is_reserved_by_sqlserver2000( $word ) Returns a boolean indicating if $word is reserved by SQL Server 2000. is_reserved_by_sqlserver2005( $word ) Returns a boolean indicating if $word is reserved by SQL Server 2005. reserved_by( $word ) Returns a list with SQL Server versions that reserves $word. words Returns a list with all reserved words. EXPORTS
Nothing by default. Following subroutines can be exported: is_reserved is_reserved_by_sqlserver7 is_reserved_by_sqlserver2000 is_reserved_by_sqlserver2005 reserved_by words SEE ALSO
http://msdn2.microsoft.com/en-us/library/ms130214.aspx AUTHOR
Christian Hansen "chansen@cpan.org" COPYRIGHT
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.8.8 2008-03-28 SQL::ReservedWords::SQLServer(3pm)