Search found 19 matches

by leathermana
Tue Feb 25, 2014 11:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: COBOL flat file import
Replies: 28
Views: 20527

Trying to access the FAQ, I am getting: "Sorry, but only users granted special access can read topics in this forum."
How do I get "special access"?
by leathermana
Mon Feb 24, 2014 5:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: COBOL flat file import
Replies: 28
Views: 20527

COBOL flat file import

I have what I think is a simple question but have not found a simple answer yet. Please clue me in. I need to import a COBOL flat file with a couple hundred fields, 5 of which are decimal COMP-3, and two of which are COMP. I think I see that I may be able to import the COMP-3 fields into a sequentia...
by leathermana
Wed Nov 20, 2013 12:23 pm
Forum: General
Topic: Translate EBCDIC comparison sql to ASCII
Replies: 3
Views: 1808

Thanks. I ended up using CASE WHEN to do the comparison logic updates on the fly in the SELECT statement in the ODBC Connector stage. Since the Select is executed on the DB2 database, the original logic using EBCDIC comparisons worked fine. The only iffy thing is that the "Select statement"...
by leathermana
Fri Nov 01, 2013 8:13 am
Forum: General
Topic: Translate EBCDIC comparison sql to ASCII
Replies: 3
Views: 1808

Translate EBCDIC comparison sql to ASCII

I am converting data load processes currently being done with COBOL and Unix scripts to DataStage. One of the existing queries does comparison selections (<, >, <=, >=) on a CHAR(3) DB2 field which holds mixed alpha and numeric characters. The incoming DB2 data is EBCDIC in which alpha < numeric. On...