DSXchange

If you're looking for a niche market and you think it would sell, the DataStage API is C-callable, so you could create a little C application!

There will be a problem if you want to import the metadata from a hashed file that has been created in a directory, rather than in an account. The problem is that the import process needs a reference in the project to the hashed file. This can be created by the SETFILE command. Search the forum for ...

Yes it does. Don't be concerned by the fact that the derivation remains red. All this means is that the system variables @USER0 through @USER4 are not listed in the DSParams file in the project directory on your DataStage server. The job will still compile and run correctly. If the red colour really...

What happens if you try to open that same job from the Manager?

You may need to re-index the repository database.

Do the folks who generated the XML files have a style sheet? (If not, what rules did they use for the tags?!!)
Get them to give you the style sheet, and you should be able to point the properties of the XML Reader stage to this.

The row count discrepancy might be accounted for if there were internal end-of-line characters in the rows output from the Transfomer stage. These rows would, properly, be seen as multiple lines in a text file.
Just a thought.

Take a look at the WEEK.TAG Transform supplied with DataStage. It's under Built-In\Dates category of the Transforms branch. In turn it invokes the WeekTag function, which is under the Examples category. In the routine you will find the business rules that determine which week is the first in the yea...

Can you give us a reference for this statement?
Is it on the Ascential web site?
Is there an e-case for it?

If you don't know what a hierarchical flat file is, why do you want to create one? It's not the kind of thing an ETL process would produce. Sometimes, though, it's necessary for an ETL process to be able to extract data from a hierarchical format in a file (which is what a hierarchical flat file is...

Private Message: Ray, Thank you for responding to my post. The information you provided was helpful, however, I'm having diffulty comprehending why we can't purge (or at least zero out) extremely large (by UNIX standards) DATA.30 & OVER.30 files that have not been touched/accessed in over a month - ...

Rebuild the Repository indexes.

You can do this in the Administrator client (Cleanup Project) or from the DS.TOOLS menu or DS.REINDEX ALL command on the server (within the "UniVerse" environment).

Here's a sig from a different forum that I saw this morning.

The package said Windows 98 or better so I installed Linux.

Whenever anyone says shell script, you can think BAT file. Nearly anything that can be done in a shell script on UNIX can be done in a BAT file on DOS. To execute "UniVerse" commands from the operating system shell, you must be attached to the project directory and have the DataStage Engine bin dire...

That message usually indicates that there is at least one character in your data that can not be mapped using the NLS character map set on that link. Usually there is a "?" character in the View Data grid indicating which character(s) could not be handled. If this is coming from an ODBC data source,...

There are many possible reasons that Next Link will begin processing the next row but they all have one thing in common; further processing of the current row can not proceed. Perhaps, as Peter suggested, the row is contrained from being written to a Transformer stage's output link. If this is not c...