Dilbur wrote:

>Hi,

>I had been campus recruited by IBM Global Services and after only one
>month training I am working as a DB2 DBA on client side for past two
>months.

I'll remember this next time someone tries to sell me IBM Global
Services.

>I dont see many oppurtunities building for me in future since a DBA
>without prior knowledge of SQL and PLSQL is useless.

Does DB2 really use PLSQL?

>shall I go for a project change at this point of time!!!

Stick it out for a couple of years, unless you are getting negative
feedback, or if there is something else you'd rather be doing.

jg
--
@home.com is bogus.
http://www.wedonotuse.com/

On 2006-01-23, Joel Garry <joel-garry@home.com> wrote:
> Dilbur wrote:
>
>>Hi,
>
>>I had been campus recruited by IBM Global Services and after only one
>>month training I am working as a DB2 DBA on client side for past two
>>months.
>
> I'll remember this next time someone tries to sell me IBM Global
> Services.

Oh please. Consulting shops in general are like that.

Why would IBM be any different. Besides, a quick study might
actually be better that some old fossil with skills that look better
on paper than they are in practice.

[deletia]

--
If you think that an 80G disk can hold HUNDRENDS of |||
hours of DV video then you obviously haven't used iMovie either. / | \

Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

"Joel Garry" <joel-garry@home.com> writes:
> Dilbur wrote:
>>I had been campus recruited by IBM Global Services and after only one
>>month training I am working as a DB2 DBA on client side for past two
>>months.
>
> I'll remember this next time someone tries to sell me IBM Global
> Services.

This is pretty standard; I have seen PWC consultants flown in that
were equally green...

In a big project, there's always *some* attempt at some
"featherbedding" of this sort, and, with a big project, you can't
necessarily expect to be able to cherry-pick their best consultants.
The only way they can *eventually* provide experienced people is by
starting them green...

>>I dont see many oppurtunities building for me in future since a DBA
>>without prior knowledge of SQL and PLSQL is useless.
>
> Does DB2 really use PLSQL?

PL/SQL is usually considered to be the proprietary Oracle stored
procedure language. DB2 doesn't support that.

It supports a stored procedure language that corresponds pretty much
with the SQL:1999 standard.

>>shall I go for a project change at this point of time!!!
>
> Stick it out for a couple of years, unless you are getting negative
> feedback, or if there is something else you'd rather be doing.

Indeed, there are things worth learning...
--
let name="cbbrowne" and tld="acm.org" in String.concat "@" [name;tld];;
http://www3.sympatico.ca/cbbrowne/rdbms.html
Rules of the Evil Overlord #152. "I will instruct my fashion designer
that when it comes to accessorizing, second-chance body armor goes
well with every outfit. <http://www.eviloverlord.com/>

Chris Browne wrote:
> "Joel Garry" <joel-garry@home.com> writes:
> > Dilbur wrote:
> >>I had been campus recruited by IBM Global Services and after only one
> >>month training I am working as a DB2 DBA on client side for past two
> >>months.
> >
> > I'll remember this next time someone tries to sell me IBM Global
> > Services.
>
> This is pretty standard; I have seen PWC consultants flown in that
> were equally green...
>
> In a big project, there's always *some* attempt at some
> "featherbedding" of this sort, and, with a big project, you can't
> necessarily expect to be able to cherry-pick their best consultants.
> The only way they can *eventually* provide experienced people is by
> starting them green...

The dead thread is alive again!

>From a prior life, I have some good stories about Andersen Consulting
aka Accenture and consulting services provided by them. Just honest
and true stories from life with a former employer.

But most of those are reserved for private discussions and some
alcohol.

Beware of listing something/anything on your resume even if it was a
college course that included a week or a day about any given
programming language.

You too might be the next high profile domain expert!

Try not to ask the people picking you up at the Airport directions to
the local Borders. It might be better to get there yourself.

Hi ,

As far as PLSQL is considered Db2 has its own set of structural
Prograaming . It is referred to as SQL PL in DB2 .
The fundamentals are same whethere its DB2 or Oracle. I had a 2 yr
of exposure in PLSQl of Oracle , and suddenly when I joined IBM I
was put into DB2 .. Though initially it was very difficult now i am
quiet comfortable.

