10-21-2010
Forming an insert query using awk
Hi,
I'm trying to form an insert sql query using shell programming. I have table named company with four columns 'company name', 'company id', 'company code' and 'last change id'
I have to read the company name, company code and last change id from a file delimited by | which has around 10 companys...The company id has to be incremented from say 1000, 1001, 1002 upto 1010...
My output should be an insert statement like
insert into company values (1000, "ABC company", 'E', "Last_user");
insert into company values (1001, "EFG company", 'A', "Last_user");
.
.
insert into company values (1010, "XYZ company", 'D', "Last_user");
Please let me know how can i do this...Also let me know if you need additional info..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Guys,
I need to create a insert query for the below file
Fri Sep 4 06:25:51 2009
ACTION : 'CREATE INDEX S100S_DC.PLInsuranceReportRules_testI1 ON S100S_DC.PLInsuranceReportRules_test1(ENTITY_KEY)'
DATABASE USER: '/'
PRIVILEGE : SYSDBA
CLIENT USER: oracle
CLIENT TERMINAL: pts/3... (6 Replies)
Discussion started by: mac4rfree
6 Replies
2. Programming
i would like to know how can i fine tune the following query since the cost of the query is too high ..
insert into temp temp_1 select a,b,c,d from xxxx
.. database used is IDS.. (1 Reply)
Discussion started by: expert
1 Replies
3. UNIX for Dummies Questions & Answers
if the key (A or B or ...others) has 4 in its 3rd column the 1st A row has to form 4 dupicates along with the all the values of A in 4th column (2.9, 3.8, 4.2) .
Hope I explain the question clearly.
Cheers
Ruby
input
"A" 1 4 2.9
"A" 2 5 ... (7 Replies)
Discussion started by: ruby_sgp
7 Replies
4. Shell Programming and Scripting
My script contains as follows,
VALUE=`sqlplus un/pwd <<EOF > OB.txt
set pagesize 0 feedback off verify off heading off echo off
select max(1) from table1;
exit;
EOF`
insert into table2 values(1, 'The max value is $value',...);
i need the value of VALUE to be inserted after 'The max... (2 Replies)
Discussion started by: savithavijay
2 Replies
5. Shell Programming and Scripting
I am trying to make group of number of ID's. I have prepared following perl script but it does not provide any output.
INPUT File
0174
0175
0176
0177
CODE:
#!/usr/bin/perl -w
$memlst = "/tmp/test.txt";
$membercnt = `wc -l $memlst`;
$memhd = `head -1 $memlst`;
$memcnt1 = 1;
$class... (1 Reply)
Discussion started by: dynamax
1 Replies
6. Programming
Hello
i want help to load data from file into mysql DB
this part i know how to do
but during loading
i want to combine 2 fields into 1 field and insert into db as primary key in new column
thanks advice how to do so (5 Replies)
Discussion started by: mogabr
5 Replies
7. UNIX for Dummies Questions & Answers
Hi,
I will execute a query in sqlplus and redirect to a file.
The file will contains the date value such as 2011-04-12 02:00:00.
i want to make the content of the file such as,
select * from table where col1>to_date('2011-04-12 02:00:00','yyyy-mm-dd HH24:MI:SS').
Apar from the bold... (1 Reply)
Discussion started by: pandeesh
1 Replies
8. Shell Programming and Scripting
Hi,
I'm a first timer with Unix so pardon my ignorance.
I'm trying to read a comma separated file from the same folder where the script is and insert the value in a DB2 table.
I'm using AWK for the same. I'm getting `)' not expected error.
I'm not sure but for me it doesn't look like detailed... (8 Replies)
Discussion started by: Kabira Speaking
8 Replies
9. Shell Programming and Scripting
Hi
How do I translate
Let say
Cat inserts.sql
gives
Insert into PM9_TAXATION_ROUNDING
(STATE_GECODE, TAX_TYPE, TAX_AUTHORITY, SYS_CREATION_DATE, SYS_UPDATE_DATE, APPLICATION_ID, DL_SERVICE_CODE, ROUNDING_METHOD)
Values
('xx', 'xx', 'x', TO_DATE('10/26/2012 13:01:20',... (3 Replies)
Discussion started by: anuj87in
3 Replies
10. Shell Programming and Scripting
Hello guys,
I'm new to shell programming, I would like to insert two new columns in a space separated file having this format using awk, starting from the third row:
A B C D E F 1 ;
A B C D E F 1 ;
A B C D E F 1 ;
A B C D E F 1 ;
Basically, the resulting file should have the following... (3 Replies)
Discussion started by: transat
3 Replies
LEARN ABOUT DEBIAN
git-shortlog
GIT-SHORTLOG(1) Git Manual GIT-SHORTLOG(1)
NAME
git-shortlog - Summarize 'git log' output
SYNOPSIS
git log --pretty=short | git shortlog [-h] [-n] [-s] [-e] [-w]
git shortlog [-n|--numbered] [-s|--summary] [-e|--email] [-w[<width>[,<indent1>[,<indent2>]]]] <commit>...
DESCRIPTION
Summarizes git log output in a format suitable for inclusion in release announcements. Each commit will be grouped by author and the first
line of the commit message will be shown.
Additionally, "[PATCH]" will be stripped from the commit description.
If no revisions are passed on the command line and either standard input is not a terminal or there is no current branch, git shortlog will
output a summary of the log read from standard input, without reference to the current repository.
OPTIONS
-h, --help
Print a short usage message and exit.
-n, --numbered
Sort output according to the number of commits per author instead of author alphabetic order.
-s, --summary
Suppress commit description and provide a commit count summary only.
-e, --email
Show the email address of each author.
--format[=<format>]
Instead of the commit subject, use some other information to describe each commit. <format> can be any string accepted by the --format
option of git log, such as * [%h] %s. (See the "PRETTY FORMATS" section of git-log(1).)
Each pretty-printed commit will be rewrapped before it is shown.
-w[<width>[,<indent1>[,<indent2>]]]
Linewrap the output by wrapping each line at width. The first line of each entry is indented by indent1 spaces, and the second and
subsequent lines are indented by indent2 spaces. width, indent1, and indent2 default to 76, 6 and 9 respectively.
MAPPING AUTHORS
The .mailmap feature is used to coalesce together commits by the same person in the shortlog, where their name and/or email address was
spelled differently.
If the file .mailmap exists at the toplevel of the repository, or at the location pointed to by the mailmap.file configuration option, it
is used to map author and committer names and email addresses to canonical real names and email addresses.
In the simple form, each line in the file consists of the canonical real name of an author, whitespace, and an email address used in the
commit (enclosed by < and >) to map to the name. For example:
Proper Name <commit@email.xx>
The more complex forms are:
<proper@email.xx> <commit@email.xx>
which allows mailmap to replace only the email part of a commit, and:
Proper Name <proper@email.xx> <commit@email.xx>
which allows mailmap to replace both the name and the email of a commit matching the specified commit email address, and:
Proper Name <proper@email.xx> Commit Name <commit@email.xx>
which allows mailmap to replace both the name and the email of a commit matching both the specified commit name and email address.
Example 1: Your history contains commits by two authors, Jane and Joe, whose names appear in the repository under several forms:
Joe Developer <joe@example.com>
Joe R. Developer <joe@example.com>
Jane Doe <jane@example.com>
Jane Doe <jane@laptop.(none)>
Jane D. <jane@desktop.(none)>
Now suppose that Joe wants his middle name initial used, and Jane prefers her family name fully spelled out. A proper .mailmap file would
look like:
Jane Doe <jane@desktop.(none)>
Joe R. Developer <joe@example.com>
Note how there is no need for an entry for <jane@laptop[1].(none)>, because the real name of that author is already correct.
Example 2: Your repository contains commits from the following authors:
nick1 <bugs@company.xx>
nick2 <bugs@company.xx>
nick2 <nick2@company.xx>
santa <me@company.xx>
claus <me@company.xx>
CTO <cto@coompany.xx>
Then you might want a .mailmap file that looks like:
<cto@company.xx> <cto@coompany.xx>
Some Dude <some@dude.xx> nick1 <bugs@company.xx>
Other Author <other@author.xx> nick2 <bugs@company.xx>
Other Author <other@author.xx> <nick2@company.xx>
Santa Claus <santa.claus@northpole.xx> <me@company.xx>
Use hash # for comments that are either on their own line, or after the email address.
GIT
Part of the git(1) suite
NOTES
1. jane@laptop
mailto:jane@laptop
Git 1.7.10.4 11/24/2012 GIT-SHORTLOG(1)