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...

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).