PL?SQL or SQL PL ....is basically used for server side programming
and that exists for both DB2 as well as Oracle or for that matter any
database.

Regards

In article <1141041412.528642.261910@t39g2000cwt.googlegroups .com>,
(bikkaran@in.ibm.com) says...
> Hi ,
>
> As far as PLSQL is considered Db2 has its own set of structural
> Prograaming . It is referred to as SQL PL in DB2 .
> The fundamentals are same whethere its DB2 or Oracle. I had a 2 yr
> of exposure in PLSQl of Oracle , and suddenly when I joined IBM I
> was put into DB2 .. Though initially it was very difficult now i am
> quiet comfortable.
>
> PL?SQL or SQL PL ....is basically used for server side programming
> and that exists for both DB2 as well as Oracle or for that matter any
> database.
>
> Regards
>
>

The big difference is that SQL PL statements can't be run from the
commandline. They have to be put into a stored procedure or function.
It would be very nice if SQL PL could be used from within commandline
scripts.

Gert van der Kooij wrote:

> The big difference is that SQL PL statements can't be run from the
> commandline. They have to be put into a stored procedure or function.
> It would be very nice if SQL PL could be used from within commandline
> scripts.

But you already can do that today:

db2 => begin atomic declare x int; set x = 2; set x = x*x*x; insert into t
values (x); end
DB20000I The SQL command completed successfully.
db2 => select * from t

A
-----------
8

1 record(s) selected.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Gert van der Kooij wrote:
> In article <1141041412.528642.261910@t39g2000cwt.googlegroups .com>,
> (bikkaran@in.ibm.com) says...
>
>>Hi ,
>>
>>As far as PLSQL is considered Db2 has its own set of structural
>>Prograaming . It is referred to as SQL PL in DB2 .
>>The fundamentals are same whethere its DB2 or Oracle. I had a 2 yr
>>of exposure in PLSQl of Oracle , and suddenly when I joined IBM I
>>was put into DB2 .. Though initially it was very difficult now i am
>>quiet comfortable.
>>
>>PL?SQL or SQL PL ....is basically used for server side programming
>>and that exists for both DB2 as well as Oracle or for that matter any
>>database.
> The big difference is that SQL PL statements can't be run from the
> commandline. They have to be put into a stored procedure or function.
> It would be very nice if SQL PL could be used from within commandline
> scripts.
I think the IBM position on that is that SQL/PSM (which is the ANSI name
of the beast) would be "just one more" scripting language on the client.
Why waste good resources without adding function?
(Not my position, mind you)

In favor of that position I must note that often the request for SQL PL
scripting is paired with request for #define style substitution
capabilities even more so that logic.
And now you're really in the domain of PERL et al.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

In article <dturso$3e4$1@lc03.rz.uni-jena.de>, Knut Stolze
(stolze@de.ibm.com) says...
> Gert van der Kooij wrote:
>
> > The big difference is that SQL PL statements can't be run from the
> > commandline. They have to be put into a stored procedure or function.
> > It would be very nice if SQL PL could be used from within commandline
> > scripts.
>
> But you already can do that today:
>
> db2 => begin atomic declare x int; set x = 2; set x = x*x*x; insert into t
> values (x); end
> DB20000I The SQL command completed successfully.
> db2 => select * from t
>
> A
> -----------
> 8
>
> 1 record(s) selected.
>
>

Then it's time to update the online docs at http://tinyurl.com/ped93
Table 4 shows all supported SQL from the command line and it clearly
states that assignment variables are allowed within SQL procedures
only.

Ps. Knut, you did set the followup to comp.databases.oracle.server, I
guess that was mistake?

Hi guys its me again....now i have cleard 700 and 701
got 90% in 700
and 90% in 701

but the place i am working in sucks big time only politics and nothing
more....i am gettting frustated only theory wont help :'(

what to do guys shall i complete one year here and complete 704 also???
can i get another job now right now ? my total work experience is only
6 months