Recent content by shann0nw

I get this error when updating a database I am working with (DB2 V7). I loop through the contents of a file and based on a flag U = Update, N = Insert & D = Delete, I perform the action on the item with the table. The table is three rows in length: id, part_number, qty. I have a unique index...

OK, I was under the impression that what I was doing was binding on each loop. I might try reading the entire file and then binding and then writing. I'll see how I go.

Marc, Yes, you are correct in the assumption the the U stands for Update and the N stands for new line. There is actually another part of the script which processes the older file formats which performs an update saving the result in to a variable and testing if it is equal to 0. (The result...

Hi MarcLodge, Thanks for your response. I really can't ask them to send two files and really, it should always only be an update and only be an insert when a new part is brought in to stock. I've included a snippet of what I'm doing in Java to give you an idea. BufferedReader bufferedInput...

Hi, I have created a Java program which I call each night at approximately 7PM whereby I pick up all files residing in a local directory in a pre-defined format. The format is basically part,quantity with the file name being [id].txt. From this, I create two PreparedStatements. 1 - INSERT...