DSXchange

The location of a project can be ascertained via a query against the UV_SCHEMA table. dssh "SELECT PATH FROM UV_SCHEMA WHERE SCHEMA_NAME = '<<ProjectName>>';" The hashed file directory's location is possibly a job parameter (in which case the script needs to provide a value). If not, the h...

When you open the drop-down list of functions you will find all of them, you will also find them in Appendix A of the Parallel Job Developer's Guide manual. I, for one, do not propose to regurgitate that here.

Thanks for letting us know. The moral of the story is to keep your anti-virus definitions up to date.

Thanks for letting us know. The moral of the story is to keep your anti-virus definitions up to date.

... or perhaps you don't have write permission to the directory where the hashed files get created.

It's probably easier not to handle failures through triggers and emplace an Exception Handler. This has activity variables that can be used to report which activity failed and why.

Check the "automatically handle activities that fail" check box in the job sequence compilation options.

Don't allow NULL to reach functions in Transformer stage.

You really need premium membership. You've missed the most important points of my post.

Only by designing it thus, which will probably involve a higher level of control to count the number of abort notifications so as to make the decision as to whether to send email.

Lookup what error code CLI0109E means in DB2. It will help you to resolve this. It appears to relate to data larger than field size being sent.

There are no breakpoints. You talk about operators, but illustrate with an environment variable - which do you mean? The environment variables for reporting in general cause additional entries to be logged.

Is 45 smaller than your Array Size setting?

Look at your design - is XYZ nullable on either of the inputs and not nullable on the output? If your lookup failed rule is Continue, it must be nullable both on the reference input and on the output, because it will be null in the case that the lookup fails.

The limit is the total demand for resources for all applications on the machine not being more than the machine can deliver. There is no specific limit in DataStage.