DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 592 matches
Author Message
 Topic: Stored Procedure stage with Longvarchar (CLOB)
rameshrr3

Replies: 16
Views: 1479

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 05, 2018 3:49 pm   Subject: Stored Procedure stage with Longvarchar (CLOB)
why dont you write the result set from the stored proc to a table in a before stage proc call and then read the xmltype using XMLSERIALIZE(DOCUMENT columnname) oracle function - you could use an oracl ...
 Topic: IBM Is going to discontinue DataStage server Edition?
rameshrr3

Replies: 12
Views: 771

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Fri Jan 26, 2018 2:45 pm   Subject: IBM Is going to discontinue DataStage server Edition?
I just checked my calendar to make sure its not April 1st.
PS
There is a higher chance IBM may stop future development of AIX OS and provide customers with a path for transitioning to Linux on Pow ...
Resolved
 Topic: Set user variable from SQL Query result set to be used later
rameshrr3

Replies: 5
Views: 2056

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 02, 2017 4:05 pm   Subject: Set user variable from SQL Query result set to be used later
You can write a DS Basic routine using BCI and the ODBC api to retrieve a database value from an ODBC compliant database - but you must strictly control the output returned by such a routine which ca ...
Resolved
 Topic: Filter through Complex Flat file stage
rameshrr3

Replies: 3
Views: 1365

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 02, 2017 4:01 pm   Subject: Filter through Complex Flat file stage
You can go to the Output Master tab of CFF stage ,and you will see a sub tab called constraints - it offers some level of capability of filtering data -, but I don't think any string functions can be ...
Resolved
 Topic: Field seperator
rameshrr3

Replies: 6
Views: 1599

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 02, 2017 3:42 pm   Subject: Field seperator
Yeah, the post is resolved, but i usually design my jobs to minimize number of Transformer stages ( a throw back to the past i guess ) - So i would have just read from the sequential file , and used a ...
 Topic: Lookup with a Like Operator
rameshrr3

Replies: 4
Views: 1517

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 19, 2017 10:01 am   Subject: Lookup with a Like Operator
I think you can use the same lookup stage - the reference link can be copied into 4 different ref links using a copy stage, and then use the approrpriate condition/scenario in each , drag all the resu ...
 Topic: Writing multiple record types flat file
rameshrr3

Replies: 5
Views: 1716

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 11, 2017 11:17 am   Subject: Tricky but very very do-able.
Yeah - custom sorts and subsorts are what i could think of , give we implemented the very complex PVF Files for DTCC which are Hierarchical Flat files better suited for cobol based programming or Webs ...
Resolved
 Topic: Group by clause implementation in Datastage
rameshrr3

Replies: 6
Views: 1677

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Feb 09, 2017 11:41 am   Subject: Group by clause implementation in Datastage
From TEXT
Where TEXT.OID = 2498
And TEXT.TEXT in ('Discharge', 'Expired')
Group by TEXT.OID

If they were using SQL , a group by would not be needed
Resolved
 Topic: Group by clause implementation in Datastage
rameshrr3

Replies: 6
Views: 1677

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Feb 08, 2017 6:52 pm   Subject: Group by clause implementation in Datastage
Only one group - since TEXT.OID is filtered on single value ? Whats the point - curious
 Topic: Identifying Basic transformer stage
rameshrr3

Replies: 4
Views: 1217

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Feb 08, 2017 6:40 pm   Subject: Identifying Basic transformer stage
I usually use an icon editor or image processing tool to change the default look and feel of basic transformer on canvas , so that I know Smile
On my canvas the Basic transformer now has the similar ic ...
 Topic: Oracle ODI Vs DataStage Balanced Optimization (Part 2)
rameshrr3

Replies: 9
Views: 7089

PostForum: Data Integration   Posted: Thu Apr 14, 2016 6:02 pm   Subject: Oracle ODI Vs DataStage Balanced Optimization (Part 2)
Does the internal version of datastage engine have anything to do with the versions of the Universe Engine being release by Rocket UV ? Because the currently marketed version of UV is 11.x. I had an ...
 Topic: Oracle ODI Vs DataStage Balanced Optimization (Part 2)
rameshrr3

Replies: 9
Views: 7089

PostForum: Data Integration   Posted: Thu Apr 14, 2016 5:04 pm   Subject: Oracle ODI Vs DataStage Balanced Optimization (Part 2)
@Chulett : (Part 1) is on the same shelf where windows 9 and datastage 10 are Wink

Part1 is just what I consider previous debates on this topic , but did not want to hijack those older threads where ...
 Topic: IN clause in transformer
rameshrr3

Replies: 11
Views: 6231

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Apr 14, 2016 2:51 pm   Subject: IN clause in transformer
I would agree with Ray, the lookup functions ( Or Should i call them specifications Wink ) ) in modify stage have been used a couple of times by me in some projects, but the modify stage does not h ...
 Topic: Activation Lead Time
rameshrr3

Replies: 2
Views: 2714

PostForum: Site/Forum   Posted: Wed Apr 13, 2016 12:59 pm   Subject: Activation Lead Time
Ok, if its not activated after 48 hrs, will send an email to 'editor ' Smile
 Topic: IN clause in transformer
rameshrr3

Replies: 11
Views: 6231

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 13, 2016 12:57 pm   Subject: IN clause in transformer
Despite its many strengths in customizability using C++, I still find the standard (prebuilt) DataStage parallel job function library to be hands down the worst (& worst documented) of any self r ...
 

 Jump to:   



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