DSXchange

Get your Teradata DBA to check the log files to find out what failed in the Multiload process, and work back from there. For example, the user ID that DataStage used may not have permission to start MultiLoad processes.

What do you mean by "stage variable" here? There's no such thing in a job sequence. Do you mean "job parameter"? "Job sequence parameter"? "User variable"?

I have to agree with Craig. If the server is UNIX, you don't get ExecDOS or ExecDOSSilent.

You could clone ExecSH as ExecDOS, change all UNIX references to DOS, and it would be syntactically correct. However, attempting to use it on a UNIX machine is doomed to failure.

You can post links to hosted images. Search the forum for a "how to".

Your PATH (as the DataStage user) probably did not include the parent directory of the script. Give the full pathname of the script. DSExecute() has worked perfectly well since version 1.0. Beware that a script to create a directory will fail if the directory already exists. You may need to include ...

Open Control Panel > Administrative Tools > Services How many services can you find with "telnet" or something close as part of the name? If there's more than one, you probably have a clash on port #23 (the default telnet listening port). Find a Windows Administrator and add arguments to the propert...

Export it from another project (include read-only objects) and import it into this project.

Open the job in Designer.
Click on the icon that looks like the Internet Explorer icon.
Voila!! Full job documentation.

Usage Analysis on table definition does report at the individual column level.

They spent such a huge sum on a graphical tool so that they could paste scripts into it?!! Please advise names of persons who make decisions and persons who sign checks. Urgent requirement!!!

Transform functions are developed in DataStage BASIC (as "server routines" whose type is "transform function"). They can be called from Routine activities in job sequences. Job activities can (and do) successfully execute jobs where those jobs have before/after subroutines. What I said was that you ...

If you loaded the table definition from the Repository into your job, or if you saved the table definition from your job into the Repository, then you can effect a Usage Analysis on that table definition. But that's an impact ("where used") analysis, not a lineage analysis. You should undertake this...

gateleys wrote:My company gets its support from a 3rd party, and I feel it will take some time for them to get it from Ascential.

Push them. You're paying for the service. Redistribution of software violates one of the licence (EULA) conditions.

Of course it's possible. In server jobs there are two easy solutions. Convert the entire timestamp to microseconds using Iconv(), subtract 1, then convert back using Oconv(). You need to convert the date portion and time portion separately. Extract the microseconds using Field() function, subtract 1...

An "object" in this context (the DS_JOBOBJECTS table) is a job object; that is, any design-time object that might appear in a design canvas - the job itself, a container, a stage, a link end, an annotation, a view...

Note that your approach is unlikely to work in version 8.0 and later.