Raosaheb Patil

Greenhorn
+ Follow
since Jan 07, 2004
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Raosaheb Patil

Please check the following Code. Am I missing something?
It gives runtime error with "result.getInt("FY")".But if we substitute
the real Values it works fine...

SelStmt= "Select t1.* "
+ "from program t1, quarter t2 "
+ "where (t1.fy=t2.fy and t1.quarter= t2.quarter) and activity_grp_code='PA'";

stmt = con.prepareStatement(SelStmt);
bFlag = stmt.execute();

result = stmt.getResultSet();
max = stmt.getMaxRows();
String Seltmpsql;
ResultSet SeltmpResult;
boolean tmpFlag;
PreparedStatement Seltmpstmt = null;
Seltmpsql="Select sdate,edate from quarter "
+"Where" + result.getInt("FY");
How to declare a temporary table in an Java stored procedure
using DB2 at the back end....?
Where can i learn the nuts and bolts of JDBC ? Especially appending the
strings in the query.....
while( icnt<10 )
{

sql="INSERT INTO NJADE.ESA91CNTMQY"
+ "("
+ "LK,"
+ "DK,"
+ "PS,"
+ "FY"
+ ")"
+ "VALUES"
+ "("
+ "ER" + "'" + cnt + "',"
+ "'E',"
+ "'O',"
+ "10"
+ " )";
stmt = con.prepareStatement( sql );
cnt++;
}
[ January 09, 2004: Message edited by: Bear Bibeault ]

Originally posted by Jeanne Boyarsky:
IBM has a redbook on this.


Thanks for your help
Does anybody have idea about writing stored procedure using Java
on DB2?.