Search found 979 matches
- Mon Jan 17, 2011 3:20 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: VSAM & DB2 Comparion
- Replies: 10
- Views: 12331
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 ...
- Fri Jan 14, 2011 2:01 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: VSAM & DB2 Comparion
- Replies: 10
- Views: 12331
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.
- Wed Dec 29, 2010 4:09 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Hi
- Replies: 2
- Views: 4060
- Mon Dec 13, 2010 4:48 pm
- Forum: Admin Announcements
- Topic: DB2 QUICK START - FREE for Members
- Replies: 81
- Views: 156352
- Wed Dec 08, 2010 3:11 pm
- Forum: Admin Announcements
- Topic: DB2 QUICK START - FREE for Members
- Replies: 81
- Views: 156352
- Tue Dec 07, 2010 4:40 pm
- Forum: COBOL
- Topic: ABENDED S000 U4038
- Replies: 12
- Views: 24519
- Mon Dec 06, 2010 6:19 pm
- Forum: COBOL
- Topic: ABENDED S000 U4038
- Replies: 12
- Views: 24519
- Fri Dec 03, 2010 6:15 pm
- Forum: COBOL
- Topic: ABENDED S000 U4038
- Replies: 12
- Views: 24519
- Sat Nov 27, 2010 9:41 pm
- Forum: Admin Announcements
- Topic: DB2 QUICK START - FREE for Members
- Replies: 81
- Views: 156352
- Wed Nov 24, 2010 11:26 am
- Forum: Admin Announcements
- Topic: DB2 QUICK START - FREE for Members
- Replies: 81
- Views: 156352
- Mon Nov 22, 2010 10:53 am
- Forum: CICS
- Topic: ceci set prog(progname) newcopy - CICS NEWCOPY
- Replies: 1
- Views: 6076
newcopy
Make sure you copy the program into CICS libraries.
Try using following command for newcopy.
if you have error. use CECI command, before issuing above CICS command.
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)
- Mon Nov 15, 2010 7:26 pm
- Forum: TSO, CLIST & REXX
- Topic: Fle Compare Tool
- Replies: 2
- Views: 4569
- 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: 9209
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...
- Sun Nov 14, 2010 11:35 pm
- Forum: JCL
- Topic: IEBCOPY SELETE MEMBER
- Replies: 1
- Views: 4568
SYSIN CARD IN IEBCOPY
Here is IEBCOPY SYSIN example.
Code: Select all
//SYSIN DD *
COPY OUTDD=outddnmae,INDD=inddname
SELECT MEMBER=(C1,C2,C3)
/*