DSXchange

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

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

Sorry,

I sent this to the wrong forum.

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

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 all joins are normally hash-partitioned and sorted on the key. However one job slipped through wit...

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

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. Remove this, and it should work fine.

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

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.

Is there a nice simple way of splitting a CSV record that contains quoted strings with embedded delimiters?

Example:

Thanks in advance!

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

Thanks Craig!

Worked like a charm.

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

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

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