473,322 Members | 1,352 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Write a stored procedure with a table name as an argument to insert data into table

the procedure should take the table name as input from argument.and data will be inserted to the table mentioned in the argument list
Sep 27 '10 #1
1 2010
vijay2082
112 100+
Hi,

Look in the below site for " building an insert statement for some hints/tip"

http://www.db2ude.com/

Cheers, Vijay
Oct 5 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: sbh | last post by:
I need to copy data from a table on one Oracle server to another. Scenario: Need to create a stored procedure in server a, database aa that will copy data from server b, database bb, table bbb to...
3
by: thirdman | last post by:
I'm trying to write a SQL that stores a result from a stored-procedure into a temporary table. Is there any way of doing this?
8
by: Thomasb | last post by:
With a background in MS SQL Server programming I'm used to temporary tables. Have just started to work with DB2 ver 7 on z/OS and stumbled into the concept of GLOBAL TEMPORARY TABLE. I have...
2
by: trialproduct2004 | last post by:
Hi all i am new to sql server. i want to write stored procedure in sql server to insert values into two table whose structure is same. i have one condition depending on which i am inserting...
3
by: Bilbo | last post by:
I have a a headscratcher here: I have a form that when submitted should do 2 things when a user enters data and then clicks the Add button. Here goes: 1. Call a stored procedure called...
2
by: satish | last post by:
hi, i am a learner of ms -sql server 2000, i had a doubt in stored procedures suppose i have a data base having 20 tables, all the tables have a column named--DATE can we write a store...
4
by: MooseManDan | last post by:
I have a linked table DOWNLOAD (MS excel spreadsheet) that I copied all the information over to in MAIN DATA table, but added more fields to MAIN DATA. How do I create the relationship to...
2
by: TruptiYadav | last post by:
i know the child table and i have the foreign key with me . but the DB2 script has been written by someone else and i dont know how to get the prant table name. is there any way to know the...
4
by: ranu2006 | last post by:
Hi All, I want to write a stored procedure that can fetch Hierarchical data from a table I will be passing Employee Name and I want to fetch his seniors employees and his junior employees ...
2
by: riyap | last post by:
hi can anyone help me to simplify my logic in writing code, i have ms acess database table.i want to get the data from there(using select command with where clause) and insert into a stored...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.