DSXchange

There is a simpler technique in DataStage when the intervals are identically sized. Such was not the case in this example.

A cluster will have more than one fastname in the configuration file. None of the fastnames is a variable.

BDT downloadable (free) as part of U2 DB Tools from Rocket Software may work.

Try using the function in the expression for the user variable.

Be aware also that, for some roles, you have a "named user limit"; you must be able to show during audit that actual names of the users licensed in those roles, such as Business Glossary Administrator.

If .. Then .. Else If .. Then .. Else If .. Then .. Else ...

Convert both dates to Julian then perform the arithmetic. Convert the result back from Julian.

Yes, but only if your comparison basis is "all fields are key"

Some of the cases where I need user-defined SQL (though often I prototype the same with SQL Builder):

• need to refer to parameters that are in Parameter Sets, for example in WHERE clause
  
  need to use a UNION or INTERSECTION etc.
  
  need to specify fully parameterised table identifiers

No, keep the namespace declarations in the header. I suggested that you change the references to namespaces within the body.

Welcome aboard. In the DB2 Connector stage (or such other DB2 stage as you might use) you have the option to have the SQL generated by the stage, built using SQL builder (Connector only) or using user-defined SQL. In the Connector stage set the Generate SQL property to "No", and provide a ...

venkat626 wrote:When I export a job from one host and then import it to another it usually is created in the same category (directory) as in the original host.

Not "usually". Always.

You can move it subsequently.

... and you can infer from that that you can compile anything not mentioned in the list (which should also have included C++ functions used as parallel routines).

Try a Search of DSXchange - you will find that this has been discussed in the past, and that links to the relevant documentation exist in some of those posts. Short answer is that it can be done.

You can probably log in using browser-based clients, but not to DataStage.

80011 is an error from the DataStage RPC mechanism. It suggests that you have not set up the Engine credentials correctly in the Web Console for Information Server.