DSXchange

Data Item binding binds a Shared Table to a "Stage". If the Stage has an "output link", it should bind it as the "reads from" relationship. If the stagehas an input link (a target) it shoudl bind it as the "writes to" relationship. Tell us a little bit more ab...

The newer editions of the bridges have a bridge for 8.3/8.4 (this is how it appears in the pull down).... probably makes sense to contact support do that they can decipher exactly what release you have and/or need.

Yes...check them both.

You don't need to buy WS Pack.....but it's been too long --- I don't remember when in v7 we started to "include it." The product you are referring to below is the ability for DataStage to "be" a web service (RTI). Look in your real-time folder when editing a job...see if you have...

Sorry about the binding confusion up above...I often find that developers on an ESB are doing J2EE work and sometimes prefer to use the EJB binding...if they are using SOAP, that's great --- it is FAR easier to use and test and develop, etc... The same issues apply, however, just that you get 3 oper...

Ok...so we know it's not the number of columns, or the name of the column....I suppose it could still be something with the size of the column......but you're getting closer. It looks more like it is something "in" the data for that column. Try doing things like truncating it and seeing wh...

Yes...when you create the EJB binding you will generate a client side jar for the developers.......it's been awhile since I've coded the EJB client side, but the Jar should ultimately have three available methods --- one for each operation and each with the proper signature.

Ernie

We need to get you up and onto 8.1.2 or at least 8.1.1.....in fact, I'm not even sure that you are on 8.1..... When you did the import, there is a value for Host and for Database in the import screens.....I'll have to check again, as I haven't done an ODBC import in awhile, but you should be able to...

...No....right now you have a column called "person_info" going into WISDOutput....correct? Put a Transformer directly in front of the WISDOutput Stage. Pass all of the columns thru it, with no transformation ....except for person_info. Hard code it to "hello". See if you get a v...

Both options are possible.... the choice depends on how complex you want the job to be, and what the developers of the client side want to do in terms of work effort and complexity also... Also consider how often they use option 1, 2 or 3...do they ALWAYS want name, address and contact information? ...

That's the "empty" element. Usually means tha the data doesn't exist for that particular row...or maybe is null.

What happened with hard coding it to the value of "hello"?

Ernie

...check them...send them also to a peek, and/or to a sequential file, and then also try hard coding the value in the transformer and see if you see that value instead of the prior upstream value. The reason to try the hard coded value is to see if it is something that is in the data from upstream. ...

Hard to say....If other columns are ok, I'd start looking at specific row values, and also test with putting a transformer in front of it that entirely replaces your upstream values (just force the whole colum to be "hello".) There must be something odd about that particular row, or that p...

do you see "anything" in the output (ie...do you have othe colukmns also, that appear fine, and just this column isn't appearing? ...or is it that you aren't getting "anything" from the service).

Ernie

I like to use two bridges....first, the Packages bridge.......and then the Report Studio bridge.... This provides selection of individual reports and queries, and avoids any memory issues. I'm concerned about your release though.....it's been awhile since there were separate bridges for query and re...