Search found 11 matches

by ambilileela
Tue Oct 24, 2006 11:23 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: current date,time
Replies: 2
Views: 7572

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 ---------+---------+--...
by ambilileela
Tue Oct 24, 2006 11:17 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: date -updation
Replies: 2
Views: 4611

HI

THE QUERY IS NOT COMPLETE DO YOU HAVE TO UPDTAE FOR ALL RECORDS OR FOR A SINGLE RECORD.

WHAT EVER BE THE CASE I GUESS YOU WILL HAVE TO INCLUDE THE WHERE CONDITION LIKE AS BELOW

UPDATE TABLE_NAME
SET DATE = EXISTING_DATE+8 DAYS
WHERE <GIVE THE CONDITION HERE>

THANKS,
AMBILI
by ambilileela
Tue Oct 03, 2006 3:20 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Performance tuning..
Replies: 5
Views: 9346

Hi

Sorry for the late reply. The outer query alone takes much time. Could some one please provide any method to tune this query.

Thanks in advance
Ambili
by ambilileela
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: 27190

It is a VB file only. So, please let me know the code for a VB file.

Thanks,
Ambili
by ambilileela
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: 27190

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...
by ambilileela
Mon Aug 07, 2006 4:36 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: PERFORMANCE TUNING.
Replies: 0
Views: 3878

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...
by ambilileela
Tue Jul 04, 2006 5:30 pm
Forum: JCL
Topic: Help required for a sort step.
Replies: 5
Views: 9747

Hi,

Thnx for the reply and the solution. I havent tried that solution , but then I wanted to know where does this code takes care of having maximum of those (count-9) records date field?

Do let me know at the earliest and Oblige.

Thanks in advance.
Ambili
by ambilileela
Thu Jun 29, 2006 9:59 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Performance tuning..
Replies: 5
Views: 9346

Hi,

Both are having the same size only.

Thanks,
Ambili.
by ambilileela
Tue Jun 27, 2006 12:18 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Performance tuning..
Replies: 5
Views: 9346

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...
by ambilileela
Tue Jun 13, 2006 3:35 pm
Forum: JCL
Topic: Help required for a sort step.
Replies: 5
Views: 9747

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...
by ambilileela
Tue Jun 06, 2006 2:16 pm
Forum: JCL
Topic: Help required for a sort step.
Replies: 5
Views: 9747

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...