Search found 148 matches
- Wed Dec 20, 2006 12:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Work-around for SPARSE lookups on Windows
- Replies: 2
- Views: 2179
Ray, Thanks for your response. Trust me that if I had any sort of choice, Windows would be right down the bottom. More memory might solve the problem for now but it will certaintly blow out after some time as these are historic tables that I'm working with. I've discounted outer joins because of the...
- Tue Dec 19, 2006 11:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Work-around for SPARSE lookups on Windows
- Replies: 2
- Views: 2179
Work-around for SPARSE lookups on Windows
I'm currently on a project using 7.5x2 EE on Windows with ODBC connections to a DB2 database on a mainframe. I have a need to do database lookups to populate a number of fact tables from an ODS which is also on DB2. The obvious solution would be to use sparse database lookups. However, since this fe...
- Tue Dec 19, 2006 11:56 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Work-around for SPARSE lookups on Windows
- Replies: 1
- Views: 1852
- Tue Dec 19, 2006 11:54 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Work-around for SPARSE lookups on Windows
- Replies: 1
- Views: 1852
Work-around for SPARSE lookups on Windows
I'm currently on a project using 7.5x2 EE on Windows with ODBC connections to a DB2 database on a mainframe. I have a need to do database lookups to populate a number of fact tables from an ODS which is also on DB2. The obvious solution would be to use sparse database lookups. However, since this fe...
- Tue Dec 12, 2006 5:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Partitioning on the Join Stage
- Replies: 4
- Views: 10013
- Tue Dec 12, 2006 4:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Partitioning on the Join Stage
- Replies: 4
- Views: 10013
Partitioning on the Join Stage
Hi all, Could someone please clarify whether or not the join stage requires that data be hash partitioned and sorted on the join key? The following is an extract from the manuals and, to me, it reads like you can choose auto partitioning. <i>The data sets input to the Join stage must be key partitio...
- Wed Nov 22, 2006 11:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel Job compiles on one desktop but not any others
- Replies: 4
- Views: 3055
- Fri Feb 24, 2006 10:55 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Splitting CSV fields with Quotes
- Replies: 5
- Views: 3500
- Wed Feb 22, 2006 11:57 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Splitting CSV fields with Quotes
- Replies: 5
- Views: 3500
- Wed Feb 22, 2006 10:52 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Splitting CSV fields with Quotes
- Replies: 5
- Views: 3500
Splitting CSV fields with Quotes
Is there a nice simple way of splitting a CSV record that contains quoted strings with embedded delimiters?
Example:
Thanks in advance!
Example:
Code: Select all
,,,"Pint, US liquid",PT,,,,
Thanks in advance!
- Sun Feb 19, 2006 6:17 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Capture files in UVtemp
- Replies: 1
- Views: 2514
Capture files in UVtemp
Has anyone come across this error while trying to delete a capture file (i.e capturexxxx in UVtemp)? Cannot delete capture...: There has been a sharing violation The source or destination file may be in use. This happens even with all the DS server processes shut down (i.e. DSEngine, DSTelnet and DS...
- Wed Feb 15, 2006 11:19 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Verb "UNLOCK" is not in your VOC
- Replies: 3
- Views: 4468
- Wed Feb 15, 2006 10:40 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Verb "UNLOCK" is not in your VOC
- Replies: 3
- Views: 4468
Verb "UNLOCK" is not in your VOC
I'm getting the following error message Record ROUTINENAME in file DS_ROUTINES is locked by another user Searching through the forum, I found a suggestion to run the UNLOCK command but when I do I get the "Verb UNLOCK is not in your VOC" error. I'm running on Windows (client and server) an...
- Fri Feb 10, 2006 3:23 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Data security
- Replies: 7
- Views: 4628
Viewing of data through Datastage is not possible through Director (Atleast I havent figured out a way of doing it). I think, if you install with the Operator's licence (xxxxxx-DSDIR) on the Operator's PC, you will get pretty much exactly what you want. The Operator role only allows the running of ...
- Fri Feb 10, 2006 3:00 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Help needed in extracting data from MsWord documents
- Replies: 6
- Views: 3282
Shepli, 1. Run the job from Director 2. In the job run dialog, select the Tracing tab 3. In the Tracing tab, select the name of the XML stage 4. In trace level, select the Subroutine calls (or all the boxes if you like) 5. Now hit the Run button and wait for the job to finish 6. Now open the job log...