row generator---->modifystage----->target
In my row generator, i am having two columns as
name,id
xxxxx,12
yyyyy,13
zzzzzz,14
for name, my datatype is varchar
but in id, my datatype is varchar bcos i m unable to define the datatype as integer in row generator. so i have given as varchar for column 'id'.
using modify stage how can i convert the datatype from 'varchar' to 'integer' for the column 'id'.
Pls solve the issue.
Modify Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 23
- Joined: Sat Sep 29, 2007 6:05 am
- Location: Datastage
- Contact:
Modify Stage
Murali
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Professionalism Note
Please eschew SMS-style abbreviations. DSXchange is not a mobile phone; we expect a professional standard of writing.
The Row Generator can generate data in any of the simple data types, of which Integer is one.
(It can not generate vectors or subrecords, which are non-simple data types.)
Perhaps you would like to justify your assertion
Please eschew SMS-style abbreviations. DSXchange is not a mobile phone; we expect a professional standard of writing.
The Row Generator can generate data in any of the simple data types, of which Integer is one.
(It can not generate vectors or subrecords, which are non-simple data types.)
Perhaps you would like to justify your assertion
mcs_murali83 wrote:i m unable to define the datatype as integer in row generator
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Modify Stage
i will give small example of type convertion please find below type convertion functionmcs_murali83 wrote:row generator---->modifystage----->target
In my row generator, i am having two columns as
name,id
xxxxx,12
yyyyy,13
zzzzzz,14
for name, my datatype is varchar
but in id, my datatype is varchar bcos i m unable to define the datatype as integer in row generator. so i have given as varchar for column 'id'.
using modify stage how can i convert the datatype from 'varchar' to 'integer' for the column 'id'.
Pls solve the issue.
Column_Name=type_conversion('Column_Name')
the same example you need to specify in the stage specification.......propertybox.
sivaram
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: