x002548's Blog

Not Just a Number - Brett Kaiser
posts - 89, comments - 586, trackbacks - 39

August 2006 Blog Posts

How do I track data changes in a database

This question comes up quit often.  For example in this thread from dbForums SQL Server forum they are looking to do just that. The simplest answer is to create a history for every table, then create a trigger for each that will move the entire row of the before image information into history when a DELETE or UPDATE Modification occurs.  You could type all of this out manually if you'd like.  But I hate typing.  So the code below will generate all of the tables and the triggers for you.  Now I just have to write one of these things for DB2. USE...

posted @ Thursday, August 10, 2006 1:59 PM | Feedback (4) | Filed Under [ SQL Server Code Generataion ]

How to FTP Files to OS/390

The best way I've found to transfer is to use ftp with a script file.  Now with Cyberfusion being implemented, I unfortunately have to abandon this simple methd for secure file transfers.  The thing that really gets me though, is this company policy being enforced, evenb though everything is interbal and behind a firewall.  And Cyberfusion iis a pain in the neck to setup...and it seems the "Service" company doesn't have a good handle on it...and they have to set up the profiles.  In any case, create a script file like: open <machine name> <UserID><Password>quote site filetype=seq  CYlinders Primary=50 Secondary=100 lrecl=5000 recfm=FBput...

posted @ Tuesday, August 01, 2006 11:20 AM | Feedback (0) | Filed Under [ DB2 ]

Powered by:
Powered By Subtext Powered By ASP.NET