DSXchange

Hi All,
Can anybody please tell me what is the difference between cursor stability, repeatable read and read stability in DB2 API stage?

I also couldn't find general tab options like SQL builder or option tab options like create table action.

Please help.

If you have a helpful DBA, ask them. Me, I have no clue for DB2 but they certainly should.

These concepts are related for DB2 and used for maintaining consistency while reading rows from table when someone tries to update/insert in same table. For more details refer any DB2 tutorials.

These concepts are related for DB2 and used for maintaining consistency while reading rows from table when someone tries to update/insert in same table. For more details refer any DB2 tutorials.

Thanks a lot

Now it's a lot clear to me

So... no helpful DBA?

I also couldn't find general tab options like SQL builder or option tab options like create table action. ????

Have you read Chapter 1 of the Connectivity Guide? What it does (and doesn't does) should be in there.

Yes chulett, I have gone through tat and there only there are talking about these options but when I tired tried in my DS installation, I couldn't find these there.

So... ... are you saying that the documentation mentions them for that stage but you cannot in fact find them in the actual stage? Someone else will have to help with that, I've have no actual DataStage access since 2009 so have no way to check anything.

Oh, and you really should have started a new post for this new question.

Chulett,

Actually this was part of my original question. I got answer to first part of question but not to second one so I asked again in the same post again.

Ah... sorry, was going by the Subject and didn't re-read the original post.

And even though I can't help directly, it would be good if you answered my question so we know that is indeed what you are saying.