DSXchange

When updating a DB2 table using the DB2/UDB stage I'm trying to get the database to calculate the field value based on the columns I pass it but it's treating what I pass it as a string not a calculation for DB2 to execute. For example: If I run this statement in Command Center it works and the nume...

Worked great Craig Thanks!!!

I thought that was the standard as well. The group that I'm investigating this for said that they have a 3rd party application that the feel will not be able to read this because it's validating the xml against a dtd. I suggested that if it is a problem that they would have to write something upfron...

I'm creating an XML from a SFF file and one of the values inside the XML document needs to read something like "&NAME;". When I put this value in the transformer and then view the ouput xml file it reads something like as "&NAME;" Is there any option in the XML output sta...

Okay here's an update as it happened again. It is actually hanging while calling an ETL Sequencer in my post process. This ETL job has multiple instances that it runs under and when I went into director all the hanging uvsh.exe seemed to be related to this job and it's instance. This sequencer calls...

First off thanks for the reply... the CPU's are dual core on one blade. Not sure what you mean by the "write-delayed hashed files". Could you explain or let me know if there is a post out there already with the info. I definitely agree the other jobs hang because that one that is clocking ...

The last 2 out of 3 days for some reason a job does not complete and hangs out there occupying all the CPU and the I/O reads climb up over a million. Any job after that just begins to hang as well. I try killing the uvsh.exe through task manager but nothing happens. When I try again it says "AC...

I actually figured it out. If anyone else needs it you use:

Call DSExecute('DOS', "Echo %WIN_VARIABLE%", return_value, return_code)

The return_value does have a none viewable character at the end so you'll need to leve that off, especially if you are using it as a file path.

Is there a way inside a Before/After routine to retrieve a Windows system variable, not a DataStage variable, but a system variable defined on the Windows server?

Thanks

It's GPG. It's definitely something with the encryption. We emailed the encrypted file and the user was able to unencrypt and view. We then tried to FTP and the user was not able to unencrypt. kduke - I'm not sure I follow. I am creating the file, encrypting it, and sending it off. I don't understan...

No, we are trying to decrypt it. Does this mean you successfully used the FTP plugin to ftp an encrypted file?

Anyone ever have any success using the ftp plugin stage to ftp a gpg encrypted file in a server job? It looks like it works but when we try to open it we receive errors like, "No gpg encryption characters to decrypt." So, something is getting corrupt in the FTP. I've tried sending it binar...

Thanks for the responses. Unfortuantely we don't have Parallel extender.

Even if you choose the option "Use directory path", in which the hash fille is now ceated outside the project, does the 2GB limit still apply?

In the article "Tech Tips: Hash Files in DataStage" the author claims that a way to tune your hash files to reduce data being written to the overflow file is to increase the 'Minimum modulus' of the hash file. I was at first real happy to see this but now I'm having a hard time getting it ...