transaction level isolation

agpt · Post by **agpt** » Fri May 21, 2010 8:52 am

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.

chulett · Post by **chulett** » Fri May 21, 2010 11:02 am

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

agpt · Post by **agpt** » Fri May 21, 2010 11:20 am

vinothkumar · Post by **vinothkumar** » Fri May 21, 2010 11:22 am

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.

vinothkumar · Post by **vinothkumar** » Fri May 21, 2010 11:23 am

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.

vinnz · Post by **vinnz** » Fri May 21, 2010 12:04 pm

http://publib.boulder.ibm.com/infocente ... 04121.html

agpt · Post by **agpt** » Fri May 21, 2010 12:11 pm

Thanks a lot

Now it's a lot clear to me

chulett · Post by **chulett** » Fri May 21, 2010 1:07 pm

So... no helpful DBA?

agpt · Post by **agpt** » Fri May 21, 2010 1:11 pm

agpt · Post by **agpt** » Fri May 21, 2010 10:56 pm

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

chulett · Post by **chulett** » Fri May 21, 2010 11:19 pm

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

agpt · Post by **agpt** » Sat May 22, 2010 2:10 am

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.

chulett · Post by **chulett** » Sat May 22, 2010 6:41 am

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.

agpt · Post by **agpt** » Sat May 22, 2010 10:19 am

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.

chulett · Post by **chulett** » Sat May 22, 2010 10:48 am

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.