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

Replies: 4
Views: 947

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: 911

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: 6873

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: 2801

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: 2250

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: 993

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: 1764

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: 3621

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: 1739

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: 1507

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: 2972

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: 5607

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: 2243

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: 1964

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: 2052

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