Hi Steffen, All, Following my recent post regarding using repmcli to extract and then load our data, I have found what appears to be a bug. I use repmcli to export the data, and then import it back again.
Everything works great, except if one of the fields contains a VARCHAR that contains a newline character (we receive the data entered through a website, and store it in the database). In this case, it will not import the row, saying one of the following fields is invalid. Is this a known bug? Is there a workaround? Shouldn't repmcli be able to handle this case? A reply at your earliest would be appreciated as this is quite urgent. I am posting the relevant files below. Many thanks! David command line: repmcli.exe" -d %dbName% -u %sysdba%,%sysdba_password% -E 0 -b .\database\loadData.cmd loadData.cmd: SET MAXERRORCOUNT 200 // DATALOAD TABLE "FORMS" "ID" 1 CHAR "TITLE" 2 CHAR DEFAULT NULL "NUMBER" 3 CHAR "REVISION_DATE" 4 CHAR DEFAULT NULL "REVISION_NUMBER" 5 CHAR DEFAULT NULL "SUBMISSION_DATE" 6 CHAR DEFAULT NULL "SUMMARY" 7 CHAR DEFAULT NULL "KEYWORDS" 8 CHAR "PAGES" 9 CHAR DEFAULT NULL "ORIENTATION" 10 CHAR DEFAULT NULL "RESOLUTION" 11 CHAR DEFAULT NULL "COLOR_MODEL" 12 CHAR DEFAULT NULL "ECONOMODE" 13 CHAR DEFAULT NULL "DUPLEX" 14 CHAR DEFAULT NULL "PAPER_SIZE" 15 CHAR DEFAULT NULL "PAPER_SOURCE" 16 CHAR DEFAULT NULL "MAX_COPIES" 17 CHAR DEFAULT NULL "COLLATE" 18 CHAR DEFAULT NULL "FINISHING" 19 CHAR DEFAULT NULL "CYCLONEFORMSETNAME" 20 CHAR DEFAULT NULL "ISFORMSET" 21 CHAR DEFAULT NULL "PRINTSCRIPT_ID" 22 CHAR "AUTOFILLSCRIPT_ID" 23 CHAR DEFAULT NULL "AVAILABLE" 24 CHAR DEFAULT NULL "EXPIRATIONDATETIME" 25 CHAR DEFAULT NULL INFILE '.\database\forms.data' COMPRESSED ASCII DECIMAL '/ /./' DATE INTERNAL TIME INTERNAL TIMESTAMP INTERNAL NULL '? ' BOOLEAN 'TRUE/FALSE' // forms.data: "1","c910","","20030530135301890000","0","20030530135301890000","?","","2","null","300","CMYK","Off","Off","Printer Default","Printer Default","10","On","None","ki11054320794128","FALSE","1","? ","TRUE","?" "2","10 pdf","","20030530135544804000","0","20030530135544804000","a summarywith new lines!!! and some more!! dd","","2","null","300","CMYK","Off","Off","Printer Default","Printer Default","10","On","None","ki21054320948219","FALSE","1","? ","TRUE","?" _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
