DB2 Query modification to remove duplicate values using LISTAGG function
I am using DB2 v9 and trying to get country values in comma seperated format using below query
The table "LOCATION" has multiple columns apart from Employee and Country and hence i cant group on countries to remove duplicate countries values .
Is there a way to remove dups to get only countries once using above query with modification .
Hi All,
I want to connect two tables in DB2 using shell script and then compare the contents of two tables field by field.and i should return on the screen the un matched records ..
Could any one please help me in connecting database tables using Unix and retriving data from the same. (1 Reply)
Hi, I've got a file that I'd like to uniquely sort based on column 2 (values in column 2 begin with "comp").
I tried sort -t -nuk2,3 file.txtBut got:
sort: multi-character tab `-nuk2,3'
"man sort" did not help me out
Any pointers?
Input:
Output: (5 Replies)
Hi,
I want to replace a chain of if-else statement in an old AWK file with values from Db2 table or CSV file. The part of code is below...
if (start_new_rec=="true"){
exclude_user="false";
user=toupper($6);
match(user, "XXXXX.");
if (RSTART ==2 ) {
... (9 Replies)
Hi Gents,
Please can you help me to get the desired output .
In the first column I have some duplicate records, The condition is that all need to reject the duplicate record keeping the last occurrence. But the condition is. If the last occurrence is equal to value 14 or 98 in column 3 and... (2 Replies)
Hi,
Basically what I am trying to do is making multiple fields of the same type comma-separated.
i.e. for a data like this:
B00000 abc
B00001 abc,def
B00001 ghi
B00001 jkl
B00002 abc
B00002 def
B00003 xyz
Output should be like:
B00000 abc
B00001 abc,def,ghi,jkl... (20 Replies)
Hello,
I have a script that is generating a tab delimited output file.
num Name PCA_A1 PCA_A2 PCA_A3
0 compound_00 -3.5054 -1.1207 -2.4372
1 compound_01 -2.2641 0.4287 -1.6120
3 compound_03 -1.3053 1.8495 ... (3 Replies)
Hi Gurus,
I have a file(weblog) as below
abc|xyz|123|agentcode=sample code abcdeeess,agentcode=sample code abcdeeess,agentcode=sample code abcdeeess|agentadd=abcd stereet 23343,agentadd=abcd stereet 23343
sss|wwq|999|agentcode=sample1 code wqwdeeess,gentcode=sample1 code... (4 Replies)
Dear folks
I have a map file of around 54K lines and some of the values in the second column have the same value and I want to find them and delete all of the same values. I looked over duplicate commands but my case is not to keep one of the duplicate values. I want to remove all of the same... (4 Replies)
Hi Team
I am using DB2 artisan tool and struck to handle multi values present in columns that are comma(,) separated. I want to convert those column values in separate rows .
For example :
Column 1 Column2
Jan,Feb Hold,Sell,Buy
Expected Result
Column1 ... (3 Replies)
Dear Team
I am using DB2 v9 .
I have a condition to check roles based on hierarchies like below example.
1.Ramesh has Roles as "Manager" and "Interviewer"
2.KITS has Roles as "Interviewer"
3.ANAND has Roles as "Manager" and "Interviewer"
select * FROM TESTING
NAME ... (6 Replies)
Discussion started by: Perlbaby
6 Replies
LEARN ABOUT DEBIAN
apt-spy.conf
APT-SPY.CONF(5) File Formats Manual APT-SPY.CONF(5)NAME
apt-spy.conf - configuration file for apt-spy(8)DESCRIPTION
apt-spy.conf is the configuration file for apt-spy(8). It consists of a series of area labels, followed by a list of countries belonging
to that label. Whitespace is ignored.
Comments may be added anywhere, and begin with the hash ('#') character. Once a hash character is encountered, the rest of the line is
ignored.
A label consists of any alphanumeric characters, and ends with a colon character (':'). The label must be on a line by itself (excluding
comments).
Following a label are a list of country codes (one per line) of countries belonging to that label.
Each country has a unique two-letter country code corresponding to its top level domain identifier. This is the same as the ISO3166 code.
You can find the country code for a specific country either by looking at /var/lib/apt-spy/mirrors.txt, or by looking at the commented
examples in the default apt-spy.conf.
Labels cannot exist within labels. The end of a label section is signaled by the start of a new one, or by the end of file.
Any valid label existing in apt-spy.conf can be specified to apt-spy using the '-a' option. apt-spy will then proceed to benchmark the
mirrors in the list of countries associated with that label.
EXAMPLES
This is an example of a valid apt-spy.conf file:
USUK:
GB # United Kingdom
US # United States
Australia:
AU
France-Germany-Netherlands:
FR
DE
NL
There is a default configuration file included with apt-spy. For further examples, and for a list of valid country codes, please refer to
this.
SEE ALSO apt-spy(8), apt(8), sources.list(5)
20th May, 2003 APT-SPY.CONF(5)