DSXchange

Download ETLstats from Kim Duke's website - it's got all you want and more (unless you want some really arcane stuff).

And domain?

You using write cache?

Good catch. So a Trim() might also be indicated.

I doubt that posting the link would be regarded in Court as aiding and abetting the offence of copyright violation but, if you are concerned, simply edit your post appropriately.

Has anyone searched the IBM website recently?

vincentjeevan wrote:Hi, I have a requirement to maintain all SQL Queries outside Datastage.

Resist stupid requirements.

Probably both violating copyright. In any case, there are manuals for version 7.5 (which are the most recent as far as I am aware). I don't have a link for them.

Since you're already in DataStage BASIC, you could simply use OpenSeq to test for existence. It takes its THEN clause if the file exists, and its ELSE clause if the file does not exist. Don't forget to CloseSeq before exiting.

The Field() functions don't do anything (there is no "," in the source strings), or is there something extra you're not telling us? What are the sizes of the three Decimal fields in the target? Have you configured default values for them? Are they nullable? Do you allow "all zeroes&qu...

The easiest solution is probably one that involves the DataStage API functions DSGetLinkInfo() and DSGetLinkMetaData(). But that won't yield the folder name.

Welcome to the leading edge. No-one here has had the time yet to investigate the structure of XMETA or, if they have, they have not shared their findings. On the other hand, the database is "open", so you are able to investigate to your heart's content. All table definitions in version 8 a...

Please read this post first. If a company as large as yours doesn't have a corporate premium membership I would be very surprised. After being surprised, I would be of the opinion that it deserves every obstacle that occurs. TANSTAAFL (there ain't no such thing as a free lunch). Premium membership i...

Have you checked to determine whether qsrtmngr is actually installed and not yet started? That would have been my first step.

Search is your friend.

The maximum number of connections, of listeners, is set on the Oracle side, not on the DataStage side. Consult your friendly DBA. Bear in mind also that the "nine connections" of which you speak are on each node. So, if you are executing with a four-node configuration file, you are request...