DSXchange

Write it out on paper and see where the "#" characters stem from. There may be some quote character issues with your parameter value.

Also, check that the characters really are "U" and "J" in source data.

Welcome aboard. Try this:

Values files are for Parameter Sets, not for schedules. They are stored in a subdirectory called ParameterSets in the project directory. In ParameterSets there is a subdirectory for each parameter set, and this contains any values files defined for the eponymous parameter set.

Not sure about the sharp signs. Use the Expression Editor to build your trigger expression, so that you can select the parameter name from a list.

There isn't (at least not in current versions).

You could build your own, but would need knowledge of how the DataStage Engine ("UniVerse") works, in particular techniques for intercepting logins. That is too big a topic to cover here.

Do you have a firewall that is blocking the relevant port numbers? See Planning, Installation and Configuration Guide for details of all the ports that need to be opened.

You have a different error code - how can you assert it's the same problem?
Start a new thread.

DataStage is not really a backup management utility. Prefer the correct tool for the job, and for the job of managing your backup archives (for example IBM InfoSphere Optim Data Growth Solution). If you really must use DataStage it's just another ETL task - you need to identify a mechanism for deter...

IBM InfoSphere Information Server console is only available if you have licensed Information Analyzer and/or Information Services Director. You may be referring to "web console for IBM InfoSphere Information Server". This is not a separate client but, rather, is opened in a browser (Intern...

Use a sequence to test the date parameter, and decide which job (or what parameters for a single job) to be used based on that trigger.

Select only the columns that will be needed (if possible). Perform the join in a Join stage, and run the initial load over a quiet period such as a weekend.

A two-source match identifies records in one source that have similar attributes to records in a second source (for example when enriching a data source from a reference source). In one-to-one matching, one record from the data source can be assigned to only one record from the reference source, and...

In server jobs lookups are performed with the Transformer stage. The server Transformer stage takes one stream input and zero or more reference inputs (these are painted with short dashed lines). Reference inputs provide the lookup functionality. Hashed files (note, not "hash" files) are i...

Read about these techniques in the Server Job Developer's Guide. With multi-instance jobs you will need to implement a technique for splitting your data over the available instances. For example, where the source is a database table, use a parameterized WHERE clause to specify separate subsets of ro...

All manuals are available on your installation media, and may well have been installed on your client. Otherwise most manuals - and definitely the Server Job Developer's Guide - may be downloaded free from IBM. Just make sure you have the correct version.