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!
Search found 5 matches
- Sun Feb 24, 2013 10:36 pm
- Forum: PL/I
- Topic: Tool for fnding PL/1 dead code
- Replies: 0
- Views: 4161
- 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!
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!
- 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 ...
- 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'
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'
- 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 ...