DSXchange

ds_teg wrote:Unfortunately I don't have select access from datastage server . I have select access from local desktop . So any other suggestions ??

GET access.

I regret to inform you that Paul the Octopus, who correctly picked the results of all finals games in the FIFA World Cup, has died of natural causes.

So any organizations who might have been planning to outsource decision making to Paul will have to re-think their options.

The answer to the first question is "no". BLOB is not a supported data type.

The other questions are therefore moot.

You might be able to cast it as Long VarBinary (or even Long VarChar) during extraction. But there's nothing sensible you can do with it during transformation.

swapnilverma wrote:do u still need help with logic ?

Probably not. U did not ask the questions. (U is one of our DSXchange community.)

Sounds like your DataStage credentials (Web Console for Information Server, Domain Management menu) are not set up correctly.

Can you get SELECT access to the Oracle system tables in which metadata are stored? That's all you need to import metadata - you don't need to be able to access the table itself.

You can override the job property within the Stage. There's an NLS tab in stage properties.

Does top write to stdout or stderr or some other file unit mapped to the tty?

Does top write to stdout or stderr or some other file unit mapped to the tty?

What Arnd and I are asking is "have you created a parallel routine (which is an interlude to your real routine) in DataStage?"

No-one had mentioned "sequence" earlier, which is why I felt mine was a pertinent contribution.

Is this in a QualityStage job? (You have posted in the QualityStage forum.)

I recall something similar, which leads me to suspect that the trigger to enable name handling is that the rule set name ends in "NAME", for example "SNNAME".

You can generate whatever date in whatever format you like in the parameter value expression in a job sequence Job activity (or upstream thereof).

You are just going to love the XML handling in version 8.5!