Hello,
I am new to db2 SQL in unix so bear with me while I try to explain the situation. I have a text file that has the contents of the where condition that I am using for a db2 SQL in UNIX ksh.
Here is the snippet.
if ;
then
echo "Begin processing VALUEs"
... (1 Reply)
Hi,
I have a file with below contents.
Heading1 Heading2 Heading3 Heading4
Value1 Value2 Value3 Value4
The file has only 2 rows and is tab separated
The desired output is :
Heading1 Value1
Heading2 Value2
Heading3 Value3
Heading4 Value4
CAn you please help? (5 Replies)
Hi,
I have a problem where I need to make this input:
nameRow1a,text1a,text2a,floatValue1a,FloatValue2a,...,floatValue140a
nameRow1b,text1b,text2b,floatValue1b,FloatValue2b,...,floatValue140b
look like this output:
nameRow1a,text1b,text2a,(floatValue1a - floatValue1b),(floatValue2a -... (4 Replies)
hi,
I am basically running a sql that returns me values and I have stored them to a variable for example value of the variable will be:
123 124 345
now I want to write values stored in the variable into a file as
123
124
345
thanks in advance (3 Replies)
Hi Experts,
I have a requirement to convert rows into columns.
For e.g.
Input File:
Output File should be like
Appreciate if you could suggest code snippet(may be awk) for above requirement...
Thanks in Advance for your help... (3 Replies)
Hi all ,
I have a file with the below content
Header Section
employee|employee name||Job description|Job code|Unitcode|Account|geography|C1|C2|C3|C4|C5|C6|C7|C8|C9|Csource|Oct|Nov|Dec|Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep
Data section ... (1 Reply)
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)
I am using DB2 v9 and trying to get country values in comma seperated format using below query
SELECT distinct LISTAGG(COUNTRIES, ',') WITHIN GROUP(ORDER BY EMPLOYEE)
FROM LOCATION ;
Output Achieved
MEXICO,UNITED STATES,INDIA,JAPAN,UNITED KINGDOM,MEXICO,UNITED STATES
The table... (4 Replies)
Discussion started by: Perlbaby
4 Replies
LEARN ABOUT DEBIAN
tcrtest
TCRTEST(1) Tokyo Tyrant TCRTEST(1)NAME
tcrtest - test cases of the remote database API
DESCRIPTION
The command `tcrtest' is a utility for facility test and performance test. This command is used in the following format. `host' specifies
the host name of the server. `rnum' specifies the number of iterations.
tcrtest write [-port num] [-cnum num] [-tout num] [-nr] [-rnd] host rnum
Store records with keys of 8 bytes. They change as `00000001', `00000002'...
tcrtest read [-port num] [-cnum num] [-tout num] [-mul num] [-rnd] host
Retrieve all records of the database above.
tcrtest remove [-port num] [-cnum num] [-tout num] [-rnd] host
Remove all records of the database above.
tcrtest rcat [-port num] [-cnum num] [-tout num] [-shl num] [-dai|-dad] [-ext name] [-xlr|-xlg] host rnum
Store records with partway duplicated keys using concatenate mode.
tcrtest misc [-port num] [-cnum num] [-tout num] host rnum
Perform miscellaneous test of various operations.
tcrtest wicked [-port num] [-cnum num] [-tout num] host rnum
Perform updating operations of list and map selected at random.
tcrtest table [-port num] [-cnum num] [-tout num] [-exp num] host rnum
Perform miscellaneous test of the table extension.
Options feature the following.
-port num : specify the port number.
-cnum num : specify the number of connections.
-tout num : specify the timeout of each session in seconds.
-nr : use the function `tcrdbputnr' instead of `tcrdbput'.
-rnd : select keys at random.
-mul num : specify the number of records for the mget command.
-shl num : use `tcrdbputshl' and specify the width.
-dai : use `tcrdbaddint' instead of `tcrdbputcat'.
-dad : use `tcrdbadddouble' instead of `tcrdbputcat'.
-ext name : call a script language extension function.
-xlr : perform record locking.
-xlg : perform global locking.
-exp num : specify the lifetime of expiration test.
If the port number is not more than 0, UNIX domain socket is used and the path of the socket file is specified by the host parameter. This
command returns 0 on success, another on failure.
SEE ALSO ttserver(1), ttultest(1), ttulmgr(1), tcrmttest(1), tcrmgr(1), ttutil(3), tcrdb(3)Man Page 2010-01-20 TCRTEST(1)