DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 79 matches
Author Message
 Topic: Complex Mainframe Parsing
jcthornton

Replies: 1
Views: 1071

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Aug 15, 2011 11:52 am   Subject: 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 ...
Resolved
 Topic: IN condtion in Filter stage
jcthornton

Replies: 4
Views: 1274

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Aug 15, 2011 11:41 am   Subject: IN condtion in Filter stage
When it is populated should make no difference. Assign the list to the parameter that you want to use, and make sure it is in the right format. There is nothing that would change the evaluation base ...
 Topic: Tuning Data stage jobs for performance
jcthornton

Replies: 2
Views: 2120

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Jul 21, 2011 7:35 am   Subject: Tuning Data stage jobs for performance
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 pla ...
 Topic: Need suggestions on a specific task
jcthornton

Replies: 1
Views: 957

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 10, 2011 6:36 am   Subject: Need suggestions on a specific task
Looks like you need to do some aggregation or remove duplicates as well (group by)
 Topic: Output 10 records for 1 record
jcthornton

Replies: 4
Views: 7821

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jun 06, 2011 4:52 pm   Subject: Output 10 records for 1 record
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 outb ...
 Topic: Bussiness requirement
jcthornton

Replies: 8
Views: 2728

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jun 02, 2011 11:40 am   Subject: Bussiness requirement
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 ...
 Topic: Bussiness requirement
jcthornton

Replies: 8
Views: 2728

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 01, 2011 10:32 pm   Subject: Bussiness requirement
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 ...
 Topic: Divide a ring in 8 shape into two rings
jcthornton

Replies: 8
Views: 3539

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue May 31, 2011 5:25 pm   Subject: Divide a ring in 8 shape into two rings
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 - wit ...
 Topic: writing from oracle view to a oracle table?
jcthornton

Replies: 2
Views: 1450

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue May 31, 2011 5:03 pm   Subject: writing from oracle view to a oracle table?
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 yo ...
 Topic: Divide a ring in 8 shape into two rings
jcthornton

Replies: 8
Views: 3539

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue May 31, 2011 9:08 am   Subject: Divide a ring in 8 shape into two rings
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
| ...
 Topic: Replace Special Characters in a String
jcthornton

Replies: 6
Views: 6453

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 20, 2010 11:46 pm   Subject: Replace Special Characters in a String
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 definiti ...
 Topic: Special Characters Conversion Problem
jcthornton

Replies: 3
Views: 1759

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 20, 2010 11:40 pm   Subject: Special Characters Conversion Problem
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 (wel ...
Workaround Reported
 Topic: Wait for File
jcthornton

Replies: 10
Views: 4464

PostForum: General   Posted: Wed Oct 20, 2010 1:23 pm   Subject: Wait for File
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 ...
 Topic: Special Characters Conversion Problem
jcthornton

Replies: 3
Views: 1759

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 20, 2010 1:21 pm   Subject: Special Characters Conversion Problem
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 ...
 Topic: Link Naming Standard
jcthornton

Replies: 11
Views: 4794

PostForum: General   Posted: Tue Oct 19, 2010 9:44 am   Subject: Link Naming Standard
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 co ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours