Results 1 to 2 of 2

Thread: @ in SQL query

  1. #1
    Join Date
    Dec 2007
    Posts
    30

    Unanswered: @ in SQL query

    is there any @ symbol which we can use in SQL queries
    if so can u tell me the purpose of it.
    actually i have seen it in queries running on db2(v8.2) databases.
    any help is appreciated.
    thanks...

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    That character has no special meaning in DB2 syntax, but it is sometimes used as a statement terminator (instead of the default ';') in situations where a stored procedure, function or trigger is used (since these use ';' as line terminators and need something different as the statement terminator in the create statement).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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