DSXchange

Moved

There... fixed.

Which I would have mentioned if there was any chance for an inadvertent substring match... in this case there isn't, so left that one alone.

That would be a question for your official support provider. You may be referring to the "Service Pack 2" patch if you are on Windows XP or there may be some other I'm not aware of. Regardless, you'd need to get it via your support provider.

There is a hard limit in the Viewer on how much data it can display... you've exceeded that in at least one field. Not much you can do about that if your field sizes are correct, view it outside of DataStage if you need to see every last bit.

Index()

Have you tried using a UV stage rather than ODBC? Off the top of my head, there is an environment variable that may help with ODBC, something like MAXFETCHBUFFER ?? It's been mentioned here, perhaps a search would turn it up.

Moving this one as well and will lock the duplicate.

Replying just to let you know I've moved this to a more appropriate forum.

We'll start with... the General forum. Can always move it again if people deem that to be appropriate.

I don't believe that is the "statistics" being asked about here. With the "our DBA is in charged to collect statistics to different tables in datastage" comment, I was thinking this was more about audit/trending stats that need to be collected run over run. :? Hopefully the OP ca...

First, you make sure the lookups happen in the proper order. Secondly, you pass the output of one lookup to the input key(s) of the next one by typing their names in manually as there is no way to do this via the GUI. Thirdly, you live with the fact that those keys will show in red as if there was s...

shivadas wrote:do you mean chulett, The version of Datastage I have doesn't support Win 7? Is there another way to fix like installing vm or some thing else.

No version of DataStage supports Windows 7 for the server product. Client maybe, server no. As noted, for VM, a supported O/S should work just fine.

Have you checked with your DBA, seen what's going on in your target database? I would guess some kind of locking...