I resolved the problem using TABLEEXTRACT USER DATA OUTSTREAM FILE '/ict/app/sdbN/PsfData1' RECORDS.
The option -E in loadercli seems not to work. The only way to not escape when error comes is to use SET MAXERRORCOUNT n, where n is a number like 999999. Obviously, if n+1 errors happened, the system would stop the process. Bye, Matteo ----- Original Message ----- From: "Schildberg, Steffen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 10, 2004 5:10 PM Subject: AW: TABLEEXTRACT column too long > 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] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
