DSXchange

Hi, Almost summer 8) I have a parallel job that creates a sequential file. I want the first row to have column names. I also do not want the file to be created if there are zero records being processed. Currently the job creates a file with just column names in this case. Is there a way to achieve t...

Thank you, we will stick to Microsoft SQL Server Standard Edition then.

Hi,

We are installing latest version of Information Server 11.7. We will be using a single node architecture. We would like to know if it is possible and practical to use MS SQL Server Express for the XMETA repository?

Kind regards,
Riya Y

Craig,
Price of IBM support keeps on increasing every year by around 10-15 %, our management is not happy with this. We bought DS 9.1 a few years back, we don't want to invest in datastage anymore.

We are migrating from datastage 8.5 to 9.1. A parallel job which has few lookups and a change capture stage(with sorted input links) is aborting with the following error. Please help.

node_node1: Internal Error: (endOfBuffer_ > currentInputPosition_): processmgr/msgport.C: 502

I googled and could finally compile, create library and object file for the code. And it works, We are using the pxEreplace function now :D We are using DS 8.5 and migrating to 9.1 now. You are right, I have no knowledge of C/C++, but thanks to all you experts we got the replace function YEAHHH :) D...

Where should I put this code
I want to use this function to replace a string in a transformer, I have no clue how should I go ahead with this code.

We are getting same error. Please let me know, how to fix this?

It doesn't reach 2 GB. the job fails when it crosses 512 MB and only in the case of Lookup or Lookup fileset stages. When I tried with Join it worked fine. But we need to use Lookup. The whole project is running on single node configuration, using 2 nodes would mean to check each job for possible is...

Hi, We are getting following error in the lookup stage, at the lookup size of 512 MB and at row count more than 12508429 Lookup_106,0: Could not map table file "E:/projects/Development/nodecfg/node1/Datasets/lookuptable.20160825.xiby3sc (size 627421552 bytes)": Not enough space for Datasta...

Yes thank you.... Will do that

Thanks. I have tried no dependents option, still the dsx contains shared container design. Nodependents removed routines design from the dsx.

I want to take dsx export of lot of jobs into individual files for each job. Hence i am planning to use dsexport.exe in a batch file. When i take dsx export using designer, the shared container is not included in the design dsx but when i use dsexport.exe design of the shared container is also expor...