Search found 79 matches
- Mon Aug 15, 2011 11:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Complex Mainframe Parsing
- Replies: 1
- Views: 2034
Re: Complex Mainframe Parsing
Now we are planning to read the binary file, read the header column and split the records based on record type and give cobol copybook based on record types for parsing. Problem 1 We are not able to read the file as it has different record types. Any suggestions for implementing a solution for this...
- Mon Aug 15, 2011 11:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: IN condtion in Filter stage
- Replies: 4
- Views: 2776
- Thu Jul 21, 2011 7:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Tuning Data stage jobs for performance
- Replies: 2
- Views: 3263
Assuming that your production DB is different than your lower environment(?), have you isolated the problem to DataStage? [Do the queries run in the same amount of time on the DB directly in both places? Can you connect from a different tool using the same method and run the queries faster than DS?,...
- Fri Jun 10, 2011 6:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need suggestions on a specific task
- Replies: 1
- Views: 1912
- Mon Jun 06, 2011 4:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Output 10 records for 1 record
- Replies: 4
- Views: 9995
What do you need the 10 records for? If it is just a straight copy, use the Copy stage. I'm guessing it is more complex than that. If you need just part of the inbound record for each of the outbound, Copy is still a good choice. If you need to pivot the results or perform some sort of derivation to...
- Thu Jun 02, 2011 11:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Bussiness requirement
- Replies: 8
- Views: 5756
It depends on what the criteria are for your history. Type 1, type 2, etc. This will also be influenced by the type of reporting that will be needed from the archived data - and if there is going to be a need to be able to restore the data from your archive. CDC is commonly used. But if the needs do...
- Wed Jun 01, 2011 10:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Bussiness requirement
- Replies: 8
- Views: 5756
harish841913, Archiving can be a medium to very large scale project. In this case, it sounds like you are being asked to be the technical solution architect (or similar) role. Yet, you are asking for a free site, full of volunteers, to give you a plan for doing this? I hope, for your sake, that this...
- Tue May 31, 2011 5:25 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Divide a ring in 8 shape into two rings
- Replies: 8
- Views: 6135
Hi Prasant, With your code being one-way connections (A->E is not the same as E->A), and you doubling all of your connections, it makes sense that you are getting your paths in multiple - with each path duplicated in reverse (This is what is happening, correct?) The simplest solution I can think of ...
- Tue May 31, 2011 5:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: writing from oracle view to a oracle table?
- Replies: 2
- Views: 2666
There will be a log directory in your system with the name 'ora.3317770.688603.3.log.bad' The location is dependent upon your system setup. Find this file and look at it. It is a text file, so you can use your favorite editor (or just use 'cat' or 'more' or 'less') to view the contents and find the ...
- Tue May 31, 2011 9:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Divide a ring in 8 shape into two rings
- Replies: 8
- Views: 6135
C-B-A | | D----E---F | | G---H Is this what you mean? And you want to be able to detect both cycles and divide it like this: E---F | | G---H and C-B-A | | D----E I hope you understand that this is a very difficult puzzle for DataStage to solve, simply because of how each stage gets to look at the d...
- Wed Oct 20, 2010 11:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replace Special Characters in a String
- Replies: 6
- Views: 9469
I would expect that you would handle that in a Transformer stage. Depending on what is easier, you could check for valid numbers or search for 'special characters'. I'm not sure what your definition of a special character is for this derivation. From the example, it looks like anything that is not a...
- Wed Oct 20, 2010 11:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Special Characters Conversion Problem
- Replies: 2
- Views: 2818
If you could check on that - I believe there are steps that the DBAs have to take to enable Unicode in the database. If they have not been done, then it doesn't matter what you do with DataStage (well almost - there are some not-worthwhile ways you can 'hide' Unicode but it would take some custome e...
- Wed Oct 20, 2010 1:23 pm
- Forum: General
- Topic: Wait for File
- Replies: 10
- Views: 7152
An alternative would be to have a branch in your sequencer that it goes to if the file is not found. An execute command there does a sleep nnn to get you your 2 hours. Then you perform your check for the file again using ls and your file pattern. Abort if not found, merge the flow back in to the res...
- Wed Oct 20, 2010 1:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Special Characters Conversion Problem
- Replies: 2
- Views: 2818
Is Unicode enabled on the target table? Is Unicode setup on all intermediate links in the job(s) between the good source file and the database load? Can you confirm (maybe with a copy stage to a sequential file or dataset) if the data being pushed to the database has retained the special characters ...
- Tue Oct 19, 2010 9:44 am
- Forum: General
- Topic: Link Naming Standard
- Replies: 11
- Views: 7875
Don't work FranklinE, Your secret is safe with me. But I will agree that COBOL has its own set of challenges and quirks. A standard is what is used barely enough such that the developers who come later can clearly see where it was not used. I'll offer a corollary to your statement: A standard is onl...