DB2 equivalent of Transact SQL Stmts?

[attick111]

Does anyone know the DB2 equivalent of the following Sybase T-SQL statement

@numb int
select @numb=67

select @numb = @numb + 1
OR
select * from mytable where code_num > 67

 

[attick111]

Last stmt should read

select * from mytable where code_num > @numb