> -----Original Message-----
> From: Rüdiger Mähl [mailto:[EMAIL PROTECTED]]
> Sent: Donnerstag, 20. Dezember 2001 07:59
> To: sapdb-general
> Subject: Re: Alternatives to repmcli for data import from another
> database
>
>
> Tim Nelson <[EMAIL PROTECTED]> schrieb am 20.12.01:
> > I am desperately trying to import a very large database
> > that was built on Informix. I have the data in pipe-delimited
> > records and I am struggling to get "repmcli" working. I
> > have found problems with NULL handling (some NULL fields is handles
> > just fine, others I get -4 : protocol errors). I also have
> > been able to lock up "repmcli" on other occassions. I have
> configured
> > gobs of DATA and LOG space so I am sure I am not running into a
> > resource issue.
>
> AFAIK, you can define the delimiter on Informix side when doing
> the dbexport. Another delimiter might work better?
>
null_spec ::= NULL 'valLiteral'
valLiteral ::= [\'][^\']*[\'] would be possible using compressed format.
valLiteral ::= [\'][^\']+[\'] is necessary using the formatted format.
therefor: spend a single byte for NULL representation-its christmas time.
> > Is there an alternative to loading data using "repmcli" ???
>
> You obviously can use a script language like Perl or Python to
> do the job. This is mostly easier to accomplish (if you have the
> language knowledge) than a rather flat DATALOAD in an repmcli
> import. Easier in the sense of getting the data to your fingers
> and being able to make changes to format and contents. I tried
> to use the repmcli to move/copy data from one SAPDB to another,
> but now changed to a Python script with direct SAPDB access.
>
oh, its a good suggestion to use the python interface of the lserver.
you have the power of python and power/performance of the lserver to make
your extract/transform/load process run.
> > I have seen "xload" and "xdbload" but I can't find any documentation
> > on them.
>
> Roll your own!
>
> > Thanks.
> >
> > Tim Nelson
>
> Finally, YMMV.
>
> Rüdiger
>
> ______________________________________________________________
> ________________
> 100 MB gute Gründe. Jetzt im WEB.DE Club anmelden und Prämie sichern!
> Superstars, Topevents und Wunschrufnummer inklusive -
http://club.web.de
