DB2 Basics: Quotation Marks

You may also like...

4 Responses

  1. Chris Aldrich says:

    Nice concise article. I like it. I found out the hard way about the single quote being an escape character. I didn’t know you can escape double quotes with a double quote. I have had to do some interesting shell/SQL scripting before. I always found it helpful to nest the different layers of quoting so I can tell which opens and closes which area and which escape character I need to use (DB2’s or the OS’s). Also helps to know the escape character for your OS. I work with AIX and KSH where it happens to be \.

    And good point on the copying and pasting of items out of Word. I *never, ever* work in Word anymore. I always use a plain text editor like Notepad++ so I don’t encounter issues like this. Reminds me of that code page conversion post you had a bit back (http://db2commerce.com/2013/05/14/what-to-do-with-a-character-you-cannot-query/). I’m sure that is part of what goes on there in the copy/paste from Word.

    • Ember Crooks says:

      I always work through TextMate when it’s just me – or vim if I really don’t need anything fancy. Love working on a Mac with those options. But many developers do love their Microsoft products.

      And when scripting, I work in perl, which also uses \. Scripting sure teaches you this stuff in spades.

  2. rajesh pandhare says:

    Very useful tips for MS-Word lover like me 🙂 ,because of the problem I started using EditPlus, this topic covers basic but critical part.

  1. March 20, 2014

    […] DB2 Basics: Quotation Marks […]

Leave a Reply

Your email address will not be published. Required fields are marked *