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
if i use the commands (one by one) on the host it works...but i cant use it as "remote"-command...its like he is doing the first part but he cant do the second...can someone help me??
Moderator's Comments:
Please use code tags next time for your code and data. Thanks
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 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)
Hello,
Can someone please advise me how to put the db2 query reult into an array?
For example, the query reults are:
string A
string B
string C
Then how do I put them into array=string A
array=string B
... (2 Replies)
When I use export for sql query in a Script :
Select '1',ModHist',count(*) from cc.mdhist;
it was exporting the record to a file as:
"1" "ModHist" 778201
Here 1 & ModHist are coming in Doublequotes.
If I run the above query directly in Unix prompt it was displaying the output as... (1 Reply)
I want to print the output of a db2 query, on to an unix file in a manner that the columns are separated by 'commas'. Please help me out..thanx in advance (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..
my requirement is following:
i want to have a shell script that queries a table i.e. fcm_auth in database fcmcore (I use db2) to get no of rows present for a given combination eg org and logo for past 5-10 mins interval. You can take some values of org(numerical values) and corresponding... (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)
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
LEARN ABOUT CENTOS
paperconf
PAPERCONF(1) General Commands Manual PAPERCONF(1)NAME
paperconf - print paper configuration informations
SYNOPSYS
paperconf [ [ -p ] paper | -d | -a ] [ -z ] [ -n | -N ] [ -s | -w | -h ] [ -c | -m | -i ]
DESCRIPTION
paperconf prints informations about a given paper. The informations that can be obtaineed are the name of the paper, its size and its
width or height. When called without arguments, paperconf prints the name of the system- or user-specified paper, obtained by looking in
order at the PAPERSIZE environment variable, at the contents of the file specified by the PAPERCONF environment variable, at the contents
of the file /etc/papersize , consulting the values controlled by the LC_PAPER locale setting, or by using letter as a fall-back value if
none of the other alternatives are successful. By default, width and height of the paper are printed in PostScript points.
OPTIONS -p paper
Specify the name of the paper about which informations are asked.
-d Use the default builtin paper name.
-a Consider all known papers names.
-z If the paper name is unknown, print it but issue a message on the standard error and exit with a non-zero code.
-n Print the name of the paper.
-N Print the name of the paper with the first letter capitalized.
-s Print the size (width followed by height) of the paper.
-w Print the width of the paper.
-h Print the height of the paper.
-c Use centimetres as unit for paper size.
-m Use millimetres as unit for paper size.
-i Use inches as unit for paper size.
ENVIRONMENT
PAPERSIZE Paper size to use regardless of what the papersize file contains.
PAPERCONF Full path to a file containing the paper size to use.
FILES
/etc/papersize Contains the name of the system-wide default paper size to be used if the PAPERSIZE and PAPERCONF variables are not
set.
AUTHOR
Yves Arrouye <arrouye@debian.org>
SEE ALSO papersize(5)
24 April 2001 PAPERCONF(1)