Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
-
naveed.zuber
- Participant
- Posts: 19
- Joined: Wed Jul 16, 2014 4:14 am
Post
by naveed.zuber »
Please share your inputs on the issue.
INPUT: CSV file
SOURCE COLUMN A =V671U050117 (VARCHAR 50)
SOURCE COLUMN B=21 (VARCHAR 20)
OUTPUT Derivation:
TARGET COLUMN X (VARCHAR 256) =SOURCE COLUMN A : '_' : SOURCE COLUMN B
Expected OUTPUT:DB2 table
V671U050117_21
ACTUAL OUTPUT:
V671U050117?21
_ is loading as ? in target table
-
chulett
- Charter Member
![Charter Member Charter Member](./images/ranks/charter_member%s.gif)
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
What are the charactersets involved?
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
naveed.zuber
- Participant
- Posts: 19
- Joined: Wed Jul 16, 2014 4:14 am
Post
by naveed.zuber »
Thanks Craig!
Characterset used in UNICODE.
Please let me know in case of further questions.
-
chulett
- Charter Member
![Charter Member Charter Member](./images/ranks/charter_member%s.gif)
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
I meant for both the source and target... still the same answer?
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
qt_ky
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 2895
- Joined: Wed Aug 03, 2011 6:16 am
- Location: USA
Post
by qt_ky »
I wonder if you may be missing a DB2 environment variable.
Did you query the table outside of DataStage to see what it looks like?
Choose a job you love, and you will never have to work a day in your life. - Confucius
-
naveed.zuber
- Participant
- Posts: 19
- Joined: Wed Jul 16, 2014 4:14 am
Post
by naveed.zuber »
yes,both source and target are unicode characterset.
-
naveed.zuber
- Participant
- Posts: 19
- Joined: Wed Jul 16, 2014 4:14 am
Post
by naveed.zuber »
Thanks Eric.
Yes checked outside the DataStage environment also character looks '?'.