Hello Peasant.
Thanks for the reply.
But the expectation is different. If the person contains both roles say manager and interviewer. It should show only one record with manager. Please see below expected results. If no manager then name should pick next hierarchy interviewer.
Moderator's Comments:
Please use CODE tags as required by forum rules!
Last edited by RudiC; 08-23-2018 at 03:50 AM..
Reason: Added CODE tags.
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)
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)
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)
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)
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)
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)
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)
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)
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)
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 SUSE
virt-manager
VIRT-MANAGER(1) Virtual Machine Manager VIRT-MANAGER(1)NAME
virt-manager - display the virtual machine desktop management tool
SYNOPSIS
virt-manager [OPTIONS]
DESCRIPTION
virt-manager is a desktop tool for managing virtual machines. It provides the ability to control the lifecycle of existing machines
(bootup/shutdown,pause/resume,suspend/restore), provision new virtual machines and various types of store, manage virtual networks, access
the graphical console of virtual machines, and view performance statistics, all done locally or remotely.
OPTIONS
The following options are accepted when running "virt-manager":
-h, -help
Display command line help summary
-c URI, --connect=URI
Specify the hypervisor connection URI
--debug
List debugging output to the console (normally this is only logged in ~/.virt-manager/virt-manager.log). This function implies
--no-fork.
--no-fork
Don't fork "virt-manager" off into the backround: run it blocking the current terminal. Useful for seeing possible errors dumped to
stdout/stderr.
--no-dbus
Disable the DBus API used for remote control of the "virt-manager" UI
--no-conn-autostart
Don't autostart any libvirt connections when launching "virt-manager".
--show-domain-creator
Display the wizard for creating new virtual machines
--show-domain-editor=UUID
Display the dialog for editing properties of the virtual machine with unique ID matching "UUID"
--show-domain-performance=UUID
Display the dialog for monitoring performance of the virtual machine with unique ID matching "UUID"
--show-domain-console=UUID
Display the virtual console of the virtual machine with unique ID matching "UUID"
--show-host-summary
Display the main window summarizing performance for all virtual machines on the host.
AUTHOR
Written by Daniel P. Berrange.
BUGS
Please see http://virt-manager.org/page/BugReporting <http://virt-manager.org/page/BugReporting>
COPYRIGHT
Copyright (C) 2006-2007 Red Hat, Inc, and various contributors. This is free software. You may redistribute copies of it under the terms
of the GNU General Public License "http://www.gnu.org/licenses/gpl.html". There is NO WARRANTY, to the extent permitted by law.
SEE ALSO virsh(1), "virt-viewer(1)", the project website "http://virt-manager.org"
2010-03-23 VIRT-MANAGER(1)