LOADERCLI > COMPRESSED FORMAT > BREAK LINE inside cells to be extracted and loaded (UNICODE DATABASE)

[Patrick Beunaiche]

Hello,

I am encountering an issue when I want to download the data of  a cell that
contains break lines into a COMPRESSED stream and then reload these data
into another database. There is a conflict with the LINE BREAK that delimit
each record in the datastream.
I cannot use the FORMATTED format because of some external applications
constraints.
Is there a special function that could transform \r into a special string
during the DATAEXTRACT of LOADERCLI ?  This special string would be well
interpreted by the DATALOAD of LOADERCLI, then.
As there are DELIMITER, NULL, SEPARATOR parameters that modify the standard
behaviour of LOADERCLI, is there something which could specify one or more
transformations as a characters filter would do ?

Thanks in advance for your help !



Appendice :
Extracting from a MAXDB database

SET CODETYPE UCS2
//
DATAEXTRACT *  from  priority
    OUTFIELDS
    idappli 1
    odprio 2
    typrio 3
    idcountry 4
    noprio 5
    dtprio 6
    rmprio 7
    stprio 8
    OUTSTREAM 'priority.data' COMPRESSED
    NULL '#'
    DELIMITER ''
    SEPARATOR '|'
    DATE 'YYYY-MM-DD'
    TIMESTAMP 'YYYY-MM-DD HH:MM:SS.NNNNNN'

Loading into another MAXDB database

SET CODETYPE UCS2
//
DATALOAD TABLE  priority
    idappli 1  DEFAULT NULL
    odprio 2  DEFAULT NULL
    typrio 3  DEFAULT NULL
    idcountry 4  DEFAULT NULL
    noprio 5  DEFAULT NULL
    dtprio 6  DEFAULT NULL
    rmprio 7  DEFAULT NULL
    stprio 8  DEFAULT NULL
    INSTREAM 'priority.data' COMPRESSED
    NULL '#'
    DELIMITER ''
    SEPARATOR '|'
    DATE 'YYYY-MM-DD'
    TIMESTAMP 'YYYY-MM-DD HH:MM:SS.NNNNNN'


_____



_________________________

Patrick Beunaîche
JOUVE
1, rue du docteur Sauvé
53100 MAYENNE
Tel : +33.2.43.08.26.33
Fax : +33.2.43.08.25.10

The present email and all information included therein do not constitute a
legal agreement accorded by Jouve.
All legal agreements must be formulated in writing on paper by a legal
representative of JOUVE.
If you have received this email by mistake, please inform us of that fact
and destroy the email and any documents it might contain. Thank you for your
cooperation.


Le présent mail ainsi que toutes les informations qu'il contient ne peuvent
en aucun cas être considérés comme un engagement juridique de quelque nature
que ce soit de JOUVE. Tout accord devra être formulé par écrit papier
ultérieur signé par un représentant légal de JOUVE.  Par ailleurs, si vous
recevez ce mail par erreur, merci de nous le signaler et de le détruire
ainsi que l'intégralité du document qui pourrait y être joint.