Search code examples
sap-ase

Alternative datatype for ident and varchar(max)

I am converting a SQL stored procedure to Sybase ASE.

I came cross some datatypes like:

declare @mask ident
declare @type ident
declare @start varchar(max)

Ident and varchar(max) are not supported in Sybase ASE. What will be the correct alternative datatype which I can use?

Solution

  • In Sybase ASE, the value for a varchar can be anything up to the pagesize of the server (2k,4k,8k or 16k are the available page sizes.)

    Sybase doesn't have an ident datatype, but you can create a user defined datatype that can be used instead.

    sp_addtype ident, "numeric(5)", "identity"

    There's more information here, in Sybase's Transact-SQL User's Guide