02-10-2018
Please clarify: Do you want
- database tables modified or inserted using
- db internal tools (artisan[?] / SQL / ...)
- external tools working on query results
- output files to be operated upon
- with which tools
- with which results (store / print / transfer / ...)
Last edited by RudiC; 02-10-2018 at 04:13 PM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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)
Discussion started by: jerardfjay
1 Replies
2. Shell Programming and Scripting
if u have a data
2 4 6 8 5 4 4 5 6
then result shud be like
2
4
6
7
5
4
4
5
6 (3 Replies)
Discussion started by: cdfd123
3 Replies
3. Shell Programming and Scripting
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)
Discussion started by: kaponeh
5 Replies
4. Shell Programming and Scripting
abc
xyz
-
-
-
-
-
-
-
-
-
-
-
How to sort the second column in ascending order. (2 Replies)
Discussion started by: sandy1028
2 Replies
5. Shell Programming and Scripting
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)
Discussion started by: nricardo
4 Replies
6. Shell Programming and Scripting
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)
Discussion started by: babom
3 Replies
7. Shell Programming and Scripting
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)
Discussion started by: sai_2507
3 Replies
8. Shell Programming and Scripting
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)
Discussion started by: Hypesslearner
1 Replies
9. Programming
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
10. UNIX for Beginners Questions & Answers
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
string::parity
Parity(3) User Contributed Perl Documentation Parity(3)
NAME
String::Parity, setEvenParity, setOddParity, setSpaceParity, setMarkParity, isEvenParity, isOddParity isSpaceParity, isMarkParity, Even-
Bytes, OddBytes, SpaceBytes, MarkBytes, showParity, showMarkSpace - Parity (odd/even/mark/space) handling functions
SYNOPSIS
use String::Parity;
use String::Parity qw(:DEFAULT /show/);
DESCRIPTION
setEvenParity LIST
Copies the elements of LIST to a new list and converts the new elements to strings of bytes with even parity. In array context
returns the new list. In scalar context joins the elements of the new list into a single string and returns the string.
setOddParity LIST
Like setEvenParity function, but converts to strings with odd parity.
setSpaceParity LIST
Like setEvenParity function, but converts to strings with space (High bit cleared) parity.
setMarkParity LIST
Like setEvenParity function, but converts to strings with mark (High bit set) parity.
EvenBytes LIST
Returns the number of even parity bytes in the elements of LIST.
OddBytes LIST
Returns the number of odd parity bytes in the elements of LIST.
SpaceBytes LIST
Returns the number of space parity bytes in the elements of LIST.
MarkBytes LIST
Returns the number of mark parity bytes in the elements of LIST.
isEvenParity LIST
Returns TRUE if the LIST contains no byte with odd parity, FALSE otherwise.
isOddParity LIST
Returns TRUE if the LIST contains no byte with even parity, FALSE otherwise.
isSpaceParity LIST
Returns TRUE if the LIST contains no byte with mark parity, FALSE otherwise.
isMarkParity LIST
Returns TRUE if the LIST contains no byte with space parity, FALSE otherwise.
showParity LIST
Like setEvenParity function, but converts bytes with even parity to 'e' and other bytes to 'o'. The function showParity must be
imported by a specialised import list.
showMarkSpace LIST
Like setEvenParity function, but converts bytes with space parity to 's' and other bytes to 'm'. The function showMarkSpace must
be imported by a specialised import list.
NOTES
Don't use this module unless you have to communicate with some old device or protocol. Please make your application 8 bit clean and use the
internationally standardised ISO-8859-1 character set.
AUTHOR
Winfried Koenig <win@in.rhein-main.de>
SEE ALSO
perl(1), Exporter(1)
perl v5.8.0 1996-12-10 Parity(3)