Author |
Message |
Topic: Sort comma dlmtd fl & only last record per key in O/P |
umj
Replies: 2
Views: 2318
|
Forum: Utilities Posted: Mon Oct 05, 2009 11:30 am Subject: Sort comma dlmtd fl & only last record per key in O/P |
Thanks a lot Kolusu. It worked ! |
Topic: Sort comma dlmtd fl & only last record per key in O/P |
umj
Replies: 2
Views: 2318
|
Forum: Utilities Posted: Mon Oct 05, 2009 10:18 am Subject: Sort comma dlmtd fl & only last record per key in O/P |
Hi, I have a comma delimited file. The layout of the file is:
(The key columns have an asterisk)
*TACTIC EVNT ID CHAR 20 X(20)
*TACTIC EVNT ID TYP CD Numeric 5
*TACTIC EVNT SRVC ID Nume ... |
Topic: FOCUS - Line Continuation character |
umj
Replies: 3
Views: 2156
|
Forum: Application Programming Posted: Tue Jan 27, 2009 1:02 pm Subject: FOCUS - Line Continuation character |
Thanks Kolusu |
Topic: FOCUS - Line Continuation character |
umj
Replies: 3
Views: 2156
|
Forum: Application Programming Posted: Fri Jan 23, 2009 3:30 pm Subject: FOCUS - Line Continuation character |
Hello
For Report generation, the focus member contains:
OFFLINE
EX RUNFOCEX PROD = '(62,63,64,65,66,67,68,69,70,71,72,73,74,135,13 ... |
Topic: DB2 v9 access path stability through REBIND |
umj
Replies: 0
Views: 1733
|
Forum: Database Posted: Wed Dec 03, 2008 8:35 pm Subject: DB2 v9 access path stability through REBIND |
Hi,
I have got a notification from my Db2 support team in my organization that we are converting from DB2 BIND to REBIND to take advantage of the access path stability.
In nutshell:
DB2 acce ... |
Topic: Alternative to Cascase delete |
umj
Replies: 6
Views: 2405
|
Forum: Database Posted: Thu Nov 27, 2008 10:15 am Subject: Alternative to Cascase delete |
thansk jsharon1248
I think I'll be working on the Reorg with Discard option.
Thanks once again |
Topic: Alternative to Cascase delete |
umj
Replies: 6
Views: 2405
|
Forum: Database Posted: Tue Nov 25, 2008 4:57 pm Subject: Alternative to Cascase delete |
hi Kolusu
This is whaat is currently done.
but since the child tables hold huge data for each entry in parent table it is becoming a problem.
Is there a way by which we can specify the # of r ... |
Topic: Alternative to Cascase delete |
umj
Replies: 6
Views: 2405
|
Forum: Database Posted: Tue Nov 25, 2008 1:52 pm Subject: Alternative to Cascase delete |
In my application, a cascade delete is done. There is a commit after each delete. However, this delete causes over 10,000,000 records to be deleted from the child tables. The DBA team is having an i ... |
|