i want to increase the varchar value
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 86
- Joined: Wed Mar 03, 2010 3:09 am
i want to increase the varchar value
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.
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.
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 86
- Joined: Wed Mar 03, 2010 3:09 am
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
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?
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?
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
-
- Participant
- Posts: 86
- Joined: Wed Mar 03, 2010 3:09 am
Thank youpriyadarshikunal wrote: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?
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.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 86
- Joined: Wed Mar 03, 2010 3:09 am
-
- Participant
- Posts: 86
- Joined: Wed Mar 03, 2010 3:09 am
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI