Search found 979 matches

by Krishna
Mon Jan 17, 2011 3:20 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: VSAM & DB2 Comparion
Replies: 10
Views: 8554

VSAM has some limitations on size, it was 4 GB. It might have increased in recent times. check this. DB2 access always take more cost than VSAM file access. Answer below questions, to give clear picture to other members. 1. Total size of data, based on Record size ( total no of records * total size ...
by Krishna
Fri Jan 14, 2011 2:01 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: VSAM & DB2 Comparion
Replies: 10
Views: 8554

db2 table partitions

Normally, loading those many records will take more time. Contact your DBA and get how the target table defined, i.e, normally based on table key , they will split the table into partitions. If that is true , get the partition info from DBA. load each partition separately to process the jobs faster.
by Krishna
Mon Jan 10, 2011 2:27 pm
Forum: COBOL
Topic: fresher
Replies: 3
Views: 3245

You can go thru below jcl tutorial.

http://www.mainframegurukul.com/srcsinc ... l/jcl.html
by Krishna
Wed Dec 29, 2010 4:09 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Hi
Replies: 2
Views: 2273

You need to use dynamic sql to do that.
ie, use of EXEC SQL PREPARE, EXEC SQL EXECUTE or EXECUTE IMMEDIATE
by Krishna
Mon Dec 13, 2010 4:48 pm
Forum: Admin Announcements
Topic: DB2 QUICK START - FREE for Members
Replies: 81
Views: 110702

Hi Ravi,

Sent the password for passwordNumber 497.
by Krishna
Wed Dec 08, 2010 3:11 pm
Forum: Admin Announcements
Topic: DB2 QUICK START - FREE for Members
Replies: 81
Views: 110702

Hi Dick / Vamsi,

I have sent the password for you guys.



Ravi - Please wait , we will send the password in 2 days. continue participating in the forum. :)
by Krishna
Tue Dec 07, 2010 4:40 pm
Forum: COBOL
Topic: ABENDED S000 U4038
Replies: 12
Views: 14335

Anuj - We both are on the same page. Just suggestions are different.
by Krishna
Mon Dec 06, 2010 6:19 pm
Forum: COBOL
Topic: ABENDED S000 U4038
Replies: 12
Views: 14335

He has GO BACK in the ELSE part. It won't work for first IF condition part. ( Pass )

without modifing the original code.. just add STOP RUN (or) GO BACK will make the code work.
by Krishna
Fri Dec 03, 2010 6:15 pm
Forum: COBOL
Topic: ABENDED S000 U4038
Replies: 12
Views: 14335

Do you have STOP RUN after IF condition in your program?
by Krishna
Sat Nov 27, 2010 9:41 pm
Forum: Admin Announcements
Topic: DB2 QUICK START - FREE for Members
Replies: 81
Views: 110702

Hi Arun,

As per the rule menioned in the main post, you need to complete 10 valid posts in this forum to get the password. once you complete the posts, i will send the password to you.
by Krishna
Wed Nov 24, 2010 11:26 am
Forum: Admin Announcements
Topic: DB2 QUICK START - FREE for Members
Replies: 81
Views: 110702

Sent the password thru PM.
by Krishna
Mon Nov 22, 2010 10:53 am
Forum: CICS
Topic: ceci set prog(progname) newcopy - CICS NEWCOPY
Replies: 1
Views: 3347

newcopy

Make sure you copy the program into CICS libraries.
Try using following command for newcopy.

Code: Select all

CEMT SET PROG(prog name) NEWCOPY


if you have error. use CECI command, before issuing above CICS command.

Code: Select all

CECI LINK PROGRAM(program)
by Krishna
Mon Nov 15, 2010 7:26 pm
Forum: TSO, CLIST & REXX
Topic: Fle Compare Tool
Replies: 2
Views: 2866

Provide the structure of your files and key fields.
by Krishna
Mon Nov 15, 2010 11:48 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: how to use year function in db2 - date difference
Replies: 4
Views: 6609

DB2 DATE DIFFERENCE SUBTRACT DATES

Hi Waseem, Here is the code to find number of days between two days using db2 sql. You can use this data to find no of years between two dates. EXEC SQL SELECT DAYS (:WS-DATE-S) - DAYS (:WS-DATE-E) INTO :WS-DATE-DIFF FROM SYSIBM.SYSDUMMY1 END-EXEC Declare WS-DATE-DIFF as follows 01 W...
by Krishna
Sun Nov 14, 2010 11:35 pm
Forum: JCL
Topic: IEBCOPY SELETE MEMBER
Replies: 1
Views: 3060

SYSIN CARD IN IEBCOPY

Here is IEBCOPY SYSIN example.

Code: Select all


//SYSIN DD *
  COPY OUTDD=outddnmae,INDD=inddname
  SELECT MEMBER=(C1,C2,C3)
/*