09-11-2008
split a single sql file into multiple files
Hi,I have a single sql file containing many create table ddl's.Example:
CREATE TABLE sec_afs
(
rpt_per_typ_c char(1) NOT NULL,
rpt_per_typ_t varchar(20) NULL,
LOCK ALLPAGES
go
EXEC sp_primarykey 'sec_afs', rpt_per_typ_c
go
GRANT SELECT ON sec_afs TO developer_read_only
go
CREATE TABLE dbo.sec_iccc
(
user_nt_id_c char(16) NOT NULL,
unit_id_c char(4) NOT NULL
)
LOCK ALLPAGES
go
GRANT SELECT ON sec_iccc TO developer_read_only
go
CREATE TABLE sac_recon(
rec_number int NOT NULL,
rec_grp_number int NOT NULL,
)
go
I want to split this file into separate files-one each for a table,i have a blank line before every "create table"statement.So may be I can create a new file once every "create table" is encountered.Please tell me how to do this in unix.-Thanks
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Please help me out.
I have around 700 sql files to execute in a defined order, how can i do it from shell script (3 Replies)
Discussion started by: anushilrai
3 Replies
2. Shell Programming and Scripting
I have a file ehich has multiple create statements as
create abc 123
one
two
create xyz 456
four
five
create nnn 666
six
four
I want to separte each create statement in seperate files (3 Replies)
Discussion started by: glamo_2312
3 Replies
3. Programming
Is there anyway to spool my select statement into spool files of max 10000 records each?
eg I have a select statement that will return 45000 records.
A normal spool command will output the 45000 into just one spool file.
How can I make sqlplus do this?
00001 - 10000 records --- spool... (3 Replies)
Discussion started by: Leion
3 Replies
4. Shell Programming and Scripting
Dear All,
I would like to split a file of the following format into multiple files based on the number in the 6th column (numbers 1, 2, 3...):
ATOM 1 N GLY A 1 -3.198 27.537 -5.958 1.00 0.00 N
ATOM 2 CA GLY A 1 -2.199 28.399 -6.617 1.00 0.00 ... (3 Replies)
Discussion started by: tomasl
3 Replies
5. Shell Programming and Scripting
Let's assume that I have a file name called ‘A' and it has 100 lines in it and would like to split these 100 lines into 4 files as specified bellow.
INPUT: Input file name A
1
2
3
4
5
6
7
8
9
........100
Output: 4 output files (x,y,z,w)
File x should contains (Skip 4 lines)... (15 Replies)
Discussion started by: subbarao25
15 Replies
6. Shell Programming and Scripting
Hi!
I would like to do a single connection to sqlplus and execute some querys.
Actually I do for every query one connection to database
i.e
echo 'select STATUS from v$instance;
exit' > $SQL_FILE
sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT
echo 'select VERSION from v$instance;... (6 Replies)
Discussion started by: guif
6 Replies
7. UNIX for Dummies Questions & Answers
Hi,
I am new to unix. we have a requirement here to split a single file into multiples files based on the number of people available for processing. So i tried my hand at writing some code as below.
#!/bin/bash
var1=`wc -l $filename`
var2=$var1/$splitno
split -l $var2 $1
Please help me... (6 Replies)
Discussion started by: quirkguy
6 Replies
8. Shell Programming and Scripting
I have one single shown below and I need to break each ST|850 & SE to separate file using unix script. Below example should create 3 files. We can use ST & SE to filter as these field names will remain same.
Please advice with the unix code.
ST|850
BEG|PO|1234
LIN|1|23
SE|4
ST|850... (3 Replies)
Discussion started by: prasadm
3 Replies
9. UNIX for Dummies Questions & Answers
input file:
AD,00,--,---,---,---,---,---,---,--,--,---
AM,000,---,---,---,---,---,---
AR, ,---,--,---,---
AA,---,---,---,---
AT,---
AU,---,---,---
AS,---,---
AP,---,---,---
AI,---
AD,00,---,---,---, ,---,---,---,---,---,---
AM,000,---,---,---
AR,... (6 Replies)
Discussion started by: kcdg859
6 Replies
10. Shell Programming and Scripting
Hi All,
I have the sales_data.csv file in the directory as below.
SDDCCR; SOM ; MD6546474777 ;05-JAN-16
ABC ; KIRAN ; CB789 ;04-JAN-16
ABC ; RAMANA; KS566767477747 ;06-JAN-16
ABC ; KAMESH; A33535335 ;04-JAN-16
SDDCCR; DINESH; GD6674474747 ;08-JAN-16... (4 Replies)
Discussion started by: ROCK_PLSQL
4 Replies
LEARN ABOUT DEBIAN
mysqmail-postfix-logger
mysqmail-postfix-logger(8) System Manager's Manual mysqmail-postfix-logger(8)
NAME
mysqmail-postfix-logger - logs smtp traffic to a mysql database
SYNOPSIS
mysqmail-postfix-logger subprogram [ args ... ]
DESCRIPTION
mysqmail-postfix-logger reads the syslog using tail -F and for each lines, does an action in a selected table in the selected mysql server
(configuration done using /etc/mysqmail.conf). All messages that have been delivered are marqued as so in the from and in the to field of
the smtp traffic table.
mysqmail-postfix-logger uses a table corresponding to this one:
CREATE TABLE IF NOT EXISTS smtp_logs (
id int(11) NOT NULL auto_increment,
newmsg_id bigint(20) default NULL,
bounce_qp int(11) default NULL,
bytes int(11) NOT NULL default '0',
sender_user varchar(128) NOT NULL default '',
sender_domain varchar(128) NOT NULL default '',
delivery_id bigint(20) default NULL,
delivery_user varchar(128) NOT NULL default '',
delivery_domain varchar(128) NOT NULL default '',
delivery_success enum('yes','no') NOT NULL default 'no',
time_stamp timestamp(14) NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY bounce_qp (bounce_qp),
UNIQUE KEY newmsg_id (newmsg_id),
KEY sender_domain (sender_domain),
KEY delivery_domain (delivery_domain) ) TYPE=MyISAM;
VERSION
This documentation describes mysqmail-postfix-logger version 0.1.4. See http://gplhost.com/softwares-mysqmail.html for updates.
SEE ALSO
syslog(3), logger(8)
mysqmail-postfix-logger(8)