DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 23 matches
Author Message
 Topic: Spambot
rschirm

Replies: 2
Views: 566

PostForum: Site/Forum   Posted: Tue May 02, 2017 6:55 am   Subject: Spambot
Craig, I delete that user and all 124 posts.
 Topic: Writing multiple record types flat file
rschirm

Replies: 5
Views: 705

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 11, 2017 10:52 am   Subject: Writing multiple record types flat file
As the Ray and Craig have added I will add one more suggestion. Since you have one row coming in and you need basically 5 going out in the transformer take advantage of the Loop capability. This way y ...
 Topic: Fallen Premium Poster: Kim Duke
rschirm

Replies: 33
Views: 5478

PostForum: General   Posted: Thu Jul 14, 2016 8:10 am   Subject: Fallen Premium Poster: Kim Duke
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
As the editor of the DSXchange, and longtime friend, we lost the divine input of Kim Duke this week as he has passed to higher place. Kim, has been a huge supporter of DataStage and the underlying eng ...
Resolved
 Topic: Data Not Passing through Transformer
rschirm

Replies: 11
Views: 2471

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Apr 23, 2016 6:12 pm   Subject: Data Not Passing through Transformer
Find the entry in the log or the sequential output. It will state that 0 rows written and NNNN# of rows rejected.
Workaround Reported
 Topic: Wait for file issues
rschirm

Replies: 16
Views: 2066

PostForum: General   Posted: Fri Apr 15, 2016 9:26 am   Subject: Wait for file issues
The WFF stage is not intended for it to monitor for the file that a job is suppose to execute. Many time the file may have been created and populated but the process that wrote it has not completely c ...
 Topic: Pipelining with a sortfunnel stage
rschirm

Replies: 2
Views: 925

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jan 19, 2015 1:58 pm   Subject: Pipelining with a sortfunnel stage
Hello Arnd,

Hope things are going well with you.

How about instead of rejecting unmatched rows tell it to continue instead and feed all rows through the trx and evaluate the if the row had a mat ...
 Topic: Can we setup a C++ compiler after installation of Datastage
rschirm

Replies: 6
Views: 1654

PostForum: General   Posted: Mon Jan 19, 2015 1:41 pm   Subject: Can we setup a C++ compiler after installation of Datastage
You can install the C++ post DS install. But you must get the 2 Environment Variables set correctly.

After you install the c++ compiler there should be a command prompt that you can run that is rel ...
Resolved
 Topic: Can we enable RCP in a Dataware Environment or not ?
rschirm

Replies: 10
Views: 3338

PostForum: General   Posted: Wed Dec 24, 2014 8:46 am   Subject: Can we enable RCP in a Dataware Environment or not ?
From what you are describing RCP will work just fine. Performance will not be an issue as there is no additional overhead unless your target does not have all of the same column names. The only impact ...
 Topic: Filter Stage problems
rschirm

Replies: 3
Views: 1656

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Dec 23, 2014 11:24 pm   Subject: Filter Stage problems
The () characters are what is throwing the error. Something a complex as you are doing belong using a transformer or a build op stage.
 Topic: Capture Multiple changes
rschirm

Replies: 3
Views: 1421

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Dec 22, 2014 11:23 pm   Subject: Capture Multiple changes
You might address it this way.

1. Read data in and sort by bk,org,unit,flag(maybe)
2. feed to Aggregator stage grouping by bk,org,unit,flag(maybe)
3. output grouping values of bk,org,unit,flag(ma ...
 Topic: Pivoting of rows
rschirm

Replies: 10
Views: 2810

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Dec 22, 2014 10:36 pm   Subject: Pivoting of rows
Just use the enterprise pivot stage to do exactly what you want to do.
Resolved
 Topic: transformer compilation eror
rschirm

Replies: 12
Views: 5338

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jun 02, 2011 9:59 pm   Subject: transformer compilation eror
on the server goto programs and navigate to the Microsoft Visual Studio 2008 and find the Command prompt and select. This will place you in a command window that has all of the needed C++ environment ...
 Topic: How to parameterize column name in transformer constraint
rschirm

Replies: 3
Views: 2132

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jun 02, 2011 9:01 am   Subject: How to parameterize column name in transformer constraint
The problem with using a job parameter is it takes the value specified and treats as a string. And since the string value that you are passing is not TRUE the rows will not go out. This can be accompl ...
Resolved
 Topic: unable to see transform editor
rschirm

Replies: 6
Views: 1899

PostForum: General   Posted: Thu Jun 02, 2011 8:32 am   Subject: unable to see transform editor
regedit
HKEY_CURRENT_USER->Software->IBM->InformationServer->DataStage Client->affd...->DSDesign->Settings->Transformer

Just Set Left to 0 and Top to 0.
Resolved
 Topic: Transformer Stage Logic
rschirm

Replies: 6
Views: 1998

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jun 02, 2011 7:57 am   Subject: Transformer Stage Logic
Try using Stage variables:

Variable1 = Period1:",":Period2:","Period3:",":Period4:",":...
Variable2 = Startdate-Enddate
Variable3 = field(Variable1,',',Variable2)

Then use Variable3 as the val ...
 

 Jump to:   



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