Search found 20 matches

by Boris69
Tue Nov 10, 2009 10:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Degree ° symbol issue from DB2 on AS/400
Replies: 4
Views: 6113

The 0x90 character is not mapped as part of standard EBCDIC, but is present in some variations. I don't know exactly which version is in use on your AS/400 system, but if you get that information and ... Field is defined as CCSID of 37 on AS/400 What other information do you want me to provide? tha...
by Boris69
Mon Nov 09, 2009 12:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Degree ° symbol issue from DB2 on AS/400
Replies: 4
Views: 6113

This might be the AS/400 conversion from EBCDIC. Have you tried setting $APT_EBCDIC_VERSION to IBM01141? ... I created user defined var APT_EBCDIC_VERSION on project level. Then added it on a job level with value of IBM01141. No effect. Degree symbol is not correct. Are my steps correct? thanks a lot
by Boris69
Wed Sep 30, 2009 3:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: # inside field name
Replies: 5
Views: 1608

on a source side I can do smth like select xxx$ as xxxx but on a target side the only option is to rename field ? create view? sounds strange. Database creation is outside of my control
by Boris69
Wed Sep 30, 2009 2:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: # inside field name
Replies: 5
Views: 1608

# inside field name

I am getting error if field name has $ in it. Is it a bug? Any easy way to avoid it?

thanks a lot
by Boris69
Mon Jul 20, 2009 1:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: fd_set Error
Replies: 1
Views: 1173

fd_set Error

I am getting error message
Fatal Error: File descriptor out of range in fd_set (requested 1044, limit 1023
I am moving DB2 data to Oracle, file on DB2 is very large (in terms of number of fields, 254)
any ideas?

thanks a lot