DSXchange

Dalek (btw, can you climb stairs?),

thanks for that information; it means that the implementation at the site that I am at needs to be configured correctly.

If you look at the options that the UNIX command "dsjob" gives you I think it would be best to incorporate the checking for aborted/incomplete jobs and e-mailing of job logs in a UNIX shell script.

Vaibhav, Immediate help costs money, this is a volunteer site. If you have a contract with Ascential or a service provider you might get help there. Your problem description was vague, which is probably why you haven't gotten a response. And since you specified "urgent" it reminded me that I need to...

there is no reason to install NLS in this case, none at all! I don't have any Oracle access at the moment, but the solution/problem lies in your session environment settings for Oracle - they are causing the character conversions. I am sure someone more knowledgeable will jump in later with the deta...

That's a tough one to do. How about changing the DataStage port and then using some OS or software mechanism to ensure that only the Citrix program can access that port - ensuring that some firewall between client and server blocks that port whilst it is visible only from one host or even program. I...

Both Google and Yahoo! retrieve over 1.12 Million hits for the search phrase of CRC32! Doing a cyclical redundancy check (CRC) on a text string or file will return a number - it used to be a 16 bit number but is now a 32 bit number. Changing just one byte of a file will result in the CRC32 result c...

kab123,

the source of these programs is visible to you - open up the job in the Manager and you will see a section of code that checks if the file exists and if not, creates a type 2 hashed fille called SDKSequences in the local project directory.

cherry,

this is not the way DS usually works. Stages are compiled into a job and don't go missing at runtime. The possible exception is user-defined stages. The best way to find out which one is missing is to run the job and look at the error messages in the Director's log file.

Mahesh, I gather you were not able to follow Ray's suggestion and look at the code, which is visible in the Manager in Routines -> sdk -> Utility -> UtilityMessageToLog. That is unfortunate, because had you done so you would have seen that the last line in the routine is "Ans = 1". It will always re...

When you use parameters as arguments to a routine call in a derivation, you cannot use the "#" quote characters. In your case the derivation will become something like

Some places requre quoting the parameters with "#" and some places won't allow it.

Where and how are you trying to use these values?

All hashed files allow the 64bit option (I'm certain about all except the b-tree). The modulo imposes a very large performance hit if it is chosen too low, this is not the case when it is set too high. The downside of specifying a large modulo is that it reserves disk space even with empty files. So...

One of the great options you have in PX is what sort of data to generate. If you right-mouse click on one of the columns and edit the row you can choose what sort of data to populate. You can generate random values or set a list of possible values and loop through the list.

Poorna, DataStage has no real concept of datatypes and variables are not declared. Variables are typed according to the operations performed on them. In your case the value of the parameter is being set to parmPartitionId -1 which is a mathematical operation and thus it is considered to be a numeric...