08-21-2018
Dear
Perlbaby,
I have a few to questions pose in response first:-
- Is this homework/assignment? There are specific forums for these.
- What have you tried so far?
- What output/errors do you get?
- What OS and version are you using?
- What logical process have you considered? (to help steer us to follow what you are trying to achieve)
Most importantly,
What have you tried so far?
There are probably many ways to achieve most tasks, so giving us an idea of your style and thoughts will help us guide you to an answer most suitable to you so you can adjust it to suit your needs in future.
We're all here to learn and getting the relevant information will help us all.
Thanks, in advance,
Robin
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Dear Guyz:)
I have 2 different input files like this. I would like to pick the values or letters from the inputfile2 based on inputfile1 keys (A,F,N,X,Z).
I have done similar task by using awk but in that case the inputfiles are similar like in inputfile2 (all keys in 1st column and values in... (16 Replies)
Discussion started by: repinementer
16 Replies
2. Shell Programming and Scripting
Hi ,
I am using a db2 query to get the maximum sequence number from a field.Now this value is taking up only 2 places.(i.e its less than 100).It can grow up to 3 places later but me requirement is that when i write it in a text file, it should be padded upto 8 places.
Please help (1 Reply)
Discussion started by: lifzgud
1 Replies
3. Shell Programming and Scripting
Hi,
I have a requirement as below which needs to be done viz UNIX shell script
(1) I have to connect to an Oracle database
(2) Exexute "SELECT field_status from table 1" query on one of the tables.
(3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies
4. Shell Programming and Scripting
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)
Discussion started by: kanakaraju
1 Replies
5. AIX
I am new to AIX, but not new to the UNIX world. Recently I got a request to come with some kind of report to do the following: report if user query is using > 70% CPU (within DB2) > 5 minutes. I am by no means a DB2 guru so I do not know how to get that from within it, so I was wondering if there... (4 Replies)
Discussion started by: savigabi
4 Replies
6. Shell Programming and Scripting
Hi,
Im new to DB2.
I need to connect to DB2 from shell script and return the query output back to shell script variable.
this is my code
#!/bin/ksh
db_name=db
db_user=usr
db_pwd=pwd
db2 <<EOSQL
connect to $db_name user $db_user using "$db_pwd"
select count(1) from table
quit
EOSQL ... (3 Replies)
Discussion started by: sup
3 Replies
7. Shell Programming and Scripting
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)
Discussion started by: asandy1234
9 Replies
8. Shell Programming and Scripting
Hello,
i need some help with a script. I made a script, which connect to different hosts to get some informations. But i got now some problems with getting informations of a database (db2) which is on a other host. I tried something like
var=$(rsh HOST su - db2adm -c "db2 connect to database;... (2 Replies)
Discussion started by: Cyver
2 Replies
9. Programming
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)
Discussion started by: Perlbaby
3 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)