Hi Matteo, Matteo Gattoni [mailto:[EMAIL PROTECTED] wrote: > > I'm trying to extract data from a database using loadercli. > If I do it in RECORDS format, I have the following > > loadercli>TABLEEXTRACT USER DATA OUTSTREAM FILE > '/ict/app/sdbN/PsfData1' RECORDS > -25010 > SQL error -2003 = Output columns too long (error position: 48) > OK > > If I do it in PAGES format, the following > > loadercli>TABLELOAD USER DATA INSTREAM FILE > '/ict/app/sdbN/PsfData1' PAGES > -25801 > Internal error [vls28_TLoad.cpp, 1566, -25329]; contact > technical support > OK > > What's the problem? > It seems to have problem with column too long, like ones > containing two varchar(4000) fields. > Sorry for the delay. We have to check this. It seems really to be the problem with the tables created in SQLMODE ORACLE.
> I use the option -E 0 for the loadercli, but it seems not to > work well. This option would tell that loadercli doesn't stop > even if there's errors, don't it? > Yeah, but be careful :-) This -E option controls the processing of commands of the batch file, meaning: if you have several commands in your file and one of them fails LOADERCLI sends the subsequent commands to the Loader Server anyway. This option does not control the processing of the command itself. So if your batch file has 2 commands, say USE USER <user name> <pw> SERVERDB <db name> // TABLEEXTRACT USER DATA OUTSTREAM FILE ... and the latter fails the loadercli of course stops as it would anyway as this is the last command. If there were another command it would send this to the Loader Server. LOADERCLI is simply a very simple client that doesn't do anything else than send commands to the Loader Server and handle the answers of the server. Regards, Steffen -- Steffen Schildberg MaxDB Team SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
