IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DATAFIX tool


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
jzhardy

Active User


Joined: 31 Oct 2006
Posts: 131
Location: brisbane

PostPosted: Wed Aug 09, 2017 9:13 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Error while running web tool kit REXX... CLIST & REXX 5
No new posts Mass JCL release via IDZ tool(eclipse... CA Products 1
No new posts SXP Tool for PL1 or Module library ma... PL/I & Assembler 0
No new posts REXX/CLIST tool for BCSR and EDSR CLIST & REXX 2
No new posts REXX tool to extract all files starti... CLIST & REXX 4
Search our Forums:

Back to Top