DSXchange

So what you actually want is the Engine hostname(s), rather than the Services tier hostname. Is this correct? Remember that one services tier can support any number of engine tiers. How will you specify which one you want if there is more than one? Ultimately I believe you're looking at a query agai...

There is no UniVerse database in version 8.

The last version of DataStage that used UniVerse as its engine was, if I recall correctly, 5.2.

Resist stupid requirements!!!

Not if sequences are not permitted. How are you planning to read the file in the context of the dsjob command?

If you're going to use dsjob, why bother? Just use the date command.

Welcome aboard.

ssmuki wrote:In oracle ...

Now there's an assumption!

The > redirection operator is just as valid in Windows.

The approach is to use a DataStage job or routine or execute command activity to populate this file.

Three questions; one answer.

Disable operator combination to learn where the error is actually occurring.

You can specify a cast or conversion function in the extraction SQL. It's done differently with different database types (e.g. DB2, Oracle). So you need to specify that. A generic solution is to read the timestamp as a timestamp and use a conversion function such as date_from_timestamp() in a Modify...

What is the data type in the database? What data type are you using in the DataStage link? Can you post the SQL that's generated (or user-defined)?

Can you post an actual data example, along with "some control characters" being identified?

It might be worth re-indexing your repository using the DS.REINDEX ALL command. Search DSXchange for details of how to use this command. In particular make very sure that you have exclusive access to the project.

And, from that, you can see that there are line-terminating THEN statements with no corresponding END statements.

Show us the actual SQL - you should be able to find it in the job log. I suspect a syntax error.