I am new to stored procedures. I am trying to create a stored procedure, that has to accept the table name at run time & to display the records from that table.
SELECT * FROM TABLE_NAME. Here TABLE_NAME value has to be passed at run time. I tried to get samples from google,previous posts, even from the samples of the procedures from the SAMPLE directory. But there are nothing.
Can anyone kindly provide me some sample code,to do this.
The sample SpServer.java (provided in the samples/java/jdbc directory on your db2-server ) has several examples of dynamic select statements. Make it work for you.
The only thing you need to do is use your brain.
I know how to use My Brain.No need of your suggestions. U may be an expert on this technology. I have my own expertise. I am learning now. This is a public forum. Try to learn some thing first ,how to behave .....