10 More Discussions You Might Find Interesting
1. UNIX and Linux Applications
Setup is a Solaris 11 zone running sendmail as a relay to our actual mailservers. All emails to external domains seem to be being tried to be sent directly from this Solaris 11 zone which cannot send mail externally.
All emails sent to our pager addresses as defined in the /etc/mail/aliases... (0 Replies)
Discussion started by: LittleLebowski
0 Replies
2. Shell Programming and Scripting
good afternoon forums.
i have a problem that ive been trying to work out all morning and cant seem to get my head around it.
what i have in my script is individual letters saved in different variables. so if the word unix was saved then 'u' would be stored in the variable 'wvar1' 'n' in 'wvar2'... (7 Replies)
Discussion started by: strasner
7 Replies
3. Shell Programming and Scripting
hi guys, how r u???
please I need you, help me please.
I have a shell, in this shell i have this function and another code lines, this function is getting date one day back. the function is in the same shell (FILE 1)
Now I need put this function in another file (FILE 2) and calling... (4 Replies)
Discussion started by: acevallo
4 Replies
4. UNIX for Advanced & Expert Users
Hi
Can anyone please let me know how to call unix scripts from sql or plsql ASAP. (2 Replies)
Discussion started by: ksailesh
2 Replies
5. Shell Programming and Scripting
Hi All ,
I have created .sql script in unix.this script contains 4 sql queries. Now I want to craete .sh file based on .sql script. So please let me know the steps to craete .sh file
Thank you. (1 Reply)
Discussion started by: user71408
1 Replies
6. UNIX for Advanced & Expert Users
I have a code as follows
awk ' BEGIN{FS=OFS=","}
{
n=split($3,a1,"~")
split($4,a2,"~")
split($5,a3,"~")
for(i=1;i<=n;i++) {
print $1,$2,a1,a2,a3,date
}
}' file
In the above code I need to add current date(date). How is this possible to call an date or a exported value... (13 Replies)
Discussion started by: tkbharani
13 Replies
7. Shell Programming and Scripting
hi all,
i have a function which will take i/p as a ddl sctipt as i/p and execute it,
let
function execute_sql
{
db_var="$1"
v_cnt=`sqlplus -s XXXXX/XXXXX@aXXX << ENDSQL | sed -e "s/Connected\.//" -e "/^$/d"
set pagesize 0 feedback off verify off heading off echo off serveroutput on size... (4 Replies)
Discussion started by: manas_ranjan
4 Replies
8. Filesystems, Disks and Memory
I have seagate USB 2.0 HDD which was working good on my windows system
Recently I have started using red hat Linux 2.6.9-55.0.12.EL (i686 i686 i386 GNU/Linux)
The USB is not at all detected in Linux even if I reboot with it attached to the PC. The same can be detected on any Windows system.... (2 Replies)
Discussion started by: mahendrakamath
2 Replies
9. Shell Programming and Scripting
Hi-
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini
5 Replies
10. Shell Programming and Scripting
Oracle and Scripting gurus,
I need some help with this script...
I am trying to add the query
SELECT * FROM
ALL_SYNONYMS
WHERE SYNONYM_NAME = 'METADATA'
in the current script....
Read the result set and look for the TABLE_NAME field. If the field is pointing to one table eg.... (18 Replies)
Discussion started by: madhunk
18 Replies
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)