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
gnome-phone-manager
GNOME-PHONE-MANAGER(1) User Commands GNOME-PHONE-MANAGER(1)NAME
gnome-phone-manager - Manage your mobile phone
USAGE
gnome-phone-manager [--identify <baddr>] [--config] [-d|--debug]] [--display=DISPLAY]
DESCRIPTION
This manual page documents briefly the gnome-phone-manager command.
gnome-phone-manager is a program created to allow you to control aspects of your mobile phone from your GNOME 2 desktop.
Current features include:
- Runs in the background; indicates status on the panel notification area,
- Display on-screen alert when text message (SMS) arrives,
- Text message (SMS) sending facility,
- Evolution Addressbook integration.
OPTIONS
Help Options:
-?, --help
Show help options
--help-all
Show all help options
--help-gtk
Show GTK+ Options
--help-gst
Show GStreamer Options
Application Options:
--identify <bdaddr>
Show model name of the device with Bluetooth address bdaddr.
--config
Write the configuration file for gnokii debugging
-d, --debug
Enable debug
--display=DISPLAY
X display to use
SEE ALSO
Homepage: http://live.gnome.org/PhoneManager
AUTHOR
gnome-phone-manager was written by Bastien Nocera <<hadess@hadess.net>> and Edd Dumbill <edd@usefullinc.com>
This manual page was written by Francesco Namuri <francesco@namuri.it> for the Debian project (but may be used by others).
Francesco Namuri July 2007 GNOME-PHONE-MANAGER(1)