Search found 594 matches
- Fri Jun 15, 2018 12:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Db2 RUNSTATS as after SQL
- Replies: 4
- Views: 8605
- Fri Jun 15, 2018 12:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: compare address columns and insert records
- Replies: 7
- Views: 5624
- Wed Jun 13, 2018 2:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Duplicate Key values in CDC Stage
- Replies: 7
- Views: 6818
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.
- Wed Jun 13, 2018 2:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: compare address columns and insert records
- Replies: 7
- Views: 5624
- Wed Jun 13, 2018 1:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Escape Characters in External Filter ( Pain!)
- Replies: 0
- Views: 2578
Escape Characters in External Filter ( Pain!)
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 : I have a requirement to only pass values that match '9' but not any other number preceeding '9', fort...
- Fri Jun 08, 2018 5:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Custom Parallel Stagetype - Wrapped
- Replies: 8
- Views: 7330
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 . The CPP program will usually be packaged in a shared library and you wont really have access to the s...
- Fri Jun 08, 2018 4:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Recursive Fold ! Tricky
- Replies: 2
- Views: 3139
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 of data at a time , so I created a job that runs 5 iterations and writes an overflow bucket if it did no...
- Thu Jun 07, 2018 4:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Convert Issue - Non printable characters ÿ and ›
- Replies: 7
- Views: 5887
- Thu Jun 07, 2018 1:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Recursive Fold ! Tricky
- Replies: 2
- Views: 3139
Recursive Fold ! Tricky
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 highest value less than 365 - store in first grouping bucket next start with the row that is the First Value ...
- Tue Jun 05, 2018 3:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Custom Parallel Stagetype - Wrapped
- Replies: 8
- Views: 7330
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 try sequential file with multiple files option and use filter command . Is there no oracle function ...
- Mon Feb 05, 2018 3:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Procedure stage with Longvarchar (CLOB)
- Replies: 16
- Views: 11614
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 oracle connector stage perhaps ? ? Again i'm not sure of you need to execute this on a per row basis - bu...
- Fri Jan 26, 2018 2:45 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: IBM Is going to discontinue DataStage server Edition?
- Replies: 12
- Views: 26125
- Fri Jun 02, 2017 4:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Set user variable from SQL Query result set to be used later
- Replies: 5
- Views: 6141
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 calls embedded SQL. And if you want to pass arguments to the SQl within the routine - you must properly...
- Fri Jun 02, 2017 4:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Filter through Complex Flat file stage
- Replies: 3
- Views: 4137
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 used. You can just filter on a column or bunch of columns based on equality or inequality criteria. ...
- Fri Jun 02, 2017 3:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Field seperator
- Replies: 6
- Views: 5554
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 copy stage to get only the columns after the 3rd position. Or read the whole file as a string and c...