12-17-2008
Complex Insert block in the Script
I have script in that there are thousands of create statement...
I want to add these lines, above every Create Stament
================================================
IF OBJECT_ID('dbo.account_account_relations') IS NOT NULL
BEGIN
DROP TABLE dbo.account_account_relations
IF OBJECT_ID('dbo.account_account_relations) IS NOT NULL
PRINT '<<< FAILED DROPPING TABLE dbo.account_account_relations>>>'
ELSE
PRINT '<<< DROPPED TABLE dbo.account_account_relations>>>'
END
go
==================================================
CREATE TABLE dbo.account_account_relations(
relation_type_cd VARCHAR(20) NOT NULL,
first_account_key VARCHAR(50) NOT NULL,
second_account_key VARCHAR(50) NOT NULL,
row_update_date DATETIME NOT NULL
)
MyProblem Is:-
1) how to add those extra lines above each CREATE Stmnt.
2) inserted lines should pick up the object from CREATE TABLE shown in RED.
Please help with the code....or logic will also do....
If anything is unclear please let me know....
Kunal
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Default shell is /usr/bin/zsh
Script will be running #!/bin/bash
Need to pull information from database while using other scripts already made (not by me).
Ok, so i need a script pulling certain information about a customer's router interfaces.
I am using a ROUTER-DNS-NAME as variable $1
I... (3 Replies)
Discussion started by: ///NNM
3 Replies
2. Shell Programming and Scripting
How to I put my find command string into a script. It is currently to long to be entered manually at command line.
for FNAME in `find /unixsxxx/interface/x.x/xxxxxx -type f \( -name '*.KSH' -o -name '*.sh' -o -name '*.sql' -o -name '*.ksh' \) -exec grep -il xxx.xxx.xxx.xxx {} \;`; do C=`grep -c... (5 Replies)
Discussion started by: TimHortons
5 Replies
3. Shell Programming and Scripting
Hi,
I need to convert the following file into DB insert statements.
$ cat input.txt
START
name=john
id=123
date=12/1/09
END
START
name=sam
id=4234
status=resigned
date=12/1/08
END (2 Replies)
Discussion started by: vlinet
2 Replies
4. Shell Programming and Scripting
My script prints lines in which the entire line may be colored, and portions may also be colored. e.g.
Consider this to be one line:
$red some text in red $yellow abcd $end_yellow red text 1234 $blue some text $end_blue more red text $end_red
So using sed, I may based on condition 1,... (5 Replies)
Discussion started by: sentinel
5 Replies
5. Shell Programming and Scripting
Hello,
I've been racking my brain trying to find a good way to accomplish a task. I need to insert a block of text into a file in the format of
FirewallRuleSet proxy-users {
FirewallRule allow to 0.0.0.0/0
}
I need to insert this block of text (which could have sed special... (2 Replies)
Discussion started by: 0xception
2 Replies
6. Shell Programming and Scripting
hey... i had a big problem with my professor
i have 3 simple archives
in.txt -> had all timestamps of users logon (100lines)
ex. 111111
222222
333333
out.txt -> had all timestamps of users logof (100lines)
ex. 111113
222225
333332
commands.txt... (9 Replies)
Discussion started by: beandj
9 Replies
7. Shell Programming and Scripting
picked this up from another thread.
echo 1st_file.csv; nawk -F, 'NR==FNR{a++;next} a{b++}
END{for(i in b){if(b-1&&a!=b){print i";\t\t"b}else{print "NEW:"i";\t\t"b} } }' OFS=, 1st_file.csv *.csv | sort -r
i need to use the above but with a slight modification..
1.compare against 3 month... (25 Replies)
Discussion started by: slashbash
25 Replies
8. Shell Programming and Scripting
Hello to all in forum,
Maybe an awk expert could help me with this complex task for me.
I have the input shown below and I would like to get the output as follow:
- I would like the output separated by commas.
- The header is fixed and will be the same always.
- For the lines containing... (22 Replies)
Discussion started by: Ophiuchus
22 Replies
9. Shell Programming and Scripting
Hello all,
Please help modify my file. I want to pick up the ID value when the 3rd column is either gene or protein_coding_gene and place the ID in the gene_id attribute corresponding rows which has the the keyword exon in the third column.
Input file
10 ensembl gene 195359 ... (6 Replies)
Discussion started by: gina.lizar
6 Replies
10. Shell Programming and Scripting
I have an FTP server with thousands of Invoices. All Invoices are in a folder called /volume1/MBSInvoices/
Monthly invoices are added to that folder every month.
Here is a sample filename of the Invoices:
invoice_1_20170101_10010052_10020052_10030052_JOHNDOE.pdf
the Account ID is the... (6 Replies)
Discussion started by: badr777
6 Replies
LEARN ABOUT DEBIAN
net::sieve::script::rule
Net::Sieve::Script::Rule(3pm) User Contributed Perl Documentation Net::Sieve::Script::Rule(3pm)
NAME
Net::Sieve::Script::Rule - parse and write rules in sieve scripts
SYNOPSIS
use Net::Sieve::Script::Rule;
my $pRule = Net::Sieve::Script::Rule->new (
ctrl => $ctrl,
test_list => $test_list,
block => $block,
order => $order
);
or
my $rule = Net::Sieve::Script::Rule->new();
my $cond = Net::Sieve::Script::Condition->new('header');
$cond->match_type(':contains');
$cond->header_list('"Subject"');
$cond->key_list('"Re: Test2"');
my $actions = 'fileinto "INBOX.test"; stop;';
$rule->add_condition($cond);
$rule->add_action($actions);
print $rule->write;
DESCRIPTION
CONSTRUCTOR
new
Arguments :
order => : optionnal set priority for rule
ctrl => : optionnal default 'if', else could be 'else', 'elsif'
or 'vacation'
test_list => : optionnal conditions by string or by Condition Object
block => : optionnal block of commands
Returns : Net::Sieve::Script::Rule object
Set accessors
alternate : as param ctrl
conditions : first condition in tree
actions : array of actions objects
priority : rule order in script, main id for rule
require :
METHODS
equals
return 1 if rules are equals
write
Return rule in text format
write_condition
set require for used conditions
return conditions in text format
write_action
set require for used actions
return actions in text format
delete_condition
Purpose : delete condition by rule, delete all block on delete anyof/allof
delete single anyof/allof block : single condition move up
Arguments : condition id
Returns : 1 on success, 0 on error
add_condition
Purpose : add condition to rule, add 'allof' group on second rule
Arguments : string or Condition object
Returns : new condition id or 0 on error
swap_actions
swap actions by order
return 1 on succes, 0 on failure
find_action
find action by order
Returns: Net::Sieve::Script::Action object, 0 on error
delete_action
delete action by order, first is 1;
add_action
Purpose : add action at end of block
Arguments : command line
or command line list with ; separator
or Net::Sieve::Script::Action object
Return : 1 on success
AUTHOR
Yves Agostini
CPAN ID: YVESAGO
Univ Metz
agostini@univ-metz.fr
http://www.crium.univ-metz.fr
COPYRIGHT
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
The full text of the license can be found in the LICENSE file included with this module.
perl v5.10.0 2008-09-15 Net::Sieve::Script::Rule(3pm)