DSXchange

Teradata doesn't quite work like that. There are no direct equivalents.

Create jobs to delete data from the two tables.

Can you log in as a DataStage Administrator? If not your SQL Catalog table UV_USERS is corrupt. In this case contact your official support provider.

Are there any warnings in InnerSeq2 log or in OuterSeq log?

I assume that was in Director? Detail view in Designer is intended to be had by sliding out the details pane - in which case no jobs are visible in the tree pane but the jobs in the currently selected folder are visible in the slid-out details pane, along with information such as date/time modified.

Set the Lookup Failed rule to "Continue" and make sure that columns on the reference input and columns on the output that are derived from these are all marked as Nullable.

Were these jobs started from dsjob command with no -warn option?

Message handlers do NOT handle fatal errors.

You can create message handlers without a particular message having been logged, provided you know the message ID.

Yes there is. A Parameter Set contains a "default default" set of values as well as zero or more values files.

Welcome aboard. What errors are logged in DataStage when this problem occurs? Have you had your DBA investigate which sessions own the locks?

In a near future version of DataStage (it was announced on the road map at last year's IOD conference) is "intelligence" built in to DataStage to push some logic back into the database, though this is more logic associated with the selection process (e.g. replacing a Sort stage by an ORDER...

You edit the values files within the Parameter Set itself. Each values file contains a set of "default" values to be used if that particular values file is selected as the "value" of the Parameter Set job parameter (the first syntax I suggested earlier). Refer to the webinar broa...

Has the project parameter been passed to the job as a job parameter? If so you can use DSGetParamInfo() with DSJ.ME as the first argument.