DSXchange

Change the line terminator in Sequential File stage from DOS-style to UNIX-style (it's a stage property).

suresh.angadi wrote:since it is in datastage 8.1, i think (not sure) you can't see the directory in the unix because till datastage 7.5 repositary will be in the unix file strecture, and datastage 8 onwards repositary will be in the database.

That's just wrong.

In that case I support Arnd's request that you mention where you obtained the information that these terms can be used in the parallel execution configuration file.

It might be pertinent to ask just what kind of configuration file you are talking about - it is the parallel execution configuration file, whose pathname is given as $APT_CONFIG_FILE, or is it some other kind of configuration file.

Also, are you operating in a grid configuration?

DataStage does not impose any limit. The ABAP stage has been certified by SAP AG to generate valid ABAP code.

SAP may impose a limit, but you would need to ask someone knowledgable about that environment.

So you can test for the number of lines (wc -l) and react if that is zero (if no column headings) or 1 (if column headings).

The usual approach is to have an extra, empty file transferred, and to have it transferred last. That is the file for which to wait; if it has appeared then all the others are ready (assuming no errors, but that also is detectable).

DataStage is an ETL tool. It is not a reporting tool.

The only reports it creates are about what it itself (or associated Information Server services, such as metadata analysis service) does.

The UniVerse stage uses the same metadata store (the "file dictionary") as does the Hashed File stage. There are no particular rules for specific data types other than dates and times, where the ISO 8601 standard formats can be specified to apply.

priyadarshikunal wrote:Have you tried importing metadata using orchestrate.

Of course, posting in the server forum, they may be a server-only licence.

Why not just use a Sequential File stage, declare the right number of fields delimited by "~" plus one "dummy field, and specify "none" as the record terminator?

In the Administrator client, select the project from the list of projects. At the bottom of the window (which may take a few seconds to refresh) will be the UNIX location of that project's directory.

What do you mean by "unable"? How are you attempting to invoke it? It only works on parallel jobs, but you are posting in the server forum and have marked your job type as server.

Sainath.Srinivasan, I can't see your complete message, bcoz I am not a premium member. Is there anyway you can not classify it as a premium content. Thanks! He could, but he won't. Premium membership is one of the ways that the hosting and bandwidth costs of DSXchange are met. We're not going to se...

mukejee wrote:the routine that you are taling about is not available here.

They are, they ship with the product.

Anyways, i got my problem solved. i would use a Peek stage to write to the director logs.

That strikes me as an unnecessarily restrictive approach.