10-14-2014
It doesnt work...it return "closed connection" and the variable is empty.
Last edited by Cyver; 10-14-2014 at 11:16 AM..
10 More Discussions You Might Find Interesting
1. 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
2. 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
3. Shell Programming and Scripting
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)
Discussion started by: hanul
2 Replies
4. Shell Programming and Scripting
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)
Discussion started by: karumudi7
1 Replies
5. Shell Programming and Scripting
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)
Discussion started by: prasan_ven
1 Replies
6. 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
7. 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
8. Shell Programming and Scripting
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)
Discussion started by: nishantrefound
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. 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
LEARN ABOUT DEBIAN
roar_vs_vio_obj
roar_vs_connection_obj(3) RoarAudio Programmer's Manual roar_vs_connection_obj(3)
NAME
roar_vs_connection_obj, roar_vs_stream_obj, roar_vs_vio_obj - VS API interface for use of main API
SYNOPSIS
#include <roaraudio.h>
struct roar_connection * roar_vs_connection_obj(roar_vs_t * vss, int * error);
struct roar_stream * roar_vs_stream_obj (roar_vs_t * vss, int * error);
struct roar_vio_calls * roar_vs_vio_obj (roar_vs_t * vss, int * error);
DESCRIPTION
Those functions return internal connection, stream and VIO object of the VS object. They are used to use the main API with a VS opened
stream.
roar_vs_connection_obj() returns the connection object used for the control connection to the server.
roar_vs_stream_obj() returns the stream object storing information about the stream.
roar_vs_vio_obj() returns the VIO object used to read data from or send data to the server.
Returned objects are freed as soon as the VS object is closed. If the VS object was created using roar_vs_new_from_con(3) the connection is
not closed by the VS object and stay valid after close until it is closed by the program or library.
The VIO object MUST NOT be used while in buffered mode.
PARAMETERS
vss The VS object to return internal objects from.
error This is a pointer to a integer used to store the error value in case of error. This can be NULL if not used but it is very recom-
mended to use this error value to report good error messages to the user.
RETURN VALUE
On success these calls return the described object. On error, NULL is returned.
EXAMPLES
FIXME
SEE ALSO
roarvs(7), libroar(7), RoarAudio(7).
RoarAudio May 2011 roar_vs_connection_obj(3)