Search found 11 matches
- Tue Oct 24, 2006 11:23 am
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: current date,time
- Replies: 2
- Views: 11583
Hi To add to it you can get the current timestamp by giving SELECT CURRENT TIMESTAMP FROM SYSIBM.SYSDUMMY1 ********************************* Top of Data *************** ---------+---------+---------+---------+---------+---------+- SELECT CURRENT TIMESTAMP FROM SYSIBM.SYSDUMMY1 ---------+---------+--...
- Tue Oct 24, 2006 11:17 am
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: date -updation
- Replies: 2
- Views: 8049
- Tue Oct 03, 2006 3:20 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Performance tuning..
- Replies: 5
- Views: 14636
- Fri Sep 29, 2006 11:56 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: SORT JCL - SORTING A VB FILE - INREC OUTREC PARSE BUILD
- Replies: 7
- Views: 63533
- Thu Sep 28, 2006 1:33 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: SORT JCL - SORTING A VB FILE - INREC OUTREC PARSE BUILD
- Replies: 7
- Views: 63533
SORT JCL - SORTING A VB FILE - INREC OUTREC PARSE BUILD
Hi, I want to sort a VB formatted file and remove the duplicates after summing up the amount. For e.g.. I have a file having 4 fields in it. Lets say Emp#, Empname, Account, Salary. The records are like: 36,sar,rte,456 45,amb,,698 36,sar,rte,400 45,amb,rte,600 I want to sort the above file so that m...
- Mon Aug 07, 2006 4:36 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: PERFORMANCE TUNING.
- Replies: 0
- Views: 6725
PERFORMANCE TUNING.
Hi all, I have a query to be tuned for performance. The reason being its using a table ORDER_LI which is having huge volume of data. I am using the indexed columns only. But as I have a SUM function in the query i dont think it will help. Please provide me some pointers to improve the performance. S...
- Tue Jul 04, 2006 5:30 pm
- Forum: JCL
- Topic: Help required for a sort step.
- Replies: 5
- Views: 14445
- Thu Jun 29, 2006 9:59 am
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Performance tuning..
- Replies: 5
- Views: 14636
- Tue Jun 27, 2006 12:18 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Performance tuning..
- Replies: 5
- Views: 14636
Performance tuning..
Hi all, I have a db2 query in the cobol program. Because of this query the job is taking around 75cpu min to run. I need to reduce the cpu time to 35 cpu mins minimum. I am attaching the query in the post. Could anyone please suggest me a method to improve the performance. SELECT DISTINCT J.SLS_ORGN...
- Tue Jun 13, 2006 3:35 pm
- Forum: JCL
- Topic: Help required for a sort step.
- Replies: 5
- Views: 14445
Hi , Let me explain you in a more elaborate way: Let the table be having the following columns: Type Sub-Type Credit-Amt Debit-Amt Type Sub-Type Date-field Credit-Amt Debit-Amt Cereals Wheat 3/14/2001 15 17 Cereals Wheat 3/14/2001 24 22 Cereals Wheat 3/14/2001 2 4 Cereals Wheat 3/14/2001 3 3 Cereals...
- Tue Jun 06, 2006 2:16 pm
- Forum: JCL
- Topic: Help required for a sort step.
- Replies: 5
- Views: 14445
Help required for a sort step.
Hi , I have a small query regarding usage of SORT card utility. Situation: There say a table(A) with the following data Table A a1 a4 amts1 amts2 amts3 adate james 30 40 40 40 24-jan-2005 james 30 13 23 23 25-jan-2005 james 30 13 23 23 26-jan-2005 james 30 13 23 23 27-jan-2005 james 30 13 23 23 28-j...