|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Reading values from a file using DB2 SQL
Post 302321238 by kavithakuttyk on Sunday 31st of May 2009 09:19:45 AM
05-31-2009
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I new to Unix and scripting. Following is my requirement. Can someone tell me whether its possible or not. Also please let me know how to proceed further if this is possible.
List of queries are stored in a file. For example, I have to run a query like this:
Select * from &XYZ where... (0 Replies)
Discussion started by: simhasuri
0 Replies
2. UNIX for Dummies Questions & Answers
HI
I have something like this in a file
ABC = 1
DEF = 2
GHI = 3
JKL = 4
MNO = 5
QRS = 6
TUV = 7
I need to assign ABC to V_abc (that is to a variable)
GHI to V_ghi (that is to another variable)
TUV to say V_tuv
... (6 Replies)
Discussion started by: ssuresh1999
6 Replies
3. Programming
Hi Everyone,
I'm basically trying to rewrite a korn shell script that currently runs and execute a db2 SQL and then it presents the output below to the users. I wonder how I can achieve the same in Java using GUI's. Any advise / comments would be highly appreciated. Thanks.
DBNAME ... (1 Reply)
Discussion started by: arizah
1 Replies
4. Shell Programming and Scripting
Hi
I have a file in the following format
AFUE 0.
AOXI 0.
VFUE 100.0
VOXI 274.601
TFUE 298.
TOXI 2229.544
TMAX 2400.
What I want to do is write a bash script, that use either perl/awk or sed to read the number after VFUE and VOXI (which is 100.0 and... (1 Reply)
Discussion started by: lost.identity
1 Replies
5. Shell Programming and Scripting
I have sql query in shell script.
select distinct account_no from adj order by account_no;
This query returns account number daily.Sometimes it may return 90 rows sometime it may return 1 row only and someday it may return 0 rows
I am storing the output of this query in sql_output.txt.
... (5 Replies)
Discussion started by: rafa_fed2
5 Replies
6. Shell Programming and Scripting
Hi,
I have a large output file (star.log), with many lines of the following type
*** T vavg unburnt: 723.187 / burnt: 2662.000
What I would like to do is pick the values 723.187 and 2662.000 and
What I've got so far is
awk '/unburnt:.*burnt:/{Tu=$6;Tb=$NF}END{print Tu, Tb}'... (6 Replies)
Discussion started by: lost.identity
6 Replies
7. Shell Programming and Scripting
Hi gurus..
Am reading a file, counting number of lines and storing it in a variable. Then am passing that variable into If loop for comparision, if the number of lines are greater than 1000 it should split a file if not it should send the file name to archive folder.. but when i execute the... (4 Replies)
Discussion started by: azherkn3
4 Replies
8. 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
9. UNIX for Dummies Questions & Answers
hi guys, i want help... Reding XML file and print the values into the text file using linux shell script file as per below xml file
<sequence>
<Filename>aldorzum.doc</Filename>
<DivisionCode>US</DivisionCode>
<ContentType>Template</ContentType>
<ProductCode>VIMZIM</ProductCode>
</sequence>... (1 Reply)
Discussion started by: sravanreddy
1 Replies
10. UNIX for Dummies Questions & Answers
hi guys, i want help... Reding XML file and print the values into the text file using linux shell script file as per below xml file
<sequence>
<Filename>aldorzum.doc</Filename>
<DivisionCode>US</DivisionCode>
<ContentType>Template</ContentType>
<ProductCode>VIMZIM</ProductCode>
</sequence>... (4 Replies)
Discussion started by: sravanreddy
4 Replies
LEARN ABOUT PHP
db2_stmt_error
DB2_STMT_ERROR(3) 1 DB2_STMT_ERROR(3) db2_stmt_error - Returns a string containing the SQLSTATE returned by an SQL statement SYNOPSIS
string db2_stmt_error ([resource $stmt]) DESCRIPTION
Returns a string containing the SQLSTATE value returned by an SQL statement. If you do not pass a statement resource as an argument to db2_stmt_error(3), the driver returns the SQLSTATE value associated with the last attempt to return a statement resource, for example, from db2_prepare(3) or db2_exec(3). To learn what the SQLSTATE value means, you can issue the following command at a DB2 Command Line Processor prompt: db2 '? $sqlstate- value'. You can also call db2_stmt_errormsg(3) to retrieve an explicit error message and the associated SQLCODE value. PARAMETERS
o $stmt - A valid statement resource. RETURN VALUES
Returns a string containing an SQLSTATE value. SEE ALSO
db2_conn_error(3), db2_conn_errormsg(3), db2_stmt_errormsg(3). PHP Documentation Group DB2_STMT_ERROR(3)