Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433

    Unanswered: error with concat

    when issuing a simple concat command through db2 clp ,its not working giving error
    however in interactive mode its working fine...

    SQLLIB\BIN>db2 values('rahul'||'singh')
    .... error SQL0104N

    however with interactive mode

    db2 => values('rahul'||'singh')

    1
    ----------
    rahulsingh

    what can be the problem??

    Thanks,
    Rahul Singh

  2. #2
    Join Date
    Feb 2005
    Location
    Bangalore,India
    Posts
    39
    Use DOUBLE QUOTES to diffrentiate the DB2 and OS commands.

    db2 "values('rahul'||'singh')"

Posting Permissions

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