RE: loadercli error when importing csv

Hi Zavier, Zavier Sheran [mailto:[EMAIL PROTECTED] wrote: > > I guess the following error message is inaccurate, as column > car_zip is set to DEFAULT NULL... > > Please correct me if I'm wrong. I don't know what the problem > could be... I had misleading error messages before in loadercli.

Re: Sort tree data Preorder

Hello Elke, Thank you very much, for your advice. It is working very nice for me. Dusan On Fri, 21 May 2004 09:13:10 +0200, Zabach, Elke <[EMAIL PROTECTED]> wrote: Dusan Kolesar wrote: Hello, This is more SQL problem then SAP DB problem but may bee somebody can help me. Or sombody knows links w

Re: loadercli error when importing csv

bonjour, Le lundi 24 mai 2004, Zavier Sheran a écrit... > I guess the following error message is inaccurate, as column car_zip is set to > DEFAULT NULL... > car_zip 6 DEFAULT NULL > Missing data for specified column CAR_ZIP. > Defined maximum number of errors (1) reached If car_zi

loadercli error when importing csv

I guess the following error message is inaccurate, as column car_zip is set to DEFAULT NULL... Please correct me if I'm wrong. I don't know what the problem could be... I had misleading error messages before in loadercli. User DBA connected to database GC on local host. DATALOAD TABLE DBA.ca

Re: Loading large SQL scripts w/o SQL Studio: how?

Matthias, Try: # sqlcli -d DBNAME -u SQLUSER,SQLPASS -i filename.sql -c If you want to terminate/separate your queries with say a semi-colon, you would enter something like -c ; Cheers, JLS Matthias Gärtner wrote: Dear list, we have large SQL batch files which we cannot load via SQL Studio (tun

RE: Loading large SQL scripts w/o SQL Studio: how?

Hi, You can use sqlcli for this task. It is available at: ftp://ftp.sap.com/pub/maxdb/tmp/maxdb-sqlcli-linux-i386-7_5_1_0a.tgz Use sqlcli -d -u , -i To separate the sql commands within the batchfile use the following format: Select 'homer' from dual // Select 'bart' from dual // ... You can a

Loade: default value that is not 'null' when importing?

I have to import a csv dataset and some fields that are indexed in the table are not in the csv data. Loader gives an error stating that those fields are required. is there a way to import the data and set for the index fields that are not available a default value? DATALOAD TABLE DBA.cars_u

Loading large SQL scripts w/o SQL Studio: how?

Dear list, we have large SQL batch files which we cannot load via SQL Studio (tunneled connection only, takes ages). We would like to transfer the data to the server (no GUI there, Linux), then use dbmcli or similar to load the SQL. Basically we would like to simulate Oracle's "sqlplus @mybigbatch

Problem starting database

-- -Problem starting database on SuSE 9.1 --- I have this uname -a Linux sabio 2.6.4-52-smp #1 SMP Wed Apr 7 02:11:20 UTC 2004 i686 i686 i386 GNU/Linux set | grep LD LD_ASSUME_KERNEL=2.2.5 --- When i try to start the TST75 the result is /opt/sdb/programs/bin/dbmcli -d TST75 -u dbm,dbm db_start OK

Re: MaxDB startup error

This is the result set | grep LD_ LD_HWCAP_MASK=0x2000 What must to do? Schroeder, Alexander wrote: You may want to search through the list archive and look for the LD_ASSUME_KERNEL environment variable and its use. Regards Alexander Schröder SAP DB, SAP Labs Berlin -Original Messag

RE: MaxDB startup error

You may want to search through the list archive and look for the LD_ASSUME_KERNEL environment variable and its use. Regards Alexander Schröder SAP DB, SAP Labs Berlin > -Original Message- > From: MaxDB [mailto:[EMAIL PROTECTED] > Sent: Sunday, May 23, 2004 4:48 PM > To: maxdb > Subject

MaxDB startup error

why this error on Suse Prof 9.1 when i try to start TST75 database ERR -24994,ERR_RTE: runtime environment error 1,Check knldiag! Kernel died before reaching ADMIN state How can i solve it? -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://li

RE: cpc problem: why "sqlprc" function doesn't work on solaris(64 bit) ?

> -Original Message- > From: lu peng [mailto:[EMAIL PROTECTED] > Sent: Saturday, May 22, 2004 6:18 PM [...] > I migrated an oracle application to maxdb7.5.0.11 for > solaris(64bit) and > compiled under ORACLE MODE. > > i got a "bus error" when using "sqlprc()" to extract > precision a

tableload stops loading

Hi, it sounds so easy For two weeks, I try to transfer data from one database-server (Version 7.4.3.10) to another (Version 7.4.3.10 too). Whatever I try, TABLOLOAD stops loading during execution, it loads just the half of my database. This is what I did: 1. Step: Export Data (repmlci)