ChannelDB2

Roger E. Sanders
  • Male
  • Fuquay Varina, NC
  • United States
Share on Facebook Share on Facebook Share

Roger E. Sanders's Friends

  • Akshay
  • Francesco Animali
  • Venkatareddy Bandi B
  • VENKATA NR GANNAM
  • Oswaldo Fabian Camacho Zepeda
  • Rakesh Tiwari
  • Josh Snyder
  • Luyza Tavares Alexandre
  • Brian Blakley
  • Nalini Kartha
  • Lohith
  • Gopal
  • Ricardo
  • Matthias Nicola
  • Surekha Parekh

Roger E. Sanders's Groups

Roger E. Sanders's Discussions

Gifts Received

Gift

Roger E. Sanders has not received any gifts yet

Give a Gift

 

Roger E. Sanders's Page

Profile Information

Full Name:
Roger E. Sanders
Job Title:
Consultant Corporate Systems Engineer
Company:
EMC Corporation
Platforms of Interest:
Linux/UNIX/Windows

Comment Wall (15 comments)

You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

At 4:56am on October 6, 2013, Akshay said…

Hi Roger,

Good Morning..!!

I am preparing for DB2 543 exam. I am using DB2 10 Express C edition.

Could you provide or suggest any manual or tutorial which will help in connectivity of DB2 with C,Java etc and also is there any tutorial for compilation of program through DB2 CLP ?

 

 

Thanks & Regards,

 

Akshay

At 11:30am on October 29, 2012, VENKATA NR GANNAM said…

Hi Roger,

Good Morning!

 

I am planning to take up the exam 732.  I searched for the tutorials (as we have for 730, 731, 733, 735).  I did not find any.  Could you please let me know, if at all do we have any tutorials for this or a good study guide atleast?

 

Thank you very much,

Venkata NR Gannam

At 10:09am on May 10, 2011, Oswaldo Fabian Camacho Zepeda said…

Hi Mr. Sanders,

 

Just trying to see if there's any update about you making a book/certification guide for 541 or 544?

At 8:10pm on March 15, 2011, Frank Vranesic said…

Hi Roger,  That helps.  I have some new people getting ready for the 9.7 exams in the coming months.  I'll be looking for the supplements to help them along.

Thanks.

At 5:09pm on March 15, 2011, Frank Vranesic said…
Hi Roger,  Now that the DB2 LUW Administration exams have been updated to 9.7, do you plan to publish a revised certification guide for 541 or 544?  By the way, your guides for the 700 series exams have helped several of my staff gain their certification.
At 9:16pm on December 22, 2010, Oswaldo Fabian Camacho Zepeda said…

Hi Mr. Sanders, I just got 730 and 731 (thks, your books are awesome!)

Now, I would like to ask, should I proceed with 734? or with 541?

At 9:19am on June 10, 2010, Vinay Bharadwaj said…
Hi Roger,
Your book on DB2 Fundamentals for the 730 exam helped me pass it. I am preparing for the 731 exam and was studying from the video from your (i think 2009) presentation on idug.org for the 731 exam. But I think they have removed the video. Is it a technical problem or the videos are deleted after some period of time (something like that ?).
Thanks
Vinay
At 12:42pm on June 10, 2009, Ruby Stepansky said…
Roger,
In the DB2 9 Fundamentals Certification Study Guide (for Exam 730):

See p. 338 Chapter 5 Question 1 and the answer given on p. 355 is claimedto be answer D. (For SELECT name from names, points;)
As suspected/expected, a SQL error will be gotten as documented below:

------------------------------ Commands Entered ------------------------------
connect to CHKITOUT ;
------------------------------------------------------------------------------
connect to CHKITOUT

Database Connection Information

Database server = DB2/NT 9.7.0
SQL authorization ID = REUVEN
Local database alias = CHKITOUT


A JDBC connection to the target has succeeded.
------------------------------ Commands Entered ------------------------------
create table a (cola integer with default 1,colb char(3));
------------------------------------------------------------------------------
create table a (cola integer with default 1,colb char(3))
DB20000I The SQL command completed successfully.

------------------------------ Commands Entered ------------------------------
create table b (cola integer with default 2,colb char(3));
------------------------------------------------------------------------------
create table b (cola integer with default 2,colb char(3))
DB20000I The SQL command completed successfully.

------------------------------ Commands Entered ------------------------------
insert into a (colb) values('ONE');
------------------------------------------------------------------------------
insert into a (colb) values('ONE')
DB20000I The SQL command completed successfully.

------------------------------ Commands Entered ------------------------------
insert into b (colb) values('TWO');
------------------------------------------------------------------------------
insert into b (colb) values('TWO')
DB20000I The SQL command completed successfully.

------------------------------ Commands Entered ------------------------------
select cola from a,b;
------------------------------------------------------------------------------
select cola from a,b
SQL0203N A reference to column "COLA" is ambiguous. SQLSTATE=42702

SQL0203N A reference to column "COLA " is ambiguous.

Explanation:

The column "" is used in the statement and there is more than one
possible column to which it could refer. This could be the result of:
* two tables specified in a FROM clause that have columns with the same
name
* the ORDER BY clause refers to a name that applies to more than one
column in the select list
* a reference to a column from the subject table in a CREATE TRIGGER
statement does not use the correlation name to indicate if it refers
to the old or new transition variable.

The column name needs further information to establish which of the
possible table columns it is.

The statement cannot be processed.

User response:

Add a qualifier to the column name. The qualifier is the table name or
correlation name. A column may need to be renamed in the select list.

sqlcode: -203

So, the answer cannot be D but at best A (0 rows) and in reality it's an error.
Sincerely,
Ruby Stepansky
reuven@us.ibm.com
rstepansky@aol.com
At 1:54am on May 30, 2009, Gitik said…
Can you provide dumps for DB2 -733.
At 1:53am on May 30, 2009, Gitik said…
Thanks for the download
 
 
 

Featured Downloads

Try BLU Acceleration on Cloud

© 2018   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service