954,523 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Sql procedre need help

Hi,

Can you help me please I am still beginner in the IBM data studio,my problem is that i want to use the existing table in the SAMPLE database,I want to querry on the 4 tables,like in employee table or etc...in using the stored procedure can you help me please what are the commands to use in this I have no idea on this.Thank you in advance and i am hoping for your positive response..

jemz
Master Poster
763 posts since Jan 2010
Reputation Points: 9
Solved Threads: 0
 

Are you using DB2? Or some other dbms?

rubberman
Posting Virtuoso
1,564 posts since Mar 2010
Reputation Points: 277
Solved Threads: 179
 
Are you using DB2? Or some other dbms?


yes i am using db2

jemz
Master Poster
763 posts since Jan 2010
Reputation Points: 9
Solved Threads: 0
 

The easiest thing to do is to use the .net ODBC libraries.

rubberman
Posting Virtuoso
1,564 posts since Mar 2010
Reputation Points: 277
Solved Threads: 179
 
The easiest thing to do is to use the .net ODBC libraries.


Thanks for the reply... .net ODBC libraries but how?can you give me some steps sir..

sir question,is it possible to create table and then insert some data to the table in one stored procedure?Please help me thank you in advance and im hoping for your positive repsponse.

jemz
Master Poster
763 posts since Jan 2010
Reputation Points: 9
Solved Threads: 0
 

Sounds like you need to do some serious reading. Answering these questions are not simple and I don't have the time to hold your hand - that's what I do for a living...

1. Go to the Microsoft web site and look up documentation for .net and odbc in that environment.

2. Creating DB2 stored procedures is not something I have a lot of experience with (Oracle and Sybase/SQL-Server I do). Go to IBM's DB2 web site for documentation on that. The short answer to your question is: yes, you probably can create a table and then insert data into it in one stored procedure.

rubberman
Posting Virtuoso
1,564 posts since Mar 2010
Reputation Points: 277
Solved Threads: 179
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You