06-27-2013
To append column names to a table using db2 and shell script
# Get all the columns seperated with comma.
Col_names=$(db2 -x "select colname||',' from syscat.columns where tabname = '$TABLENAME' order by colno")
#Put all the columns in a text file
echo $Col_names > columns.txt
#Export table data to csv which you want to append columns
db2 "EXPORT TO $HOME/$TABLENAME.csv OF DEL MESSAGES $HOME/$TABLENAME.txt select * from $SCHEMA.$TABLENAME"
#Append columns to Table
cat columns.txt $HOME/$TABLENAME.csv > $HOME/newfile.csv
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
How can I use awk to create a new file that has 2 columns, each colums comes form a different file.
example:
I need column 3 from file1 and column 5 from file2 to make file3. (3 Replies)
Discussion started by: cosmologist
3 Replies
2. Shell Programming and Scripting
input1
a_a a/a 10 100
a1 a_a 20 200
b1 b_b 30 300
input2
a_a a/a xxx yyy
a1 a1 lll ppp
b1 b_b kkk ooo
output
a_a a/a 10 100 xxx yyy (2 Replies)
Discussion started by: ruby_sgp
2 Replies
3. Shell Programming and Scripting
Hello Team,
I have written following command which is giving output is as shown below.
bash-3.00$ grep -i startup catalina.out | tail +2 | sed -n 1p | awk -F" " '{ for (x=1; x<=5; x++) { printf"%s\n", $x } }'
Dec
19,
2010
3:28:39
PM
bash-3.00$
I would like to modify above command to... (2 Replies)
Discussion started by: coolguyamy
2 Replies
4. Shell Programming and Scripting
I have a file with contents
"08011"||20080812
"23348"|20080827|20080924
"23387"|20080829|20080915
"23581"|20081003|20081028
"23748"|20081017|20090114
"24095"|20080919|20081013
"24105"|20070723|20070801
"24118"|20080806|20081013
"24165"|20080820|20080912
"24221"|20080908|20080929
i... (3 Replies)
Discussion started by: sonam273
3 Replies
5. Shell Programming and Scripting
Hi Experts,
Please bear with me, i need help
I am learning AWk and stuck up in one issue.
First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique.
Second point : For... (12 Replies)
Discussion started by: as7951
12 Replies
6. Shell Programming and Scripting
Hello,
I have two text tab delimited files
File 1 has 30 columns. I am pasting only first 9
Chr Position Ref Alt Score Gene HGVS_C HGVS_P Coding_Consequence dbSNP
1 17312743 C T 1 Gene1 - ... (2 Replies)
Discussion started by: nans
2 Replies
7. Shell Programming and Scripting
The purpose is to check if values for column 3 and 4 in file1 match with column 1 in file2.
If any value match do:
1) Replace values in file2 for column 2 and 3 using the information of file1 columns 5 and 6
2) Replace string ($1,1,5) and string ($1,6,5) in file2 with values of columns 7... (8 Replies)
Discussion started by: jiam912
8 Replies
8. UNIX for Beginners Questions & Answers
Hi,
I'm trying to copy and paste the sixth column from a bunch of files into a single file having each column pasted in separate columns (and not one after each other in just one column.)
I tried this code but works only partially because it copied and pasted 50 rows of each column... (6 Replies)
Discussion started by: Frastra
6 Replies
9. UNIX for Beginners Questions & Answers
I have 2 files contains more than 5000 lines, I want to paste the 1st column of both file in an output file using awk.
Please suggest to me I had tried paste command but it merges my both column.
--- Post updated at 10:26 PM ---
file1.txt
2020-01-07 235400
2020-01-07 235400
2020-01-07... (4 Replies)
Discussion started by: Sagar Singh
4 Replies
10. UNIX for Beginners Questions & Answers
Hello Everyone,
I have many files like so:
file1.txt
file2.txt
file3.txt
Within each file I have many lines of random text separated by commas like so:
abcAAA,123,defAA,456777,ghiA,789
jklB,101,mnoBBB,11211,pqrB,13111
stuCC,415,vwxCCCC,161,yzaC,718
I am trying to use SED or AWK to... (4 Replies)
Discussion started by: D3U5X
4 Replies
LEARN ABOUT DEBIAN
amc-export
AMC-EXPORT(1) Auto Multiple Choice AMC-EXPORT(1)
NAME
AMC-export - exports marks for AMC multiple choice exams.
SYNOPSIS
auto-multiple-choice export --data project-data-dir --module module --fich-noms students-list.csv [--noms-encodage list-encoding]
--o output-file
DESCRIPTION
The AMC-export.pl command exports marks from an Auto Multiple Choice exam.
--data project-data-dir
gives the directory where data files are (see for example AMC-prepare(1)).
--module module
selects a module for export. See below for the modules included in the AMC standard distribution.
--fich-noms students-list.csv
sets the students list file.
--noms-encodage list-encoding
selects an encoding for file students-list.csv (default is utf-8).
--o output-file
gives the output file name.
--option-out options
gives an option for selected module, in the form key=value (see below for possible options for each module). To specify multiple
options, use --option several times.
--sort sort-type
sort the students names, depending on sort-type. If sort-type is l, use line number from students list file to sort. If sort-type is m,
use mark (and name if marks are equal) to sort. If sort-type is i, use student number to sort. If sort-type is n, use name to sort (or
line from students list if equal).
--useall all
if all is 0 or empty, only students with a scaned answer sheet appears in the output. If all is 1, all students in the students list
appears in the output.
MODULES
OpenDocument
With "--module ods", an OpenDocument (for use by OpenOffice or LibreOffice for example) is produced. The following options are recognized:
nom
gives a name for the exam, to be written on the beginning of the sheet.
code
gives an short name for the exam, to be used as a tab name.
columns
sets the list of columns that are to be added to each student. Default value is student.key,student.name.
stats
with a true value, a table will be added with statistics for all questions.
statsindic
with a true value, a table will be added with statistics for all indicative questions.
CSV
With "--module CSV", a CSV file is produced. The following options are recognized:
columns
sets the list of columns that are to be added to each student. Default value is student.copy,student.key,student.name.
decimal
sets the decimal point (default is a dot).
encodage
sets the encoding to use for output (default is utf-8).
separateur
sets the character used between colums (default is a comma).
entoure
sets the character used to enclose strings (default is a double quote).
ticked
if not empty, additional columns (with "CHECKED:" prefix) are included to give all the checked boxes on all the sheets. This can be
used by an external program to retrieve all the checked boxes when marks are not sufficient. Use value 01 to get 0;0;1;1;0 if boxes 3
and 4 are checked, and value AB to get CD if boxes 3 and 4 are checked.
List
With "--module List", a PDF file is produced with a list of marks for all students. The following options are recognized:
pagesize
The page size. Default value is a4.
nom
gives the name of the exam, to be printed at the top of the page.
ncols
The number of columns. Default value is 2.
decimal
sets the decimal point (default is a dot).
AUTHORS
Alexis Bienvenue <paamc@passoire.fr>
Main author
Jean Berard
Translation from French
Georges Khaznadar
Translation from French
COPYRIGHT
Copyright (C) 2008-2012 Alexis Bienvenue
This document can be used according to the terms of the GNU General Public License, version 2 or later.
Auto Multiple Choice 1.1.1 06/19/2012 AMC-EXPORT(1)