Re: Powerbuilder and Oracle

>In article <1994Aug12.124540.24137_at_tron.bwi.wec.com> Judy Bruns writes:
>Does anyone know an efficient (performance and maintenance)
>way of transfering data from Oracle into Watcom through
>Powerbuilder. The tables are named the same and look the same.
>Many have over 100,000 rows.

Judy;

A similar question was asked in another newsgroup I monitor, comp.soft-sys.powerbuilder. Following are a couple of suggestions/responses that I saved.

Response 1

-Reply-To: rkm_at_vectorbd.com
-Author: rkm_at_vectorbd.com
-
-   Well, the *easiest* way is to get a copy of Microsoft ACCESS, and do an
-append QUERY.  ( Really!  That's what we do here. :-)
-
-   The second easiest way is to write a small PB app that opens two SQLCA
-objects - one for Oracle, and one for WATCOM.  Then just append through
-them.

Response 2

-Reply-To: talleym_at_ns1.unicomp.net
-Author: Micheal D. Talley 
-Export it out of Oracle into flat ASCII.  Then import it into Watcom using
-the same script methodology Watcom provides you when it creates the
-demo tables.

Hope this helps & good luck.

Jonathan

>All I've come up with is in a loop, fetch from oracle into
>local variables & insert into watcom, repeat till done!
>YUCH!! maintenace is terrible and so is performance!
>
>Thanks,
>Judy BRuns
>bruns_at_vaxec0.bwi.wec.com>
Received on Fri Aug 19 1994 - 18:11:46 CEST