Re: Comparing files in BPCS and SQL server

[Vince Rowe <vrowe@xxxxxxxxxxxxxxxx>]

Amitava,

How about accessing both systems via ODBC from a PC using Access or a
progamming language (Perl is terrific for this sort of thing) and comparing
the files that way?  The real issue is how the two systems store information
and in what fields.

Good luck!

Vince Rowe
Marietta Corp


On Tuesday 02 April 2002 10:42 am, you wrote:
> Hi
> Another dept. in my company has a system running on SQL server. I work in
> BPCS 6.0.04 and don't know anything about SQL server. Now, I have to
> compare some files across these two systems (for example, an Invoice file
> in that other system with RCM in BPCS to see whether all the customer no.s
> in that other file are in RCM or not). My first thought was to import that
> file in AS/400 (somehow) and then compare. But I am told not to duplicate
> any file ( that means I can not copy [import or export] any file from one
> system to another). Is there any other way to do it? TIA
> Amitava
>
>
> _______________________________________________
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l
> or email: BPCS-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.