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.![Wink :wink:](./images/smilies/icon_wink.gif)
Genius may have its limitations, but stupidity is not thus handicapped.
![Wink :wink:](./images/smilies/icon_wink.gif)
-
- 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