01-31-2006
Thanks! That explains a lot..
I had a series of SQL's to be submitted within a ksh script(with -e option). If one SQL failed, the script stopped execution.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi.
What does this command do in the shell script?
#!/bin/ksh
I have some scripts which do not run if this line is removed. First I thought it is comment but I think it sets up korn as shell.
Sanjay (2 Replies)
Discussion started by: sanjay_g
2 Replies
2. Shell Programming and Scripting
Hi,
I wrote scripting to perform some jobs. (eg, run_job)
Everything works ok when i tested it on my side.
I execute the run_job manually and it works perfectly ok.
When my administrator try to run it using a scheduler job.
He encountered problem of running it.
He said it might be due to... (1 Reply)
Discussion started by: maldini
1 Replies
3. Tips and Tutorials
Introduction
Originally, we only had one shell on unix. When ran a command, the shell would attempt to invoke one of the exec() system calls on it. It the command was an executable, the exec would succeed and the command would run. If the exec() failed, the shell would not give up, instead it... (3 Replies)
Discussion started by: Perderabo
3 Replies
4. Shell Programming and Scripting
Hi All,
I have a shell (#!/bin/sh) with below piece of code:
if !
then
echo Staging table ABC_INT_TAB is not present in the schema >> $OUTPUT
fi
Shell is throwning below error and continue to work even after this error... (3 Replies)
Discussion started by: bhush782003
3 Replies
5. Shell Programming and Scripting
we have a shell script that we are using in KSH
if ]; then
_IFS=$IFS
IFS=:
and it's failing on /bin/sh . Is there a simple way to modify it to work on both . ( not with awk)
Thanks in adv (3 Replies)
Discussion started by: talashil
3 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I have a problem I don't understand with fuser.
I launch a simple shell script mysleep.sh:
I launch the command fuser -fu mysleep.sh but fuser doesn't return anything excepted:
mysleep:
Then I modify my script switching from #!/bin/sh to #!/bin/ksh
I launch the command fuser -fu... (4 Replies)
Discussion started by: Peuj
4 Replies
7. Shell Programming and Scripting
I have started to write Korn scripts on the client's AIX 4.2 servers and there is this small problem that puzzles me.
I code all my scripts the same way:
- first line contains :
#!/bin/ksh
- I do this console command on every scripts:
chmod +x scriptname
But still, on some occasions,... (4 Replies)
Discussion started by: Browser_ice
4 Replies
8. Shell Programming and Scripting
:b:HI Friends,
Can you help me understand -p option with /usr/bin/ksh shell interpreter ?
Thanks,
Panditt (1 Reply)
Discussion started by: deshaipet
1 Replies
9. UNIX for Dummies Questions & Answers
Hi,
In the beginning of Shell script, we give a statement like
#!/bin/ksh
I have 2 questions related to this,
1) It could denote about the shell we want to use, what is the real usage of this? My shell script works even without this statement, is it a mandatory one.
2) I'm using... (7 Replies)
Discussion started by: Dev_Dev
7 Replies
10. Shell Programming and Scripting
I saw one script using the first line as below
/usr/bin/ksh -E
I have used -x for debug but couldn't find what is this -E option for ?
Pls let me know what is this -E used for
Thanks
RL (1 Reply)
Discussion started by: reldb
1 Replies
LEARN ABOUT DEBIAN
sql::translator::producer::sqlserver
SQL::Translator::Producer::SQLServer(3pm) User Contributed Perl Documentation SQL::Translator::Producer::SQLServer(3pm)
NAME
SQL::Translator::Producer::SQLServer - MS SQLServer producer for SQL::Translator
SYNOPSIS
use SQL::Translator;
my $t = SQL::Translator->new( parser => '...', producer => 'SQLServer' );
$t->translate;
DESCRIPTION
This is currently a thin wrapper around the nextgen SQL::Translator::Generator::DDL::SQLServer DDL maker.
Extra Attributes
field.list
List of values for an enum field.
TODO
* !! Write some tests !!
* Reserved words list needs updating to SQLServer.
* Triggers, Procedures and Views DO NOT WORK
# Text of view is already a 'create view' statement so no need to
# be fancy
foreach ( $schema->get_views ) {
my $name = $_->name();
$output .= "
";
$output .= "--
-- View: $name
--
" unless $no_comments;
my $text = $_->sql();
$text =~ s/
//g;
$output .= "$text
GO
";
}
# Text of procedure already has the 'create procedure' stuff
# so there is no need to do anything fancy. However, we should
# think about doing fancy stuff with granting permissions and
# so on.
foreach ( $schema->get_procedures ) {
my $name = $_->name();
$output .= "
";
$output .= "--
-- Procedure: $name
--
" unless $no_comments;
my $text = $_->sql();
$text =~ s/
//g;
$output .= "$text
GO
";
}
SEE ALSO
SQL::Translator
AUTHORS
See the included AUTHORS file: http://search.cpan.org/dist/SQL-Translator/AUTHORS <http://search.cpan.org/dist/SQL-Translator/AUTHORS>
COPYRIGHT
Copyright (c) 2012 the SQL::Translator "AUTHORS" as listed above.
LICENSE
This code is free software and may be distributed under the same terms as Perl itself.
perl v5.14.2 2012-05-10 SQL::Translator::Producer::SQLServer(3pm)