Search found 537 matches

by Natarajan
Thu Dec 11, 2008 6:00 pm
Forum: Personality Development
Topic: Think out of the Box!!!
Replies: 0
Views: 2374

Think out of the Box!!!

Think out of the Box!!! Employee "A" in a company walked up to his manager and asked what my job is for the day? The manager took "A" to the bank of a river and asked him to cross the river and reach the other side of the bank. "A" completed this task successfully and reported back to the manager a...
by Natarajan
Thu Dec 11, 2008 5:57 pm
Forum: EASYTRIEVE
Topic: To split matched and unmatched records into 2 files
Replies: 4
Views: 16254

Hi Senthil,

I have the answer... but please post the topic in appropriate forum.
Please post it in easytrieve forum. i will give answer there.

moderators - Please move/delete this topic from here.
by Natarajan
Thu Dec 11, 2008 5:51 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: wants to Learn DB2
Replies: 3
Views: 5354

db2 application programming DBA learning certification

Hi Subbu, I dont know, much about DBA. Application Programmer just need to know, DB2 SQL and COBOL-DB2 programming. as per my knowledge DBA - should know the advanced DDL's and tools to maintain the database, need to know the performance tuning techniques at table space level. it is more kind of adv...
by Natarajan
Thu Dec 11, 2008 4:09 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: update query
Replies: 2
Views: 2766

Hi Rekha,

Please post this in your original topic. so that i can reply.
i can't reply give the answer in this thread/topic... because this thread/topic will get deleted by moderator of this forum.

i hope you understand my words.
by Natarajan
Thu Dec 11, 2008 4:06 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: wants to Learn DB2
Replies: 3
Views: 5354

Hi Subbu,

welcome to mainframegurukul.com

comming to your point regarding learning DB2. Do you want to become a DB2 programmer or System DBA?

Based on your answer and i can suggest some online resources to you.
by Natarajan
Wed Dec 10, 2008 5:58 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: update query
Replies: 2
Views: 2766

Please dont create new topic.... reply to the same topic

Use your old topic
http://www.mainframegurukul.com/Mainfra ... php?t=3648

click on reply ... dont click on post.. it will create new topic..


Moderators - Please delete this duplicate topic.
by Natarajan
Tue Dec 09, 2008 4:32 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DB2 Precompilation Process
Replies: 4
Views: 8915

DB2 SYSIBM.SYSPLAN SYSIBM.SYSPACKAGE PLAN PACKAGE COLLECTION

As per my knowledge - Point 1) DB2 records information about plans and packages, in the tables SYSIBM.SYSPLAN and SYSIBM.SYSPACKAGE. Point 2) Only packages will store in directory, in addition to what is stored in catalog tables. Plan is a name to link many packages, collections. so the details are ...
by Natarajan
Tue Dec 09, 2008 1:17 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DB2 Precompilation Process
Replies: 4
Views: 8915

Hi Raghavendra,

Welcome to mainframegurukul.com.

The DB2 records information about plans and packages, in the tables SYSIBM.SYSPLAN and SYSIBM.SYSPACKAGE.
by Natarajan
Mon Dec 08, 2008 11:03 am
Forum: EASYTRIEVE
Topic: Easytrieve programs
Replies: 6
Views: 14610

Hi Tijo,

Welcome to mainframegurukul.com discussion forum.

Please post this topic in EASYTRIEVE forum.
by Natarajan
Sat Dec 06, 2008 5:53 pm
Forum: JCL
Topic: Sticky: Introduction to JCL interactive course.
Replies: 2
Views: 2812

Thanks Anuj. good information.
by Natarajan
Fri Dec 05, 2008 9:44 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DB2 Database access from various mainframe machines
Replies: 7
Views: 7465

DB2 SQL CONNECT DRDA Programming

You may need to use EXEC SQL CONNECT command for this. Server should be opened for distributed access - DRDA - ( Distributed Relational Databes Access ). You may get some more info in the followng links http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.apsg/db2...
by Natarajan
Thu Dec 04, 2008 2:13 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Cobol Stored Procedure to access non-DB2 resource
Replies: 2
Views: 5151

Hi Shwetha,

Welcome to mainframegurukul.com

Following link may help you.

http://publib.boulder.ibm.com/infocente ... ources.htm
by Natarajan
Thu Dec 04, 2008 1:24 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DB2 exam guide
Replies: 4
Views: 5535

Hi Vishal,

Welcome to mainframegurukul.com

You may download this guide in below link.
http://www.addebook.com/it/elearning/db ... _5747.html
by Natarajan
Thu Dec 04, 2008 1:19 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DB2 Database access from various mainframe machines
Replies: 7
Views: 7465

Hi Perumal,


As i know, if you have IP address, user-id and password to connect to the server.
we can connect to any server, it may be in mainframe or LINUX, it does not matter.

Any other views....
by Natarajan
Thu Dec 04, 2008 1:16 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: update query
Replies: 3
Views: 5000

let me know after testing, if you still have the issues.