regarding inserting

IBM's flagship relational database management system
Srujan
Posts: 1
Joined: Thu Jan 05, 2012 12:51 pm
Skillset: cobol,jcl,vsam,db2,cics,easytrieve
Referer: friend

regarding inserting

Postby Srujan » Thu Jan 05, 2012 2:11 pm

Hi All,

Is there any possibility for inserting multiple rows in a table.

If yes please provide the Query regarding that.

Thanks in advamce.

User avatar
Akatsukami
Global moderator
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Skillset: Rexx, JCL, DB2/SQL, TSO/ISPF, PL/I
Referer: ibmmainframes
Location: Bloomington, IL
Contact:

Re: regarding inserting

Postby Akatsukami » Thu Jan 05, 2012 9:44 pm

  1. You should have posted in the DB2 forum, not to the FAQ forum.
  2. This is a help board, not a "do my work for me so I can collect an undeserved salary" board.
  3. "Thanks in advance" is interpreted here to mean "When you give me the answer, I'll grab it in my greedy little hands and scuttle away, never to be hear from again...until the next time that I have a problem".
  4. Do not bother to whine, "We r here 2 share knowledge so do not reply if u do not give answer" or any similar yivshish.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day

User avatar
dick scherrer
Global moderator
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am

Re: regarding inserting

Postby dick scherrer » Fri Jan 06, 2012 9:44 am

Hello,

Is there any possibility for inserting multiple rows in a table.

Yes.

If yes please provide the Query regarding that.
No. There are examples in the db2 documentation. Read about multi-row insert. If you find something in the documentatino, post what you found andyour doubt. Someone here will be able to clarify.

If you get stuck, post what you have tried and where you need help.
Hope this helps,
d.sch.