DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 602 matches
Author Message
Resolved
 Topic: Db2 RUNSTATS as after SQL
rameshrr3

Replies: 4
Views: 4176

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 15, 2018 12:32 pm   Subject: Db2 RUNSTATS as after SQL
If your DB2 is on Z/OS , like we had, you need to use CALL SYSPROC.DSNUTILU() , with RUNSTATS TABLESPACE option.
Resolved
 Topic: compare address columns and insert records
rameshrr3

Replies: 7
Views: 245

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 15, 2018 12:27 pm   Subject: compare address columns and insert records
Its still remains as chulett says , a special case similar to SCD2, maybe you should just enable change capture stage for Updates & Inserts and run both that data[sets] as an Insert. Drop Copies ( ...
 Topic: Duplicate Key values in CDC Stage
rameshrr3

Replies: 7
Views: 311

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 13, 2018 2:13 pm   Subject: CDC or Change Capture
IDK why its common to refer to Change Capture stage as CDC stage, because it creates quite a confusion with the CDC Transaction Stage.
Resolved
 Topic: compare address columns and insert records
rameshrr3

Replies: 7
Views: 245

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 13, 2018 2:11 pm   Subject: compare address columns and insert records
more specifically use a SCD stage or Change Capture .
Resolved
 Topic: Escape Characters in External Filter ( Pain!)
rameshrr3

Replies: 0
Views: 87

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 13, 2018 1:41 pm   Subject: Escape Characters in External Filter ( Pain!)
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
FYI

IDK why , but our AIX doesn't like quoted arguments to Grep and getting the sam eto work in External filter was quite a pain requiring blunt trial and error till we could force it to recognize ...
 Topic: Custom Parallel Stagetype - Wrapped
rameshrr3

Replies: 7
Views: 408

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 08, 2018 5:21 pm   Subject: Custom Parallel Stagetype - Wrapped
I guess you'd be better off using an Oracle Stage like oracle connector than ODBC for such requirements. Its most likely your BLOB column has a limited support in ODBC stage that causing the error . T ...
Workaround Reported
 Topic: Recursive Fold ! Tricky
rameshrr3

Replies: 2
Views: 169

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 08, 2018 4:46 pm   Subject: Recursive Fold ! Tricky
I did not have tim eto work through a generic algorithm though a sequencer loop processing a constantly reducing file would have worked logically speaking.

The business only wants to load 3 years ...
 Topic: Convert Issue - Non printable characters ˙ and ›
rameshrr3

Replies: 9
Views: 377

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jun 07, 2018 4:08 pm   Subject: Convert Issue - Non printable characters ˙ and ›
Pity that Server Jobs and Basic transformer are nowadays frequently considered 'illicit' workarounds in many places, despite their unique and powerful capabilities, and despite the fact that basic tr ...
Workaround Reported
 Topic: Recursive Fold ! Tricky
rameshrr3

Replies: 2
Views: 169

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jun 07, 2018 1:25 pm   Subject: Recursive Fold ! Tricky
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: Folding rows into groups based on relative date intervals
I have a Bunch of Rows grouped by a key and multiple such bunches.

The requirement

For a given Grouping Key , start the first group at the lowest date and and it at the row where the date is hi ...
 Topic: Custom Parallel Stagetype - Wrapped
rameshrr3

Replies: 7
Views: 408

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jun 05, 2018 3:05 pm   Subject: Custom Parallel Stagetype - Wrapped
wrapped stage only accepts pipe safe commands and hence doesn't really do row by row. Inserting a wave gen to do row by row may not work because the Wrapped stage is typically Not 'Wave-Aware'.
Maybe ...
 Topic: Stored Procedure stage with Longvarchar (CLOB)
rameshrr3

Replies: 16
Views: 1776

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

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

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

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

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 ...
 

 Jump to:   



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