Re: A few question if you have time.

[Alan Ljungberg <Alan.Ljungberg@CNPL.ENBRIDGE.COM>]

Arun,
We need to validate as completely as possible that the data matches the
source exclusive of formatiing(at this point).
If this was Oracle to Oracle this would be a wiz.  The two systems are on
different versions of PSTools as well 8.13 and 7.06 so datamover is out.
It also appears run times are going to be a major issue so it looks like we
will pursue a less SQR intensive solution.  Likely unload using MVS-JCL to
FF then load to Oracle using SQLoader, but we are evaluating still.

This has expanded beyond the scope of my original questions.  It was not my
intent to come on here and have you guys solve all my issues, and do my
work for me, but I thank you all for your effort.

-Alan




                    Arun Kumar
                    <arunkumar13@Y        To:     SQR-USERS@list.iex.net
                    AHOO.COM>             cc:
                    Sent by:              Subject:     Re: A few question if 
you have time.
                    "Discussion of
                    SQR, Brio
                    Software's
                    database
                    reporting
                    language"
                    <SQR-USERS@lis
                    t.iex.net>


                    02/06/2002
                    06:57 AM
                    Please respond
                    to sqr-users






Alan,
What kind of validation you are looking for?
If you are just changing your database platform then
why do you have to validate?
I mean if you carefully look a sample of data would be
enough to make sure that program is doing fine.


Arun
--- "Lantinga, Amy" <Amy.Lantinga@MARRIOTT.COM> wrote:
> I didn't think Data Mover Scripts Validate.  How
> about Import Manager?  That
> validates all the On Line Edits.
>
> Amy Lantinga
> Project Mercury
> (678) 657-5614
>
>
> -----Original Message-----
> From: Banks, Richard
> [mailto:Richard.Banks@CBA.COM.AU]
> Sent: Tuesday, February 05, 2002 5:25 PM
> To: SQR-USERS@list.iex.net
> Subject: Re: A few question if you have time.
>
>
> Since you are talking PeopleSoft what about using
> Data Mover Scripts (DMS)
> not just to import/export your data but to also
> validate it?
>
> Once you have the data in both databases you could
> run the same export DMS
> against both and compare the filesize/checksums on
> the 2 data files.
>
> This assumes that DMS saves the data in the same
> file format regardless of
> the source DB, which seems a reasonable assumption.
>
> Drawback would be if there is anything different
> between the two versions
> the DAT file is not a text format for easy
> comparison.
>
> But hey we're talking PeopleSoft, Oracle and IBM
> here, what could go wrong?!
>
> > -----Original Message-----
> > From: Alan Ljungberg
> [SMTP:Alan.Ljungberg@CNPL.ENBRIDGE.COM]
> > Sent: Wednesday, 6 February 2002 7:50
> > To:   SQR-USERS@list.iex.net
> > Subject:      Re: A few question if you have time.
> >
> > Hello Sam,
> > Much appreciate the time spent in helping me here.
> > The issue isn't with the loading of date fields
> into Oracle.  The problem
> > is in validating Oracle date outputs against DB2
> date output, without
> > using
> > custom date variables.  What I would like to do
> after the Oracle db is
> > loaded is use the same SQR to output the Oracle
> tables to flat files then
> > compare the DB2 flat files to the Oracle ones.
> >
> > And yes there is a lot to sort through.  We are
> talking some 1374 total
> > columns 140 of which are date columns in various
> positions, all different.
> >
> > Since Oracle seems to be friendlier to this kid of
> manipulation with the
> > ALTER SESSION command I think we will leave the
> DB2 scripts as is and add
> > the add this SQL command to the Oracle versions to
> make the output formats
> > match.  That is unless someone has a better
> suggestion.
> >
> > -Alan.
> >
>
>
> **************   IMPORTANT MESSAGE  **************
> This e-mail message is intended only for the
> addressee(s) and contains
> information which may be confidential. If you are
> not the intended recipient
> please advise the sender by return email, do not use
> or disclose the
> contents, and delete the message and any attachments
> from your system.
> Unless specifically indicated, this email does not
> constitute formal advice
> or commitment by the sender or the Commonwealth Bank
> of Australia (ABN 48
> 123 123 124) or its subsidiaries.
> **************************************************


__________________________________________________
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com