Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to insert name O' CONNELL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
suresh_gop1
Warnings : 1

New User


Joined: 23 May 2006
Posts: 18

PostPosted: Wed Jul 09, 2008 9:11 pm    Post subject: How to insert name O' CONNELL
Reply with quote

Hi,

How to insert char O 'CONNELL? i tried as insert into table name values ('O 'CONNELL'). but it returns error. how to correct it.
Back to top
View user's profile Send private message

Manuneedhi K

Active User


Joined: 07 May 2008
Posts: 115
Location: Chennai

PostPosted: Wed Jul 09, 2008 9:32 pm    Post subject:
Reply with quote

Whenever you want to insert a single quote you must use two single quotes .

(i.e) To insert O'Connell you must use 'O''Connell' in the values of the insert.
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Wed Jul 09, 2008 9:32 pm    Post subject: Re: How to insert name O' CONNELL
Reply with quote

suresh_gop1 wrote:
Hi,

How to insert char O 'CONNELL? i tried as insert into table name values ('O 'CONNELL'). but it returns error. how to correct it.


It would have nice if you had provided the error information.

try 'o ''connell'
Back to top
View user's profile Send private message
the_gautam

Active User


Joined: 05 Jun 2005
Posts: 165
Location: Bangalore

PostPosted: Thu Jul 10, 2008 3:35 pm    Post subject:
Reply with quote

you may use the escape character as well...
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to insert a value on specific pos... Poha Eater DFSORT/ICETOOL 9 Sun Oct 01, 2017 3:04 am
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts Insert Lines in JCL with Rexx after a... Willy Jensen CLIST & REXX 3 Tue Aug 30, 2016 4:18 pm
No new posts How to insert a lengthy string havin... vidyaa DB2 7 Thu Aug 25, 2016 5:20 pm
No new posts How do I right justify a string in an... rakesh17684 DB2 1 Wed Jun 08, 2016 8:01 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us