 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 8 matches |
| Author | Message |
|---|---|
 Topic: DB2 Trigger - Error Handling |
|
| gopurs Replies: 2 Views: 3780 |
 Forum: Database Posted: Fri Feb 02, 2018 10:05 am Subject: DB2 Trigger - Error Handling |
| Can I do error handling in DB2 Trigger. I haven't seen much information online or in the redbook regarding error handling in DB2 Triggers. DB2 normally returns -723 error when the triggered statement ... | |
| Topic: DFSORT help ?? |
|
| gopurs Replies: 3 Views: 1701 |
Forum: Utilities Posted: Mon Oct 26, 2009 9:04 pm Subject: DFSORT help ?? |
| Example 1
Input 95001 92001 ABC 2007-01-01 ? 95001 92001 DEF 2007-01-01 2008-10-01 95001 92001 DEF 2008-10-01 2009-10-01 95001 92001 DEF 2009-10-01 ? ... |
|
| Topic: DFSORT help ?? |
|
| gopurs Replies: 3 Views: 1701 |
Forum: Utilities Posted: Mon Oct 26, 2009 5:53 pm Subject: DFSORT help ?? |
| I have an input with the below data and i want the output to be as below
95001 92001 ABC 2007-01-01 -- ? 95001 92001 DEF 2007-01-01 2008-10-01 95001 92001 DEF 2008-10-01 2009-10-01 95001 ... |
|
| Topic: Joining Records |
|
| gopurs Replies: 9 Views: 4860 |
Forum: Utilities Posted: Thu Jul 02, 2009 6:27 am Subject: Joining Records |
| We have DFSORT also. It is possible to invoke ICETOOL of DFSORT rather than SYNCSORT by providing any specific loadlib or so. I think when I invoke ICETOOL it automaticaly invokes ICETOOL of SYNSORT. ... | |
| Topic: Joining Records |
|
| gopurs Replies: 9 Views: 4860 |
Forum: Utilities Posted: Wed Jul 01, 2009 9:40 pm Subject: Joining Records |
| Thanks Kolusu for your fast response.
I tried your code but it failed as below SYNCSORT FOR Z/OS 1.3.1.1RI CTL1CNTL : INREC ... |
|
| Topic: Joining Records |
|
| gopurs Replies: 9 Views: 4860 |
Forum: Utilities Posted: Wed Jul 01, 2009 6:56 pm Subject: re |
| Your understanding is correct in matching the records. Only one thing is that I am not writing the entire 80 bytes even though both the files are having LRECL 80. The actual data will be available in ... | |
| Topic: Joining Records |
|
| gopurs Replies: 9 Views: 4860 |
Forum: Utilities Posted: Wed Jul 01, 2009 6:59 am Subject: Joining Records |
| Thanks for your reply. Please find the answers for your questions
1. What is the LRECL and RECFM of both input files and output files? Both having LRECL 80 and RECFM = FB 2. What is the po ... |
|
| Topic: Joining Records |
|
| gopurs Replies: 9 Views: 4860 |
Forum: Utilities Posted: Tue Jun 30, 2009 7:41 pm Subject: Joining Records |
| I would like to join two files and write the output from both the files if they are matched, if it is only in File A then write the record from file A, if it is only in File B then write from File B
... |
|
All times are GMT - 5 Hours |