loadercli Problems with null values

Hello, I have a problem with null values. I would like to load data from .csv files with null values. For example the signature: "20001","100","haus","GG","20","null","5","7","203450670100","45","2" I would like to with the following command>: DATALOAD TABLE "TABLE2" INSTREAM FILE 'daten.tx

loadercli Problems with null values

Hello, I have a problem with null values. I would like to load data from .csv files with null values. For example the signature: "20001","100","haus","GG","20","null","5","7","203450670100","45","2" I would like to with the following command>: DATALOAD TABLE "TABLE2" INSTREAM FILE 'daten.tx

RE: Delete Takes a very long time

Under the Information - Locks in the database manager I see row Locks 312776 Table Locks 6487 These seem kind of high for what I'm doing. How do I prevent these from occurring? Thanks, Mark -Original Message- From: Becker, Holger [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 20

How to solve "invalid numeric constant" in MaxDB

Hey, There has been a prior discussion on this exception but I could not find a solution to it in the discussion threads. I would appreciate any help on this. I have the following update statement: UPDATE SRM_CM_DA_CLOB SET CREATED_BY =?, DA_CLOB =?, UPDATED_BY

JDBC Delete causes block-freeze on native socketread0

I've been conducting some JDBC tests on the MaxDB JDBC Driver (com.sap.dbtech.jdbc.DriverSapDB). My primary test mechanism is the JUnit tests provided with Hibernate (www.hibernate.org). Hibernate supports the SapDB SQL dialect. My environment is: Win2K SP4 JDK 1.4.2 MaxDB 7.5.0.11 / JDBC dri

Win32 ODBC 7.5.0.12 driver - multithreaded deadlock, -807 error

Environment: Win32 dotNet 1.1, Windows 2000 Server Service Pack 4 with latest patches and latest MDAC. One server running MaxDB 7.5.0.8, the other server running ASP.NET dotNet 1.1 as a ODBC client. connection pooling turned on (always check this after driver install or upgrade, it always

MaxDB/MySQL interoperability when?

Have the interoperation features between MaxDB and MySQL that allow using MySQL code with a MaxDB been implemented with 7.5.00.11 or earlier? I see on the MaxDB site that is expected "shortly after the first 7.5.00 version." -- MaxDB Discussion Mailing List For list archives: http://lists.mysql

RE: Problem with MAXDB Comment field

[EMAIL PROTECTED] wrote: > > Hallo ! > > My application uses the field comments of a table to decide > what to do. > Is the user allowed to leave the field empty, is he allowed to enter > data, do i need a textbox or a combobox in my forms .. > > > Is there a way to pass value to the fiel

RE: Problem with MAXDB Comment field

Perhaps you have missed the COMMENT ON statement, as described at http://dev.mysql.com/doc/maxdb/en/6d/117c53d14811d2a97400a0c9449261/content.htm Anyway, creating the table, and specifying the individual comments are separate SQL statements. Regards Alexander Schröder SAP DB, SAP Labs Berlin

Problem with MAXDB Comment field

Hallo ! My application uses the field comments of a table to decide what to do. Is the user allowed to leave the field empty, is he allowed to enter data, do i need a textbox or a combobox in my forms .. Is there a way to pass value to the field comment of a table when creating a table via

maxdb odbc driver winnt

Hi, I've tried to install and use the maxdb odbc-driver on a windows nt4 workstation. Installation is no problem but when using the driver I get a message "odbc-call failed" -> no connection can be made !!! When using the driver included in SQLSTUDIO (SQLSTUDIOODBC) there is no such problem.

Re: MaxDB and Perl - ODBC

Hello, Tip: it makes it easier for others to help if you provide more information like received error messages, what steps you have already tried and so on. I am only guessing at what OS you are using, but suppose it is Linux and suppose you are using unixODBC: Your odbc files seem OK, this is h

Database access control strategy

Hi. I was just wondering what's the best (most convenient) strategy to deploy n number of databases with SAPDB where n is let's say between 5-40 (one database per user). Typically dba and dbm for all the databases are the same person here. One approach would be to create n number of instances wi

RE: Delete Takes a very long time

mailto:[EMAIL PROTECTED] wrote: > I have my app almost complete on MaxDB. I have just run > into a major snag > and would appreciate any help you can offer. > > I have a table "Files" that has about 400,000 rows > > If I run queries like > 1) SELECT * FROM FILES WHERE FILE_NAME = "THISFILE

MaxDB and Perl - ODBC

Hello, i am new to this Mailinglist. I have following problem by trying to connect with Perl on a MaxDB. I want to use ODBC to do it. My settings in are: odbc.ini [MaxDB] Description = MaxDB Driver = MaxDB Host= localhost Database= TESTDB Tracefil