i want to increase the varchar value

[pavankatra]

Hi,
Input value is: FFFFE8627324488
i want output as

FFFFE8627324489
FFFFE8627324490
FFFFE8627324491
FFFFE8627324492

so anyone please suggest me how to do this in datastage.

Thanks in advance.

[priyadarshikunal]

this seems to be a hexadecimal value instead of just increasing 1 like in decimal. Is that the case?

[pavankatra]

this seems to be a hexadecimal value instead of just increasing 1 like in decimal. Is that the case?

thanks for your post.

its a varchar datatype in the database.

[priyadarshikunal]

I am not asking about the datatype but I am asking about type of value stored in that column.

If you want to do as you mentioned in first post you should first check these things

'FFFFE' is just a prefix or its a hexadecimal value.
will the last 10 values always be digits?

[pavankatra]

I am not asking about the datatype but I am asking about type of value stored in that column.

If you want to do as you mentioned in first post you should first check these things

'FFFFE' is just a prefix or its a hexadecimal value.
will the last 10 values always be digits?

Thank you
actul requirement is
i need to generate the seqventially incremental number for 'x' column
that column is having data FFFFE8627324488B81035F2D16C26358
like the way.
so i want to split the first 15 digits and increase one and concatinate those .

so could you please tell me how can i acheive this in datastage.

thanks in advance.

[Sainath.Srinivasan]

So what comes after FFFFE8627324488B81035F2D16C99999 ?

[pavankatra]

So what comes after FFFFE8627324488B81035F2D16C99999 ?

so can you please suggest me what i need to do

i need to generate the unique number for that every time.

please help me out in this.

[chulett]

Substring, conversion, math, conversion, concatenation. Probably in a Transformer with stage variables.

[pavankatra]

Substring, conversion, math, conversion, concatenation. Probably in a Transformer with stage variables. ...

if u dontmind can you please elobratye it.

i am not able to understand.

thanks for your replies.

[priyadarshikunal]

So, Does this means the value is kind of hexadecimal surrogate key which you need to increament for each record passed?