Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
UPDATE SQL USING INNER JOIN
OK, lets see if a cup of coffee helps at all. I have a table (Table1) that contains the following fields. ITEMID (index) DCN (string) DocumentType (string) PolicyNumber (string) ReceiptDate (date) ScanDate (date) We are pulling information from another system where the policy number is... -
UPDATE SQL USING INNER JOIN
I have an update job that matches new values in a remote database, and I am having difficulties with getting the updates written back to the original table. Table 1 has two fields that I am concerned with DCN (Not Unique) PolicyNumber (Not Unique) I am getting a feed (Comma delimited file)... -
Java Stored Procedure performance issue...
with a tad bit of embarassment, I have located the flaw in execution. Being a little quick on the cut & paste caused me to miss a variable change cyclesql = "SELECT FROM DB2ADMIN.TMATCHES WHERE LOCATION = " + x; cycle = con.prepareStatement( sortsql )... -
Java Stored Procedure performance issue...
Hi all.. I have recently developed an update procedure for our imaging system using JDBC. The procedure performed updates on approx 13,000 records, and took just over 13 hours. This equates to 1 transactions per second... which is not acceptable for future use. My initial suspicions target the...
