DSXchange

Search the forums for "COMO ON".

I don't see anything wrong and simply using a job parameter more than once in the sql should not be an issue. However, connectors are new and this very well could be a bug. Suggest you contact your official support provider and then let us know what comes of it.

You need to correct your job design. Something is wrong if your hashed lookup is supposed to get you updates and then they're not found in the target database.

Being 'native' stages, both of the Oracle stages require the Oracle client to be installed on the DataStage server.

Please repost this in the proper forum, i.e. the QualityStage forum.

*Note - Topic relocated - Content Editor*

Still not a doing a very good job of choosing post titles.

I honestly cannot follow your description. Can we try again please, rephrase your requirements and (ideally) include some examples of the contents of these two flat files?

Your Teradata DBA?

Right... but realize the people that have it will use it and those that don't will post topics like this.

Do you mean the drop-down list of projects when connecting to Designer? Because there's no drop-down list of projects in Designer. There is drop down list of projects in Designer,probably you are confusing to Aministrator..otherwise how to log to particular project.. :? You're missing the differenc...

Not sure where the RT_CONFIGnnn mention came from, but good point about the two sources - RT_STATUSnnn for the most recent information (which seems to be all that is needed here) and RT_LOGnnn for runs as far back as you have logs.

An "xsd" is an "XML Schema Definition" and there are all kinds of resources out there for you to learn about them, including this site and many books. You would typically get this from the vendor or provider of the XML and is not something you attempt to build yourself... unless,...

Use 'code' tags to preserve whitespace and liberal use of the Preview function combined with editing to adjust for the proportional font being used:

From my reading of the post, the source was DB2 but is now flat files.

Yah! Working now... thanks.

Why not try putting them in the After SQL tab of your last stage?