Char to Varchar convert
Moderators: chulett, rschirm, roy
Char to Varchar convert
Hi !
If any way to convert char to varchar inside DS ?
If any way to convert char to varchar inside DS ?
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
Re: Char to Varchar convert
You can use CAST from char to varchar.Its not a DS function but a DB (oracle ) function.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It IS the same in DataStage. However the metadata in your DataStage job design are used to communicate with the database server, which is the origin of your metadata mismatch warnings. But you can take that Char column and direct it across a Transformer stage into a VarChar with no derivation expression other than the input column.
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.
-
- Premium Member
- Posts: 503
- Joined: Wed Jun 29, 2005 8:14 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
As I said, "you can take that Char column and direct it across a Transformer stage into a VarChar with no derivation expression other than the input column". There is no error. There is no CAST required.
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.