DSXchange

I don't have that information but you can see for yourself it is primarily the times, user numbers and status values associated with jobs, invocations, Transformer stages and "resources".

One is on the (input) link and the other is external. You also have two other possibilities, an explicit Sort stage and an inserted tsort operator.

Sequential files can be updated like tables if you use the ODBC driver for text files with an ODBC stage. This is a particularly useful combination if you are being paid by the hour.

This is why I allowed the possibility "incompletely saved". Without considerable expertise with Repository structures the easiest solution is probably to re-create the job from scratch.

The DSGetJobInfo() function in the DataStage API allows you to obtain a list of invocation IDs for the attached job. There is a record for each invocation in RT_STATUSnnn table where nnn is the job number. Therefore a query such as the following might be useful to get the count of invocations. SELEC...

Transformer stage functions are listed in Parallel Job Developer's Guide Appendix A.

Please be corrected. You must handle the "genuine null" first because functions such as StringToDecimal() are intolerant of them.

What data type do you get when you import the table definition from Teradata?

Data Elements are extensions to the idea of data types. For example, a field may be VarChar(12). That tells you very little about it. By adding a data element you can differentiate between SSN, telephone number, tax ID, part number, whatever. That is, you can store business metadata associated with ...

Have you taken the DataStage Essentials class from IBM or some equivalent? This is a totally fundamental operation that you are asking how to perform.

Magesh_bala wrote:Can you please help me in writing the script?

That comes under the heading of "consulting" which is how I make my living. Contact me off line if you wish to engage me professionally.

This job has been incompletely imported or incompletely saved. If you have an export, delete the job in question and re-import.

Thanks for response. XMETA is DB2 and it is up and running - for example I can use DB2 Control Center to inspect the tables in it. As far as I can tell all required services are running (though WebSphere App Server fails to start automatically and has to be started manually). As for the error log, h...

A job sequence can use a StartLoop activity to set up a "list of things" loop to process the file names. But why not stream the data from all files into the job via a filter command (such as the TYPE command) in the Sequential File stage, as hamzaqk suggested?