MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 8 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Sort comma dlmtd fl & only last record per key in O/P
umj

Replies: 2
Views: 2318

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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 ...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group