Re: Test data laziness :)

[Vernon Hamberg <hambergv@xxxxxxxxxxxxxx>]

Tim

At 10:45 PM 6/8/1998 -0400, you wrote:
>Hello and Happy "belated" D-Day....lest we ever forget.
>---------
>Here's my question, and feel free to call me a lazy b*st*rd....
>I am working on a LARGE program that produces a large critical report.
>Now this program uses about 30 files, 22 of which are logicals that are
>built over various and sundry physical files.  6 of the files are major
>join files that bring together the data of multiple physical files
>around the production system.  Now, I work on a developement machine
>(hardly any security) that is seperate from the production environment
>(super secured environment) (passthru is the way we can access the
>different systems) this developement machine has bits and pieces of the
>actual types of data that reside on the production machine... but of
>course the data would have to be recreated on the developement machine
>for me to be able to test the program properly.  Is my only alternative
>to just slug it out and collect all these physical file pieces and parts
>and then SNDNETF them to the developement machine into my test library
>and then recreate the logicals that will connect the physical file
>pieces and parts as well as the join files?  Any other suggestions?
>I guess..... I should just sit down for a week and write a program that
>will automatically produce any type of needed data samplings.... Is this
>what you nice people are  gonna suggest?

Let me suggest DRDA. You can then run SQL statements that execute on the
remote box but outputon the local one. I.e., you can create outfiles on
your dev box from files onthe prod box, in realtime. You use WRKRDBDIRE to
set things up, and then it just works. Use where clauses to subset the data
as required.


HTH

Vernon Hamberg
Systems Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN  55401-2499
(612) 371-1111 x480


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---