DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 149 matches
Author Message
 Topic: Work-around for SPARSE lookups on Windows
jzparad

Replies: 2
Views: 1164

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Dec 20, 2006 12:17 am   Subject: Work-around for SPARSE lookups on Windows
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 ...
 Topic: Work-around for SPARSE lookups on Windows
jzparad

Replies: 2
Views: 1164

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Dec 19, 2006 11:58 pm   Subject: Work-around for SPARSE lookups on Windows
DataStage® Release: 7x
Job Type: Parallel
OS: 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 ...
 Topic: Work-around for SPARSE lookups on Windows
jzparad

Replies: 1
Views: 852

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Dec 19, 2006 11:56 pm   Subject: Work-around for SPARSE lookups on Windows
Sorry,

I sent this to the wrong forum.
 Topic: Work-around for SPARSE lookups on Windows
jzparad

Replies: 1
Views: 852

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Dec 19, 2006 11:54 pm   Subject: Work-around for SPARSE lookups on Windows
DataStage® Release: 7x
Job Type: Parallel
OS: 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 ...
Resolved
 Topic: Partitioning on the Join Stage
jzparad

Replies: 4
Views: 8342

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Dec 12, 2006 5:58 pm   Subject: Partitioning on the Join Stage
Thanks Ray!

Just to clarify, are you saying that DataStage will partition AND sort the data based on the join key if you use the "Auto" method?

The reason I'm asking is because in our project al ...
Resolved
 Topic: Partitioning on the Join Stage
jzparad

Replies: 4
Views: 8342

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Dec 12, 2006 4:10 pm   Subject: Partitioning on the Join Stage
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
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 ...
 Topic: Parallel Job compiles on one desktop but not any others
jzparad

Replies: 4
Views: 1836

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Nov 22, 2006 11:11 pm   Subject: Parallel Job compiles on one desktop but not any others
I had exactly the same problem and it looks like the solution may be the same. From the error message, it seems that you have a stage variable called svBalnA1 which you are trying to set to NULL. Remo ...
 Topic: Splitting CSV fields with Quotes
jzparad

Replies: 5
Views: 1716

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Fri Feb 24, 2006 10:55 pm   Subject: Splitting CSV fields with Quotes
Yes, it would - if you used the SEQ file stage. What I wanted was a function that could be used in BASIC (which I should have stated in the original question).
 Topic: Splitting CSV fields with Quotes
jzparad

Replies: 5
Views: 1716

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Feb 22, 2006 11:57 pm   Subject: Splitting CSV fields with Quotes
Thanks Ray.

I was hoping that since a lot of the plug-ins provide a way of defining a quote character that maybe there was some obscure function that offered the same functionality.
 Topic: Splitting CSV fields with Quotes
jzparad

Replies: 5
Views: 1716

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Feb 22, 2006 10:52 pm   Subject: Splitting CSV fields with Quotes
DataStage® Release: 7x
Job Type: Server
OS: Windows
Is there a nice simple way of splitting a CSV record that contains quoted strings with embedded delimiters?

Example:

,,,"Pint, US liquid",PT,,,,


Thanks in advance!
 Topic: Capture files in UVtemp
jzparad

Replies: 1
Views: 1560

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Sun Feb 19, 2006 6:17 pm   Subject: Capture files in UVtemp
DataStage® Release: 7x
Job Type: Server
OS: Windows
Additional info: Cannot delete capture...: There has been a sharing violation
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 fi ...
 Topic: Verb "UNLOCK" is not in your VOC
jzparad

Replies: 3
Views: 2861

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Feb 15, 2006 11:19 pm   Subject: Verb "UNLOCK" is not in your VOC
Thanks Craig!

Worked like a charm.
 Topic: Verb "UNLOCK" is not in your VOC
jzparad

Replies: 3
Views: 2861

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Wed Feb 15, 2006 10:40 pm   Subject: Verb "UNLOCK" is not in your VOC
DataStage® Release: 7x
Job Type: Server
OS: Windows
Additional info: UNLOCK DS_ROUTINES READULOCK
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 ...
 Topic: Data security
jzparad

Replies: 7
Views: 2690

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Fri Feb 10, 2006 3:23 pm   Subject: Data security
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 Oper ...
 Topic: Help needed in extracting data from MsWord documents
jzparad

Replies: 7
Views: 1764

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Fri Feb 10, 2006 3:00 pm   Subject: Help needed in extracting data from MsWord documents
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 a ...
 

 Jump to:   



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