Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
agpt
Participant
Posts: 151 Joined: Sun May 16, 2010 12:53 am
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
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
agpt
Participant
Posts: 151 Joined: Sun May 16, 2010 12:53 am
Post
by agpt » Fri May 21, 2010 11:20 am
vinothkumar
Participant
Posts: 342 Joined: Tue Nov 04, 2008 10:38 am
Location: Chennai, India
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
Participant
Posts: 342 Joined: Tue Nov 04, 2008 10:38 am
Location: Chennai, India
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
Participant
Posts: 92 Joined: Tue Feb 17, 2004 9:23 pm
Post
by vinnz » Fri May 21, 2010 12:04 pm
agpt
Participant
Posts: 151 Joined: Sun May 16, 2010 12:53 am
Post
by agpt » Fri May 21, 2010 12:11 pm
Thanks a lot
Now it's a lot clear to me
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Fri May 21, 2010 1:07 pm
So... no helpful DBA?
-craig
"You can never have too many knives" -- Logan Nine Fingers
agpt
Participant
Posts: 151 Joined: Sun May 16, 2010 12:53 am
Post
by agpt » Fri May 21, 2010 1:11 pm
agpt
Participant
Posts: 151 Joined: Sun May 16, 2010 12:53 am
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
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
agpt
Participant
Posts: 151 Joined: Sun May 16, 2010 12:53 am
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
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
agpt
Participant
Posts: 151 Joined: Sun May 16, 2010 12:53 am
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
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers