Search found 733 matches
- Mon May 02, 2011 8:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: All zeros
- Replies: 5
- Views: 2353
A signed zero is a very unusual thing. EBCDIC '0C' is packed decimal +0, a rather common thing in many mainframe data repositories. Data attributes that include an explicit sign often require +0 as the default value. This is true in Cobol standards (when they are followed). Of course, unsigned zero...
- Wed Apr 27, 2011 10:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: EBCDIC
- Replies: 3
- Views: 1742
There are some details you haven't given us -- not complaining, just mentioning -- that might help decide on the right answer. I have had no problems letting DataStage handle character sets. I read EBCDIC and write ASCII without any explicit conversions in between. 1) The data type doesn't tell me w...
- Thu Apr 21, 2011 1:07 pm
- Forum: General
- Topic: Schedulers
- Replies: 2
- Views: 1778
- Tue Apr 12, 2011 12:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pad zero on leftside to integer
- Replies: 3
- Views: 4732
You may be a bit confused here: integer is a storage format, but you are describing a requirement for displaying the data. The easiest way to handle this is to convert the integer to a char or varchar before sending it to your display output. The only alternative is to store it in the display format...
- Tue Apr 12, 2011 7:07 am
- Forum: General
- Topic: ETL through COBOL
- Replies: 7
- Views: 5023
Please don't ask me for specifics -- I am not in a position to share code, regretfully -- but this is something to which I have had to give some thought. Your first step is to flowchart your Cobol programs. I have found that, in the absence of a utility for conversion, a flowcharted program can poin...
- Fri Apr 08, 2011 7:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading Fixed width
- Replies: 4
- Views: 2892
In general, trying to read EBCDIC mainframe files is actually simpler than one might expect. Try the following settings for your read format: Record level>>Record type=implicit Field defaults>>Delimter=none Type defaults>>General>>Character set=EBCDIC, Data format=binary Type defaults>>Decimal>>allo...
- Thu Apr 07, 2011 10:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: To read Lotus notes email attachment as input
- Replies: 6
- Views: 2155
Yeah, IBM owns Lotus. I'll suppress further commentary on that. :twisted: I see two problems: Can you be sure the attachment will always be in the correct OS format? Seems to me that Lotus runs under the Windows/DOS environment (unless your shop runs it on Unix?), and files will generally be stored ...
- Wed Apr 06, 2011 11:36 am
- Forum: General
- Topic: Passing Parameters for Multiple instance DS job
- Replies: 5
- Views: 7459
- Thu Mar 31, 2011 11:04 am
- Forum: General
- Topic: DB2 Datawarehouse and Datastage best practice
- Replies: 8
- Views: 7346
My direct DW experience is with 7x and Oracle (source data is DB2 or sequential datasets), so the following is a general comment. 1) To what use will the DW tables be put? If, for example, it's reporting of some kind, consider designing the fact tables with partitions that support the reporting peri...
- Tue Mar 29, 2011 1:37 pm
- Forum: General
- Topic: Premium Account Registration
- Replies: 2
- Views: 1537
- Mon Mar 28, 2011 10:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Header & Footer is missing
- Replies: 9
- Views: 2799
I deal primarily with COBOL datasets that have multiple record types in addition to header and trailer, so I've given some thought to what would be either easiest or least confusing. Ideally, your header and trailer records would have as many delimiters as your detail records. That is usually unlike...
- Fri Mar 25, 2011 9:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: FTP VB File from Mainframe to Datastage
- Replies: 2
- Views: 3925
The one setting you don't list is Record level>>Record Type=implicit. I've not tried that with a delimiter, but my read of mainframe data works just fine on any table definition I've used so far so long as it conforms to the LRECL setting. Each row fits nicely into the columns and implied widths the...
- Thu Mar 24, 2011 10:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: What is divide by zero rule.
- Replies: 18
- Views: 9256
After further thought, it occured to me that this issue should start in the requirements. Any amount that is intended to be used as a denominator should have error handling for zero before it gets to the calculation. In COBOL, this is a standard item for an entire paragraph that does nothing but val...
- Wed Mar 23, 2011 12:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: What is divide by zero rule.
- Replies: 18
- Views: 9256
I am calculating a column like this Column A = (Column B+Column C)/Column D Now if suppose a zero value comes at Column D then the Datastage will through an exception ..or an error so how can I handle this.. ???? Standard approach: Insert If condition before doing calculation that defaults Column A...
- Fri Mar 18, 2011 3:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: What is divide by zero rule.
- Replies: 18
- Views: 9256