You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » [resolved] Select issues in tMap for my DB2400 extractions
#1 2010-05-04 16:01:11
- benoxy
- Member
- Registered: 2009-06-26
- Posts: 15
[resolved] Select issues in tMap for my DB2400 extractions
Hi, I tent to extract rows from my db2400 to a mysql database with talend. I tried to use TRIM function but for same results.
tMap select used :
row1.STDOS==50 && row1.ARTPRD=="SK"
row1.STDOS==50 && StringHandling.BTRIM(row1.ARTPRD)=="SK"
STDOS is a numeic field and ARTPRD is string field. But select don't work fine, no rows are extract. If i use only numerics fields for my select, rows extraction is ok. But when I use string fields, I don't have the expected data.
Any suggestions to debug this issue please?
Offline
#2 2010-05-05 16:23:33
Re: [resolved] Select issues in tMap for my DB2400 extractions
Hello
try
Code:
row1.STDOS==50 && row1.ARTPRD.equals("SK")
or
row1.STDOS==50 && StringHandling.BTRIM(row1.ARTPRD).equals("SK")Best regards
Shong
Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » [resolved] Select issues in tMap for my DB2400 extractions