Re: A few question if you have time.

["Lantinga, Amy" <Amy.Lantinga@MARRIOTT.COM>]

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.
**************************************************