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
script-email
SCRIPT-EMAIL(8) System Administration Commands SCRIPT-EMAIL(8)
NAME
script-email - Amanda script to send email notifications
DESCRIPTION
script-email is an Amanda script implementing the Script API. It should not be run by users directly. It sends a notification email to the
addresses specified in the MAILTO property.
PROPERTIES
This section lists the properties that control script-email's functionality. See amanda-scripts(7) for information on the Script API,
script configuration.
MAILTO
List of email addresses that will receive an email on command execution. It is a multi-valued property:
property "MAILTO" "amanda@domain.com" "sysadmin@domain.com" "amandauser@domain.com"
EXAMPLE
In this example, script-email is scheduled to be run before the DLE, on the server. The unqualified email address amanda will be passed to
the email system unchanged. The script is then attached to a dumptype, which can then be specified for any DLEs which require
notification.
define script-tool pre-email {
comment "email me before this DLE is backed up"
plugin "script-email"
execute-on pre-dle-backup
execute-where server
property "mailto" "amanda"
}
define dumptype user-tar-email {
user-tar
script "pre-email"
}
SEE ALSO
amanda(8), amanda.conf(5), amanda-client.conf(5), amanda-scripts(7)
The Amanda Wiki: : http://wiki.zmanda.com/
AUTHORS
Jean-Louis Martineau <martineau@zmanda.com>
Zmanda, Inc. (http://www.zmanda.com)
Dustin J. Mitchell <dustin@zmanda.com>
Zmanda, Inc. (http://www.zmanda.com)
Amanda 3.3.1 02/21/2012 SCRIPT-EMAIL(8)