update query

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
rekha
Member
Posts: 4
Joined: Wed Aug 27, 2008 12:00 pm
Location: coimbatore

update query

Post by rekha » Wed Dec 10, 2008 5:38 pm

Hi natarajan,
I tried with the query wat u said but it is showing error while compiling like iilegal symbol .Here is my query
SELECT PART_NAME, COLOR
FROM PART_TABLE
( UPDATE PART_TABLE
SET COLOR = 'PURPLE'
WHERE PART_NAME LIKE 'A%' ) if u r online please reply soon.......

User avatar
Natarajan
Moderator
Posts: 537
Joined: Fri Oct 10, 2008 12:57 pm
Location: chennai
Contact:

Post by Natarajan » Wed Dec 10, 2008 5:58 pm

Please dont create new topic.... reply to the same topic

Use your old topic
http://www.mainframegurukul.com/Mainfra ... php?t=3648

click on reply ... dont click on post.. it will create new topic..


Moderators - Please delete this duplicate topic.
Natarajan
Chennai

User avatar
Natarajan
Moderator
Posts: 537
Joined: Fri Oct 10, 2008 12:57 pm
Location: chennai
Contact:

Post by Natarajan » Thu Dec 11, 2008 4:09 pm

Hi Rekha,

Please post this in your original topic. so that i can reply.
i can't reply give the answer in this thread/topic... because this thread/topic will get deleted by moderator of this forum.

i hope you understand my words.
Natarajan
Chennai

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others