Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
DATAFIX tool

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
jzhardy

New User


Joined: 31 Oct 2006
Posts: 31
Location: brisbane

PostPosted: Wed Aug 09, 2017 9:13 am    Post subject: DATAFIX tool
Reply with quote

hi,

in our shop we implement datafixes in production via hand crafted sql which is run via spufi/dsntiaul. Typically consists of pre-update fetch; update/delete followed up post-update fetch. One job for rollback; one for commit.

the process is cumbersome, tedious and error prone.

does anyone know of a tool or product extention that allows for the building of dml using templates. In my ideal environment all i want to do is identify (by technical ids) rows of tables that need to be updated/deleted. I want this tool to be smart enough to created formatted sql following a set of standard templates, and fill in any RI dependants based on catalog info. The hard part of the process should be the identicication of what needs to change and how it needs to change. This requires detailed business knowledge. But there is no reason why the rest of it can't be automated.

I can do something like this with JCL/REXX but I don't want to reinvent the wheel. Besides, there's a bit of work involved. not looking for a solution, just some pointers or suggestions for things I should be looking at.
Back to top
View user's profile Send private message

View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Mainframe scheduling tool ddhar Compuware & Other Tools 2 Wed Sep 27, 2017 12:48 am
No new posts File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 2 Tue Sep 26, 2017 3:35 am
No new posts Need info on EIBCPOSN value in IBM FA... subratarec CICS 11 Wed Jul 12, 2017 3:45 pm
No new posts Interface from Mainframe to Confluenc... hblun CLIST & REXX 4 Tue Sep 20, 2016 5:47 pm
This topic is locked: you cannot edit posts or make replies. Software analytics tool Peter Dawson COBOL Programming 2 Fri May 13, 2016 4:30 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us