07-28-2015
Hi RudiC,
As mentioned earlier, script is throwing an error from the first line of output from the SQL spool file, which is
TD_Tpump_InsertAs you suggested, I have removed the space before EOF and tried it, but still it fails with the same error.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I am trying to run a shell script using the ./<ScriptName> command, but the server returns an error bash: ./Script1.sh: Permission denied
What variable do I need to set to avoid this? (4 Replies)
Discussion started by: igandu
4 Replies
2. Shell Programming and Scripting
Hi All,
When I am trying to execute the below shell script I got this error message.
script
==========
#!/bin/bash
/usr/java/jdk1.5.0_10/bin/java - classpath /var/lib/asterisk/agi-bin/mysql-connector-java-3.0.15-ga-bin.jar/:
/var/lib/asterisk/agi-bin/jarfiles:... (4 Replies)
Discussion started by: ajayyaduwanshi
4 Replies
3. Shell Programming and Scripting
Hi Gurus,
I've a find command that gets the list of files from a source directory where the extension is not html, xml, jsp, shtml or htaccess. The below find command runs fine from the command prompt or in a shell script. I need to eventually run it in a PERL script and am getting the... (5 Replies)
Discussion started by: voorkey
5 Replies
4. Shell Programming and Scripting
Hi,
I have following shell script code :
------------------------------------------------------------------
#!/bin/bash
SCRIPTS_DIR="/scriptsDir1"
# tables login/password
APIL_USER="uname/pswd"
I2_USER="uname/pswd"
# Database
DB="db1"
cd "$SCRIPTS_DIR/scriptsDir2"
sqlplus... (2 Replies)
Discussion started by: Chaitrali
2 Replies
5. Linux
Hi,
I have following shell script code :
------------------------------------------------------------------
#!/bin/bash
SCRIPTS_DIR="/scriptsDir1"
# tables login/password
APIL_USER="uname/pswd"
I2_USER="uname/pswd"
# Database
DB="db1"
cd "$SCRIPTS_DIR/scriptsDir2"
sqlplus... (1 Reply)
Discussion started by: Chaitrali
1 Replies
6. Shell Programming and Scripting
Hi,
I have situation where i need to automate transferring 10000+ files using sftp.
while read line
do
if ; then
echo "-mput /home/student/Desktop/folder/$line/* /cygdrive/e/folder/$line/">>sftpCommand.txt
fi
done< files.txt
sftp -b sftpCommand.txt stu@192.168.2.1
The above... (1 Reply)
Discussion started by: noobrobot
1 Replies
7. Shell Programming and Scripting
Guys,
when i am executing the following script I am getting following error.
-bash: test.sh: command not found
$ test.sh -- script name
#! /bin/bash
echo " Job started........"
CURRENTDIR=`pwd`
exit 0
thanks
Please view this link: How to use ... tags (2 Replies)
Discussion started by: skatpally
2 Replies
8. Shell Programming and Scripting
Platform : Solaris 10, RHEL 5.4, OEL 6
I've noticed that some of my colleagues execute scripts by typing sh before the script name
sh myscript.shI always execute a script by typing the script name and typing enter provided PATH variable has . (current directory) in it
myscript.sh (and... (1 Reply)
Discussion started by: John K
1 Replies
9. Shell Programming and Scripting
hi all,
i have a unix script where i am calling a database procedure from it. while executing the procedure i am getting an error:
but when i tried to call the same procedure manually then it ran successfully, i goggled this issue and found timezone.dat file missing at... (0 Replies)
Discussion started by: lovelysethii
0 Replies
10. Shell Programming and Scripting
Hi All,
I wanted to know why we use the '-f' option while executing script.
in my case...
abcd.sh -f any_evts 02 2014
abcd = Scriptname
-f = dont know
any_evts = Some file or string
02= month
2014 = year
So in above pleas ehelp to understand here -f and other arguement like... (1 Reply)
Discussion started by: ajju
1 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)