modify
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 57
- Joined: Mon Dec 03, 2007 12:43 am
- Location: hyderabad
modify
smallint to string conversion in modify stage
Will the modify stage implicitly converts smallint to string ?or do we need to manually do it?
i dont find any smallint to string conversion function in parallel job developer's guide
Will the modify stage implicitly converts smallint to string ?or do we need to manually do it?
i dont find any smallint to string conversion function in parallel job developer's guide
ramesh.n.
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 57
- Joined: Mon Dec 03, 2007 12:43 am
- Location: hyderabad
i created a sample job
DB2--->modify------>sort------->DB2
i used the following transformation
REMARK_OCCR_NR : nullable string[5] = REMARK_OCCR_NR
job ran but with following warnings
modify: When checking operator: When binding output schema variable "outRec": When binding output interface field "REMARK_OCCR_NR" to field "REMARK_OCCR_NR": Implicit conversion from source type "int16" to result type "string[5]": Converting number to string. [api/interface_rep.C:6248]
DB2--->modify------>sort------->DB2
i used the following transformation
REMARK_OCCR_NR : nullable string[5] = REMARK_OCCR_NR
job ran but with following warnings
modify: When checking operator: When binding output schema variable "outRec": When binding output interface field "REMARK_OCCR_NR" to field "REMARK_OCCR_NR": Implicit conversion from source type "int16" to result type "string[5]": Converting number to string. [api/interface_rep.C:6248]
Last edited by ramesh_inform on Wed Jul 02, 2008 9:34 pm, edited 1 time in total.
ramesh.n.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 57
- Joined: Mon Dec 03, 2007 12:43 am
- Location: hyderabad
The warning is DataStage saying...
'Look, it's implicit this conversion, please don't tell me how to do my job'
All you need for the Modify Specification is:
KEEP REMARK_OCCR_NR
The input is of type SmallInt (Int16), just set your output type to char[5] nullable.
I suspect you could do this in a copy stage if you don't have any explicit conversion requirements.
'Look, it's implicit this conversion, please don't tell me how to do my job'
All you need for the Modify Specification is:
KEEP REMARK_OCCR_NR
The input is of type SmallInt (Int16), just set your output type to char[5] nullable.
I suspect you could do this in a copy stage if you don't have any explicit conversion requirements.
-
- Participant
- Posts: 57
- Joined: Mon Dec 03, 2007 12:43 am
- Location: hyderabad