var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Update statement - Auto increment
Would like to know if DB2 has a equivalent for a update trick in MS SQl server
that can auto increment a column like serial no.
The statement is:
DECLARE @counter int
SET @counter = 0
SET @counter = slno = @counter + 1
slno is the column name here
This will set the value for the column 'counter' as 1,2,3 for each row.
Tried the above in DB2, but gives syntax error for two "=" symbols.
Iam on DB2 Z/os v10.
Last edited by techday; 03-28-12 at 07:15.