DSXchange

This isn't a "limit" on DataStage --- it's not even a "key"....it's simply the trick that is used to identify to DataStage which "path" of repeating rows you are interested in for this link. Without any additional knowledge about this document, it is incumbent upon you ...

I haven't tried it in awhile, but assuming that the data is a stand-alone xml document, the xmlInput Stage could take a url for retrieval of the document. I can't promise it will work, but it's worth a try. If it's not xml, then it will have to be data that is delivered via a formal Web Service, wit...

Sreeni is describing the two major steps that you have to follow ......first, extract it from Oracle, defining it as a string datatype (or whatever else you need to use to get it to work). Be sure you can extract it and put it into a test sequential file (without any formatting, no row terminator or...

I haven't tried any of these beyond early viewing of the supported CVS and Clear Case scenarios, but as far as I know, there is a requirement that whatever versioning tooling you try must have a plugin that is an implementation of Eclipse Team Support and formally supports Eclipse 3.3.

Ernie

I found out about an anomaly that was discovered regarding false positives. It was created when tablename was left blank and user defined SQL was specified. Automated Services because confused under that circumstance. It is not related to your issue, if you have the tablename populated, but it was w...

.....when would a database "not" be present? ..when it was carelessly left out.....(as in an unfinished job)....

...although the real key I'm looking for is where (if) the tablename property is left blank, and user defined SQL is used for the actual "action".

Ernie

...checked into some other possibilities.....

Take a look at your Connectors...

Let me know if:

a) they use custom SQL
b) they don't have an actual "tablename" populated in the tablename property
c) is database specified?

Thanks.

Ernie

....and you said earlier that you specifically checked the "Data Item Binding" settings for these two Jobs? ...by the way, is there anything in common between the two Jobs? Are they sharing columns and common parameter sets for their properties in the target and source connectors? ...are t...

You are confusing me... ;) you said up above that when you click on Display Final Assets, the table is added to the list. Clearly that is not the case, as it appears when you first get there, as it should. No matter. At least we know the asset page is behaving normally. So...it's certainly a strange...

I haven't tested all the variations with nulls and that setting, but from an xml perspective, it doesn't matter... <CustLang/> and <CustLang></CustLang> are equivalent. ...provided however, that the person/application who is reading your document understands xml, and is using a normal xml parser. Yo...

Looking at your last statement. Are you saying that the list of assets "increases" when you click display final assets? Without clicking display graphical or textual, the table created within IA just "appears" in the list? Is that "table definition" a regular Shared Tab...

...."copied java file content and pasted..." What "Java File content" are you referring to? The code above? How familiar are you with Java? Have you coded in java? Do you know how to compile a class. Forgive me if you do that all the time --- it's hard to tell from the questions ...

Ok...you are using a very basic sample...that's a good thing for getting started. I've seen a lot of strange errors, but not the ones that you have below. Usually when getting started people run into classpath problems or, in early 8.x, jvm initialization errors. Anyone else who plays with JavaPack ...

I don't have access to DataStage right now, so I can't check, but the old MQ Plugin has a lot of "other" filter options, and the Connector may also. They are really inefficient (they require a browse of the message then examination of one part of them before taking an action or moving on t...

Ok...good. So those things can be eliminated. Looking forward to hearing what you find as you research the un-checking of types of lineage and other items noted above.

Ernie