Search found 733 matches
- Thu Jul 14, 2011 10:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Newbie question regarding a debugger
- Replies: 12
- Views: 6942
Simon, it looks like you seek functionality that doesn't exist: debugging access to the data being processed while the job is running. DS provides Peek and other debug stages, but I don't see that helping you. The only workaround I can think of is to insert copy stages at the points where you want t...
- Wed Jul 13, 2011 2:22 pm
- Forum: General
- Topic: XML Stage in 8.5 FP1
- Replies: 7
- Views: 2590
Don't be afraid to experiment. I had similar beginner's questions at one point, and Ernie's seemingly vague (high-level!) responses were actually very helpful. I'm working in 7x, so I don't know if this is still true, but I was able to import the schema using sample xml data files in the expected fo...
- Tue Jul 12, 2011 10:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: COBOL Bit Field
- Replies: 6
- Views: 2899
Gods, sometimes I hate Google. It thinks it knows better than I do what I want. :?
Anyway, found this: http://www.tek-tips.com/viewthread.cfm? ... 04&page=66
Anyway, found this: http://www.tek-tips.com/viewthread.cfm? ... 04&page=66
Let me know if that works.In other words, PIC 1(8) would be the same as PIC 9(1) COMP-5.
- Tue Jul 12, 2011 9:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: COBOL Bit Field
- Replies: 6
- Views: 2899
I'm unfamiliar with the clause PIC 1 (#). Is there a usage clause in the Cobol code for the field in question? Anyway, I'm not sure how helpful I can be without understanding the storage format you are facing under EBCDIC. One thing I do know in 7x, there is darn little help converting raw binary to...
- Mon Jul 11, 2011 11:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: New line character issue for sequential file stage
- Replies: 17
- Views: 13766
It depends on where the '\n' is causing you the trouble. Without seeing your code, I would expect one of two possibilities: 1) If you don't control this until the file stage, that is where you set the alternate value for end-of-record, in Format/Record level/Record delimiter string. After that, you ...
- Mon Jul 11, 2011 10:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: New line character issue for sequential file stage
- Replies: 17
- Views: 13766
An old trick I learned from an assembler programmer that seems good regardless of the envirnoment: 1) Use some other special character for the end-of-record mark, one you are sure will not appear in the rest of the data. 2) Go ahead and remove all '\n' from every record. 3) Convert the end-of-record...
- Fri Jul 08, 2011 10:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problems using File Pattern option with DataStage in Windows
- Replies: 9
- Views: 5948
- Fri Jul 08, 2011 9:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problems using File Pattern option with DataStage in Windows
- Replies: 9
- Views: 5948
I don't have a sample that comes close to your situation, but I do have a question for our gurus: If the OS is Windows, does that mean that the DS runtime environment is running on a Windows server, or is it still on a Unix server? That said, the times I've run into this sort of problem I've looked ...
- Tue Jul 05, 2011 9:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Procedure stage: New columns not returned
- Replies: 1
- Views: 1212
- Tue Jul 05, 2011 7:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Procedure stage: New columns not returned
- Replies: 1
- Views: 1212
Stored Procedure stage: New columns not returned
I and the person for whom I'm asking this are new to SP stages in general, this being an "inherited" job that needs enhancement. We are open to the possibility that this is a problem on the DB2 side, though it doesn't look that way so far. Existing SP was in use with no problems. Two colum...
- Tue Jun 21, 2011 8:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading Fixed width file
- Replies: 3
- Views: 2289
Based on what you wrote in your post, you might be misunderstanding how the decimal attribute is applied to the data. For example, your first field (if I read you correctly) should be ( 4 ,2), not (2,2). Your field length is four with two positions to the right of the decimal. If I'm correct, that's...
- Mon Jun 20, 2011 11:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: datastage job creating mainframe dataset
- Replies: 5
- Views: 6186
http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/index.jsp?topic=/com.ibm.swg.im.iis.ds.zosfilestage.doc/topics/overview_zosfile.html According to that page, if you can read from z/OS to Unix with the Zos file stage, you should be able to write to it. You might have a problem with something o...
- Mon Jun 20, 2011 11:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: datastage job creating mainframe dataset
- Replies: 5
- Views: 6186
- Wed Jun 08, 2011 3:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: packed unsigned decimal
- Replies: 2
- Views: 3356
That's just cool, Donny. I haven't learned something new in COBOL in ages. I found an old Merant (MicroFocus) reference for comp-6 at http://esd.netmanage.com/Documentation/books/sx20books/cgrmdf.htm . My MicroFocus reference is old and doesn't mention comp-6. I suggest experimenting. Try what I des...
- Wed Jun 08, 2011 3:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: View data in CFF
- Replies: 9
- Views: 4240