DSXchange

Hi all I have a hash file being access using UV stage by partial key, for a multi-row lookup, that was performing very badly. I created an index on the lookup column, from the UV command line, reran the job and the performance was closer to what I expected. Now I want to create and build the index i...

Then just add a Trim...
(The 'T' will remove trailling '.')

Why not just use a format function in your transformer.
Something like - should give you the result you need. :D

Is this still available

I tried accessing it from a RSS reader and was told it couldn't find the site.

Hi Ray After some e-mails and a phone call from an engineer in the US have found the solution to the problem. When starting DataStage client, I was using the "Omit" checkbox when loggon on to my project. The engineer advised that this process is using LANMAN rather than a native TCPIP conn...

Hi Ray Checked the server, and this directory is not anywhere to be found. Any other ideas as to where this file may be ? BTW, I have also opened an issue with Ascential, and will advise if I get any result there. Thanks Chris Fuller Non-Life IT Applications Munich Reinsurance Co of Australasia Ltd ...

Hi Ray In answer to your questions - This only happens with the debugger, ie the job runs fine when initiated from the director. The client-side time-out is set to 86400 seconds (24 hours) which is definately longer than the 60+ seconds the update runs for. I searched the server and was unable to lo...

Hi all first time user of the forum, so please be patient with me. environment - Windows 2K client running ver 6.0.0.17 of Datastage connecting to Windows 2K server running ver 6.0 Problem - The job scenario is hash file is primary driver, does lookup to another has file, write records to on Oracle ...