Search found 5 matches

by shanthic2003
Sun Feb 24, 2013 10:36 pm
Forum: PL/I
Topic: Tool for fnding PL/1 dead code
Replies: 0
Views: 4161

Tool for fnding PL/1 dead code

Hi,

Is there any tool available to find out dead code in PL/1 sources?
I am in need of this for my reverse engineering.

Can someone help me...Thanks!
by shanthic2003
Wed Sep 26, 2012 6:08 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: reorg and runstat
Replies: 1
Views: 3624

reorg and runstat

Hi,

I would like to know how often a runstat and reorg happens for a particular table. Is there any SYSIBM.*** table where this logs or info is maintained?

I am an app developer with no DB2 admin authorization.

Can someone please help me with an answer?

Thanks in Advance!
by shanthic2003
Mon Sep 10, 2012 6:34 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: how to calculate age
Replies: 4
Views: 9503

Subtract 18 from YYYY. If new complete value is less than or equal to Brithdate, then the person is 18. It works because the date fields are in that order. Mess them around and it won't work in one shot. Hi William , Thank you for the reply. Subtracting the year works in most cases but it does not ...
by shanthic2003
Mon Sep 10, 2012 4:53 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: how to calculate age
Replies: 4
Views: 9503

how to calculate age

Hi,

I have a DB2 table where in birth date is stored as birthdate char-08 in 'YYYYMMDD' format.

Now I have to calculate if he has completed 18 years.

How can I achive this?

Many thanks for yyour reply.

edited by dbz to remove 'cool'
by shanthic2003
Sat Sep 08, 2012 12:39 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Accessing history tables
Replies: 1
Views: 3034

Accessing history tables

Hi...Could someone help me with identifying the solution with optimum performance to my problem. I have a db2 table with 20 million records and the history table has more than 30 million records. Active and history are two different tables i.e.., they are not partitioned. Now my requirement is that ...