Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    AUS
    Posts
    26

    Unanswered: insert a symbol into a character variable

    hi all,
    is it possible to store the symbol ' in a charcter . If yes how do we do that.

    melb

  2. #2
    Join Date
    Nov 2003
    Location
    kualaumpur
    Posts
    33

    Thumbs up Try this

    Hi you can try this

    C:\Documents and Settings\db2admin>db2 insert into test1 values('12345''67')
    DB20000I The SQL command completed successfully.

    C:\Documents and Settings\db2admin>db2 select * from test1

    T1
    ----------
    12345'67

    1 record(s) selected.


    TIA

    Trinmoy

  3. #3
    Join Date
    Aug 2003
    Location
    AUS
    Posts
    26
    Hi Trinmoy,

    Thanks for that. It worked

    cheers
    Melb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •