DSXchange

How can you convert a number such as 537276302 into a string with a maximum length of 2 characters?

A DataStage server job may have more than one process. Are you certain you really wish to store this information as it would be of limited use. The user number is also stored in director log for a given run.

Ray - cool, I never knew you could change the prompting behaviour there!

I would use a database table and a sparse lookup unless performance limitations prevent you from doing that.

No, the DataStage clients have never been backwards- or forwards- compatible and will only work with their specific Version server counterparts.

When you start a job from the director you will always get that window. If you start a job using the "dsjob" command then any parameter values you don't explicitly set will use the design-time defaults.

You posted in Server, but asked about a Parallel-only stage. Which product are you using?

Which database, which stage? Indices are a database internal thing of which DS Server has no idea; but many stages allow before and after SQL to be added to the job, where such actions can be performed.

Use "#VAR#". Better yet, use the builtin drop-down menus to let you choose the parameter value, that way you cannot mis-spell the case-sensitive parameter names.

It is not only possible, but recommended to put such types of information into parameters.

This is happening because some other process holds a lock on the record in the file. If you don't know which one that could be, use another command windows or the TCL prompt and issue "LIST.READU EVERY", this is a bit complex to read but, particularly if your system isn't busy, you should be able to...

Is anyone here currently using Hawk with MQ Series? If so, how do you access a queue using only the MQ Client, (with no server installed.) Is this even possible? We are using MQ with HAWK both with real-time components, the Oracle UOW operator and a customer MQ UOW operator at this installation. Al...

minhajuddin - you never answered on whether the eCase was "fixed" or not.

I'll ask the question again - what was the output of the command activity. Please paste it, without editing.

Ensure that the Big.RTEString is terminated with a trailing comma, then the command should return a 0 when the string is not found, otherwise a positive integer value.