Delete records in a file using SQL
Is it possible to delete records in a file using SQL when the file is not journaled? I get the error, "Member mymember not journaled to journal *N". Followed by, "myfile in mylib not valid for operation". What is happening?
If you use the right JDBC driver, you can set the JDBC properties for transaction isolation level on the database connection to 0 (none). This ISN'T a great idea for a production environment, but it will let you delete the records.
MORE INFORMATION ON THIS TOPIC
Check out these Best Web Links on Web development.
Ask the Experts yourself: Our Web development gurus are waiting to answer your questions.
Ask your Web development & WebSphere questions -- or help out your peers by answering them--in our
.fMFNafNPDOX.2@.ee84637!viewtype=&skip=&expand=>WebSphere & Web Development Forum.
This was first published in November 2004