|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
script to parse text file into sql commands
Post 302550726 by frank_rizzo on Friday 26th of August 2011 10:01:08 PM
08-26-2011
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi,
plz let me know one example in using sql command in shell script
thanks inadvance
-bali. (1 Reply)
Discussion started by: balireddy_77
1 Replies
2. Shell Programming and Scripting
i am attempting to parse a simple text file with multiple lines and four fields in each line, formatted as such:
12/10/2006 12:34:06 77 38
this is what i'm having problems with in my bash script:
sed '1,6d' $RAWDATA > $NEWFILE
#removes first 6 lines from file, which are... (3 Replies)
Discussion started by: klick81
3 Replies
3. Shell Programming and Scripting
I have a file that has a header followed by 8 columns of data. I want to toss out the header, and then write the data to another file with a different header and footer. I also need to grab the first values of the first and second column to put in the header.
How do I chop off the header? ... (9 Replies)
Discussion started by: craggm
9 Replies
4. UNIX for Dummies Questions & Answers
Hi, everyone
The input file pattern is like below:
Begin Object1
txt1
end
;
Begin Object2
txt2
end
;
... (14 Replies)
Discussion started by: sophiadun
14 Replies
5. UNIX for Dummies Questions & Answers
Hi guys,
I am new on here, I have a function in oracle that returns a specific value:
create or replace
PACKAGE BODY "CTC_ASDGET_SCHED" AS
FUNCTION FN_ASDSCHEDULE_GET
RETURN VARCHAR2
AS
BEGIN
DECLARE
ASDSchedule varchar2(6);
ASDComplete... (1 Reply)
Discussion started by: reptile
1 Replies
6. Shell Programming and Scripting
Hi guys,
I desperately need some help here...
I need to parse a file similar to this:
I need to read the values for MY_BANNER_SSHD and WARNING_MESSAGE. The value could be empty/single line or multi-line!
# Comments
.
.
.
Some lines
MY_BANNER_SSHD=""... (7 Replies)
Discussion started by: shreeda
7 Replies
7. Shell Programming and Scripting
I wanted to parse a text file and join in specific format. please suggest me how to get this done..
The output should be in fasta format which consists of lines starting with ID, PT, PA and Sequence. "//" the two slashes are dividing lines between two different sequences.
Like... (10 Replies)
Discussion started by: empyrean
10 Replies
8. Shell Programming and Scripting
Hi everyone,
another question while using sed.
my sed statement should parse every line in a file and store all "i" variable item a a new file.
any wrong arguments here?
Thanks a million.
task_name => name,
object_type => 'TABLE',
attr1 => 'TestR3',
attr2 => '$i',
for i... (4 Replies)
Discussion started by: sundaygeek
4 Replies
9. Shell Programming and Scripting
Hi Forum.
Need your expertise on the following question.
I have the following file which I would like to parse, find first block of SELECT statment and concatenate all input fields as 1 field (~ delimited):
Old File:
SELECT /*+ USE_HASH(CCOMM ICAR IMAP IAS IP IMAS IMPS IAP SPCA) */
... (5 Replies)
Discussion started by: pchang
5 Replies
10. Shell Programming and Scripting
Hello,
I have a Pro*C program which contains SQL sentences, such as:
....
Pro*C sentences
....
/*SQL 1*/
EXEC SQL SELECT t1.field1, t1.field2
INTO :w_field
FROM TABLE1 t1, TABLE1 t2
WHERE t1.field1 = t2.field1
AND t1.ID = :wl_id;
....
Pro*C sentences
....
/*SQL 1*/
EXEC... (11 Replies)
Discussion started by: mvalonso
11 Replies
LEARN ABOUT SUSE
mysql_secure_installation
MYSQL_SECURE_INST(1) MySQL Database System MYSQL_SECURE_INST(1) NAME
mysql_secure_installation - improve MySQL installation security SYNOPSIS
mysql_secure_installation DESCRIPTION
This program enables you to improve the security of your MySQL installation in the following ways: o You can set a password for root accounts. o You can remove root accounts that are accessible from outside the local host. o You can remove anonymous-user accounts. o You can remove the test database, which by default can be accessed by anonymous users. Invoke mysql_secure_installation without arguments: shell> mysql_secure_installation The script will prompt you to determine which actions to perform. COPYRIGHT
Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc. This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License. This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/. SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online at http://dev.mysql.com/doc/. AUTHOR
Sun Microsystems, Inc. (http://www.mysql.com/). MySQL 5.1 04/06/2010 MYSQL_SECURE_INST(1)