DSXchange

Ray - I actually created a common DSDetachJob interlude so that I could play around with debugging information and even commented out the statement, the error is then evinced elsewhere! It seems that somehow the internal common variables that hold the open and used JobHandles are getting very mixed ...

Nothing has changed in the configuration - this occurs on 2 different machines as well. Nobody is touching these programs. I've written some test jobs to try to reproduce the issue consistently to no avail, although I did find out a strange issue - there is an internal common block which contains th...

We have a complex mechanism to control job starts and logging here, essentially a wrapper around each call from one sequence to another or to a job. I am getting odd behaviour now, which I think is related to the number of instances (up to 200 for some jobs) that we have. Part of the mechanism opens...

Krishna,

sounds like your hosts file is incomplete. What happens if you do a "ping PUNACX010.xxxxx.com" on the host?

I would always sort before the aggregator. The sort method to use really does depend upon your incoming data (i.e. coming from a table you can use the Database's mechanism, a flat file might be better sorted outside of DS, etc.).

snassimr, You can find additional information about this by looking either at other posts or in the manual under MODULUS or MINIMUM.MODULUS. Basically, the space freed when deleting records in a hash file is not necessarily freed up in the OS and likewise your file may not grow in size when you writ...

Could you explain? Your post states you want to do a match with one uppercase string to a mixed case string, the UPCASE() function lets you do that. So you now have the original string , an uppercased string and a true/false result on a match - what more do you need?

The UPCASE() function will convert to uppercase pretty efficiently, do that with both strings and you are in production

Kollurianu,

somewhere you are using the value of a variable called "RootProcessID" and the compiler has detected that it was never given a value. Look for an occurrence of this variable name in your job's transformers (used in a derivation, or a stage variable?)

Semkaa, unfortunately it doesn't work that way; unless Ascential specifically states that it supports Win64 then it won't be supported and might not work; which is why you might be having the problems you are. I did a quick check at Supported Versions and didn't find Windows Server 64 bit; but your ...

Semkaa, have you looked at the READMEs on your CD to see whether DataStage is supported on the 64bit Windows - I still think that it is not going to work. The MKS Toolkit allows migration across platforms, especially allowing UNIX commands to be executing under Windows. If the install process compla...

the \' construct tells it not to parse the quote but accept it unparsed. This is commonly used both at UNIX level and also in Oracle SQL.

Gokul, a quick search for answers to this question showed more responses than I can page on mby browser; I suggest you look there for some information. The Hash file types are described in the UniVerse documentation, specifically in the UniVerse System Description 9.6.pdf downloadable from IBM at Un...

Can you add a call to DSLogWarn(#"':CONVERT(@FM,'.',Output):'"','') to your program so that we can see the contents of Output?

Can't you just do WHERE CNSM_END_DT = TO_DATE(\'2999-12-31\',\'YYYY-MM-DD\') ?