Search found 979 matches

by Krishna
Sun Sep 11, 2011 10:07 pm
Forum: Admin Announcements
Topic: DB2 QUICK START - FREE for Members
Replies: 81
Views: 110749

Hi Guru,

I have sent the password for 52.

Others - Please note.. you need to complete 10 quality posts in this forum to get the e-book for free. otherwise, please buy this e-book, details can be found in the following location.

http://www.mainframegurukul.com/products.html
by Krishna
Sun Sep 11, 2011 9:56 pm
Forum: Admin Announcements
Topic: DB2 QUICK START - E-Book Release - only for $5
Replies: 45
Views: 79978

Hi Subha,

Please dont publish email and phone numbers.. i am deleting the info from here.
e-book cost increase to 200. Please pay rest of the amount and get the password.
by Krishna
Tue Apr 19, 2011 11:26 pm
Forum: Admin Announcements
Topic: DB2 QUICK START - FREE for Members
Replies: 81
Views: 110749

Venkatesh,
You need to complete minimum 10 posts ( questions or answers ) in the forum to get the password. (or) purchase it.
by Krishna
Sun Mar 27, 2011 10:34 pm
Forum: Admin Announcements
Topic: DB2 QUICK START - E-Book Release - only for $5
Replies: 45
Views: 79978

Hi Anuj,

I have sent your password.
by Krishna
Tue Mar 22, 2011 10:35 pm
Forum: Admin Announcements
Topic: DB2 QUICK START - E-Book Release - only for $5
Replies: 45
Views: 79978

Hi All,

I have the passwords to all, who are all waiting.
by Krishna
Thu Mar 17, 2011 10:44 pm
Forum: Admin Announcements
Topic: DB2 QUICK START - FREE for Members
Replies: 81
Views: 110749

Partha / Vardini ,

I have sent the passwords for you.
by Krishna
Wed Feb 09, 2011 11:02 am
Forum: Admin Announcements
Topic: DB2 QUICK START - FREE for Members
Replies: 81
Views: 110749

Please check the main post, you need to complete minimum no of pots on this board to give that password.
by Krishna
Tue Feb 08, 2011 2:49 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Query using DELETE
Replies: 6
Views: 19036

Following code might work.

Code: Select all

DELETE FROM TABLE.PROD_TBLE 
WHERE PRD_ID_DESC IN
('481032' , '409038' ) ;
when you are using IN keyword, symbol % may not work.
by Krishna
Mon Feb 07, 2011 12:33 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Query using DELETE
Replies: 6
Views: 19036

Can you provide the sql statement that worked out.
by Krishna
Sun Feb 06, 2011 7:55 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Query using DELETE
Replies: 6
Views: 19036

SQLCODE -104, LIKE, IN keyword

Instead of LIKE keyword use IN keyword.
by Krishna
Sun Jan 30, 2011 9:52 am
Forum: JCL
Topic: execute qtp script using jcl possible?
Replies: 3
Views: 5266

QTP software.

I did not used this tool before, but here is what i know about this tool. QTP is a testing tool like Winrunner & TestPartner. QTP support mainframe applications with configuration of TE add-in. QTP supports the following emulators Attachmate, RUMBA, Hummingbird, seagull. With these emulator QTP Work...
by Krishna
Wed Jan 26, 2011 10:00 pm
Forum: Admin Announcements
Topic: DB2 QUICK START - FREE for Members
Replies: 81
Views: 110749

Hi Sameer,

You can either purchase this product (or) complete minimum 10 quality posts in this forum to get the password for free.

http://www.mainframegurukul.com/products.html
by Krishna
Thu Jan 20, 2011 9:36 pm
Forum: CICS
Topic: Getting Into CICS to define a VSAM File
Replies: 1
Views: 2701

CEDA is a CICS supplied transaction to define resources to CICS.

define VSAM file

Code: Select all

   CEDA DEFINE FILE(FILE12) GROUP(AA)

To go to cics region, use following command from ISPF panels.

Code: Select all

\g CICS01
here cics01 is CICS01 region name.
by Krishna
Tue Jan 18, 2011 6:58 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Selective select in Batch Cobol
Replies: 1
Views: 1813

I am not sure whether i understood your question correctly. here is my answer based on whatever i understood. You currently implemention may not be right, because it is using different cobol moudles with different selects, if the aim is to get the data from the same table. As you suggested you can g...
by Krishna
Tue Jan 18, 2011 6:41 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: VSAM & DB2 Comparion
Replies: 10
Views: 8558

Normally, in batch process , for reporting purposes. many shops use VSAM files to store data. They schedule all jobs in such a way , once VSAM file got created, those jobs will run one after another to generate reports. If your scenario is similar to what is explained above.. you can go for VSAM. if...