Hello Johan,
Johan Hallgren [mailto:[EMAIL PROTECTED] wrote:
> Betreff: Segmentation fault when importing data from a 7.4
> databaseinstance into a 7.6 instance using loadercli
>
[snipped description of failed import of 7.4 data into 7.6 instance]
>
> I have tried the same proc
Hello list,
I am attempting to export the data and catalog for a user in a 7.4.03.27
instance and import them into a 7.6.00.34 instance. The procedure I
follow is this, using the database tools on the server running the 7.6
instance for all operations:
1. I have ensured that the 7.6 instance has
rg, Steffen [mailto:[EMAIL PROTECTED]
> Gesendet: Donnerstag, 19. April 2007 18:43
> An: Chris Jölly
> Betreff: AW: Starting loadercli: could not connect to db
>
>
> Hi Chris,
>
> Chris Jölly [mailto:[EMAIL PROTECTED] wrote:
> > Gesendet: Donnerstag, 12. April 2007 1
gt; Betreff: RE: Starting loadercli: could not connect to db
>
>
> > Error connecting user DBM to database ADB on dev-srv: -25004
> > A connection to the database could not be established: 1 =
> > could not create comm. shared memory [5].
>
> I would say that you a
> Error connecting user DBM to database ADB on dev-srv: -25004
> A connection to the database could not be established: 1 =
> could not create comm. shared memory [5].
I would say that you are either running out of resources on that specific
system or that you MAXUSERTASK parameter is too low.
Hello!
i want to execute loadercli on a db server running windows 2003
and get the following error:
D:\MaxDB\sdb\programs\bin>loadercli -u dbm,dbm -n dev-srv -d adb
Loader Server Protocol: 'C:\Documents and Settings\adm\Application
Data\sdb\loader\log\loader.prt'
Error connec
p the script. I would like that it does not stop for this
> none fatal error and continue with next commands but stopping on next
> fatal error.
> Does somebody see a possibility to do it in a same script ?
>
There is no solution to your problem working with loadercli. It doe
TED] wrote:
Hello,
"SET MAXERRORCOUNT xx" seems to have no effect in loadercli
input file
(Used Maxdb version : 7.5)
Could somebody tell me if this is a known bug or if I
incorrectly use an option ?
Here is the sample script that I call with loadercli (without
the option
-E)
Hi Joel,
Joël Reungoat [mailto:[EMAIL PROTECTED] wrote:
>
> Hello,
>
> "SET MAXERRORCOUNT xx" seems to have no effect in loadercli
> input file
> (Used Maxdb version : 7.5)
> Could somebody tell me if this is a known bug or if I
> incorrectly use an optio
Hello,
"SET MAXERRORCOUNT xx" seems to have no effect in loadercli input file
(Used Maxdb version : 7.5)
Could somebody tell me if this is a known bug or if I incorrectly use an
option ?
Here is the sample script that I call with loadercli (without the option
-E) :
//Folowing comm
EMAIL PROTECTED]
Sent: Dienstag, 12. September 2006 12:47
To: maxdb@lists.mysql.com
Subject: Error with Loadercli: SQL error -1105 (too complicated SQL
statement)
I am trying to load the table REGUP from R/3 4.6 into maxdb 7.6.00.32
using
loadercli but receive the following error message:
Error during
Error with Loadercli: SQL error -1105 (too complicated SQL
statement)
I am trying to load the table REGUP from R/3 4.6 into maxdb 7.6.00.32
using
loadercli but receive the following error message:
Error during execution
-->-25010
SQL error -1105 = Too complicated SQL statement (too much data) (e
I am trying to load the table REGUP from R/3 4.6 into maxdb 7.6.00.32 using
loadercli but receive the following error message:
Error during execution
-->-25010
SQL error -1105 = Too complicated SQL statement (too much data) (error position:
1645)
Maxdb parameters:
_PACKET_SIZE 131
Hi Uli,
this error is corrected with version 7.6.00.24 which is not published
yet AFAIK.
I could offer to provide you with a loader of that version to get over
this
problem. Let me know if this is acceptable for you.
Regards,
Steffen
--
Steffen Schildberg
MaxDB Team
SAP Labs Berlin
--
MaxDB Di
Hello list,
I'm trying to load data with loadercli, my max-db version is 7.6.00.16
under SLES9.
I'm using the SEQNO-clause for the field "GE_ID", running loadercli leads to an
"Memory fault".
Omitting the SEQNO-clause, it works.
In the loader.prt file, I se
Note: The db user DBUSER1 is belongs to the user group TESTGROUP.
$ loadercli
Loader protocol: '/home/dba/.sdb/loader/log/loader.prt'
Loader packages: '/home/dba/sdb/loader/packages'
loadercli>set odbctrace on
OK
---
loadercli>use user DBUSER1 TEST1 serverdb DWDB
ERR -
i can't reproduce the error using the full qualified
connect parameters
loadercli -d -n -u
Please send me the odbctrace protocolfile
/home/dba/.sdb/loader/log/loader.log for establishing the
connection.
You get the odbctrace executing the following sequence of loader
com
Any progress on this ?
-Original Message-
From: Jey Razack [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 25, 2006 2:06 PM
To: maxdb@lists.mysql.com
Subject: RE: loadercli - can't logon
> can you please send me the os and kernel version ?
RHEL 2.6.9-34.ELsmp #1 SMP x86_6
> can you please send me the os and kernel version ?
RHEL 2.6.9-34.ELsmp #1 SMP x86_64 x86_64 x86_64 GNU/Linux
-Original Message-
From: Jey Razack [mailto:[EMAIL PROTECTED]
Sent: Donnerstag, 20. April 2006 19:34
To: [EMAIL PROTECTED]
Subject: loadercli - can't logon
$ load
can you please send me the os and kernel version ?
-Original Message-
From: Jey Razack [mailto:[EMAIL PROTECTED]
Sent: Donnerstag, 20. April 2006 19:34
To: maxdb@lists.mysql.com
Subject: loadercli - can't logon
$ loadercli -v
Version: 7.6.00.16
$ loadercli -d DB1 -u DB
$ loadercli -v
Version: 7.6.00.16
$ loadercli -d DB1 -u DBUSER1,*
Loader protocol: '/home/dba/.sdb/loader/log/loader.prt'
Loader packages: '/home/dba/sdb/loader/packages'
Error connecting user DBUSER1 to database DB1 on local host: -25005
User (DBUSER1) logon to databas
I already enabled the option TRACE_DEFAULT, but as I make to collect
databasetrace?
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hi,
can you please send me a databasetrace with an
activated TRACE_DEFAULT option to analyze the
kernel error.
regards
hans-georg
-Original Message-
From: Lucius Gallardo [mailto:[EMAIL PROTECTED]
Sent: Freitag, 24. März 2006 20:33
To: maxdb@lists.mysql.com
Subject: Error on loadercli
ng command:
loadercli>DBEXTRACT CATALOG OUTSTREAM FILE 'C:\ETC\CATALOGO.SQL' DATA
OUTSTREAM FILE 'C:\ETC\DADOS.SQL'
The last entrances in loader.prt, then I to execute the DBEXTRACT are:
// MSTART 2006032400154435
// *
USE USER "DBA" * SCHEMA DBA SERVE
Hi Rosa,
Rosa Lago [mailto:[EMAIL PROTECTED] wrote
> I have a problem with loadercli. After import catalog and data for
> the entire database using loadercli all columns that are of type
> serial(N) are reset to N when the import finish, so when I try to
> insert new rows for a
Dear all,
I have a problem with loadercli. After import catalog and data for
the entire database using loadercli all columns that are of type
serial(N) are reset to N when the import finish, so when I try to
insert new rows for a table whose primary key is of type SERIAL(N)
appears a duplicate
Hallo Rosa,
Rosa Lago [mailto:[EMAIL PROTECTED] wrote:
>
> Now the database has its tables and its data. I can modify the rows in
> any table without problems but IT DOES NOT ALLOW ME INSERT NEW ROWS.
> Every time I try to insert any row it returns a DUPLICATE KEY ERROR.
>
> Can somebody help me
I have a 7.6 database on windows and now I am trying to migrate to
linux. I have an OpenSuse 10.0 linux machine and I have installed
maxdb 7.6 on it without problems. But when I try to load the catalog
and data on my new database server I have several problems.
loadercli gives me problems with
Hi Eduard,
would it be possible for you to send the catalog file
'cativen-catalog.dat'?
This would be very helpful for analyzing your problem.
Sorry for all the inconveniences.
Regards,
Steffen
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:htt
OK, I probably should've attached it as plain text, so here goes:
loader.prt:
--
// MLoader7.6.00 Build 012-123-102-632
// *
// MModule: c:\program files\sdb\programs\bin\loadercli.exe
// *
// MLoaderinstance started at EMI for database DONNA
// *
// MStarting pro
Attn: Steffen Schildberg
Hi Steffen,
Thanks a lot for your reply, and sorry for taking so long to reply back (I
haven't received a reply notification by email), so:
I am attaching the loader.prt and also database parameters for source and
target databases, as you will see they are both 7.6.
I
Hi Eduard,
Eduard M [mailto:[EMAIL PROTECTED] wrote:
> I try to export/import a database schema with all tables and
> data using loadercli, with the following command:
> TABLELOAD USER
> CATALOG INSTREAM 'cativen-catalog.dat'
> DATA INSTREAM 'cativen
used. It would be nice if the loadercli could prepend the schema name
on runtime to this kind of statements.
Next problem I found: I tried to change (in Windows) the text of the
catalog script generated by the loadercli during the export, using
WordPad, changing the name of the schema in t
Hi,
I try to export/import a database schema with all tables and data using
loadercli, with the following command:
TABLELOAD USER
CATALOG INSTREAM 'cativen-catalog.dat'
DATA INSTREAM 'cativen-data.dat'
and every time import fails with the following e
Hi,
I try to export/import a database schema with all tables and data using
loadercli, with the following command:
TABLELOAD USER
CATALOG INSTREAM 'cativen-catalog.dat'
DATA INSTREAM 'cativen-data.dat'
and every time import fails with the following e
Hi Steffen,
I have tried the solution with DEFAULT NULL for the boolean columns
- and it works fine!
Thanks a lot for your help,
Thomas
>Hi Thomas,
>well, yes it is a bug in handling multiple boolean values if more than
>one of them are
>evaluated to a null condition.
>You can overcome this pr
Hi Thomas,
well, yes it is a bug in handling multiple boolean values if more than
one of them are
evaluated to a null condition.
You can overcome this problem by using the following syntax - I hope it
is
an applicable solution for you.
import table testtab
update duplicates
data instream file 'tes
Hi Thomas,
we can reproduce the error but have no solution yet (give us another
hour ;-) )
I'll post a solution asap.
Sorry for any inconvenience.
Regards,
Steffen
--
Steffen Schildberg
MaxDB Team
SAP Labs Berlin
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
Hi,
there seems to be a problem at importing multiple boolean columns.
Example table:
create table testtab (
id integer,
field1 boolean,
field2 boolean
)
Import command (using loadercli, 7.6):
import table testtab
update duplicates
data instream file 'test.dat&
Hi Ingo,
dbsupport [mailto:[EMAIL PROTECTED] wrote:
>
> after changing COLUMNCOMPRESSION=NO this happend while
> importing the data:
>
> Error during execution
> -->-25010
> SQL error 100 = Row not found (error position: 92)
>
> protocol:
>
> // *
> // MError at record 246 in infile for
February 06, 2006 3:52 PM
> To: dbsupport
> Subject: RE: loadercli 7.6 and 7.5
>
>
> Have a look at following item
> http://lists.mysql.com/maxdb/25954
>
>
> -Original Message-
> From: dbsupport [mailto:[EMAIL PROTECTED]
> Sent: Montag, 6. Februar 2006 15:44
&
hi,
good idea, but where to find this parameter on a 7.5.0.31 server ?
ingo
> -Original Message-
> From: Bumes, Hans-Georg [mailto:[EMAIL PROTECTED]
> Sent: Monday, February 06, 2006 3:52 PM
> To: dbsupport
> Subject: RE: loadercli 7.6 and 7.5
>
>
> Have
Hi,
i`ve got some problems moving a schema from a maxdb 7.5 to 7.6.
here ist my unloadfile "exp.cmd" :
TABLEEXTRACT
USER
CATALOG OUTSTREAM 'all.sql'
DATA OUTSTREAM 'all.'
the result of: loadercli -d foodb -u foo,foo -b "exp.cmd"
reports NO ERROR. eve
I have fixed the 25011 problem that I got when I tried to import data with
import from loadercli. It was due to a table in the database that has a
VARCHAR(4000) UNICODE column (the documentation says that this type of data
support a length <= 4000)
Now I get two different problems when I try
framework
open source, easy and powerful
http://www.martincordova.com
On 1/31/06, Rosa Lago <[EMAIL PROTECTED]> wrote:
> I still have problems using loadercli
>
> This time I try to export de data using expor like this
>
> ---
> loadercli>export db catalog outstream
I still have problems using loadercli
This time I try to export de data using expor like this
---
loadercli>export db catalog outstream file 'bd4.catalog' ddl data outstream
file
'bd4.data' records package outstream file 'bd4.package'
OK
-25010
SQL error -2003
databases and the default character set is UNICODE.
---
loadercli>dbload catalog instream file 'bd2.command'
OK
---
loadercli>dbload data instream file 'bd2.data'm
ERR -25281
Syntax error at position 37 (Unexpected identifier: m); check for typing
errors
---
loadercli>d
version 7.5. I then tried to do an export just
like I would do with version 7.5.
The commands I use are the following:
> loadercli -d TEST -u DBA,SYSDBA
> DBEXTRACT CATALOG OUTSTREAM FILE'C:\apps\xport\TEST.LOG' DATA
OUTSTREAM FILE'C:\apps\xport\TEST.DATA'
After loggi
always did with version 7.5. I then tried to do an export just like I
> would do with version 7.5.
>
> The commands I use are the following:
>
>> loadercli -d TEST -u DBA,SYSDBA
>
>> DBEXTRACT CATALOG OUTSTREAM FILE'C:\apps\xport\TEST.LOG' DATA
> OUTST
version 7.5. I then tried to do an export just
like I would do with version 7.5.
The commands I use are the following:
> loadercli -d TEST -u DBA,SYSDBA
> DBEXTRACT CATALOG OUTSTREAM FILE'C:\apps\xport\TEST.LOG' DATA
OUTSTREAM FILE'C:\apps\xport\TEST.DATA'
After loggi
Hi Patrick,
Patrick Beunaiche [mailto:[EMAIL PROTECTED] wrote:
> Hello,
>
> I am encountering an issue when I want to download the data
> of a cell that
> contains break lines into a COMPRESSED stream and then reload
> these data
> into another database. There is a conflict with the LINE
> BR
because of some external applications
constraints.
Is there a special function that could transform \r into a special string
during the DATAEXTRACT of LOADERCLI ? This special string would be well
interpreted by the DATALOAD of LOADERCLI, then.
As there are DELIMITER, NULL, SEPARATOR parameters
Hi David, Stefan,
David Brady [mailto:[EMAIL PROTECTED] wrote:
>
>
> Did you ever get your issue solved? I'm encountering the exact same
> issues with the exact same version scenario as you - trying
> to move data
> from 7.5.00.08 to 7.5.00.23.
>
Which Loader (version) did you use to do wha
ot;,"3991"
"GLOBAL","DEPARTMENT","3","?","?","?","?","20050325data0001","FILE","?","RECORDS","ASCII","0","5015","0","7063&
In my ongoing efforts with moving data from one server to another...
Using 7.5.00.18 of loadercli, I did the following:
loadercli>catalogextract user outstream file 'catalogv30'
Checking the file created showed that it mostly looked great - all 30+
tables had the right definitions
quot;,"5015","0","7063","0","6039"
etc...
Anyone from MaxDB lend a hand?
Thanks,
David
Stefan Schmidt wrote:
Hello,
I am doing a:
CATALOGEXTRACT USER OUTSTREAM FILE 'license_db_schema'
//
TABLEEXTRACT USER DATA OUTSTREAM FILE
Hi Keith,
Keith [mailto:[EMAIL PROTECTED] wrote:
>
> Are you suggesting that I copy the loadercli.exe file from a
> newer install,
> copy to the older system, and then re-run the extract?
>
Well, I thought more of you have two systems which are connected
and you can run the newer loader from yo
using loadercli between 7.5.00.08 and 7.5.00.24
Hi Keith,
Keith [mailto:[EMAIL PROTECTED] wrote:
>
> I extracted a table and schema from a 7.5.00.08 db instance with:
>
> DATAEXTRACT FOR DATALOAD TABLE bom_ext OUTSTREAM 'bomext.cmd'
> OUTSTREAM 'bomext.dat
r running a 7.5.00.24
> instance and ran:
>
> loadercli -u USER,MYPASSWD -d SYM -b bomext.cmd
>
>
> The create portion of the script ran fine but I got the
> following error during the dataload portion:
>
>
> This value is not a valid number:
>
> Any suggesti
I extracted a table and schema from a 7.5.00.08 db instance with:
DATAEXTRACT FOR DATALOAD TABLE bom_ext OUTSTREAM 'bomext.cmd' OUTSTREAM
'bomext.dat'
I copied the file to the new server running a 7.5.00.24 instance and ran:
loadercli -u USER,MYPASSWD -d SYM -b bomext.cmd
IAL(1) e.g.:
CREATE TABLE "ACTIVATIONS"
(
"ACTIVATIONID" IntegerNOT NULLDEFAULT
DEFAULT SERIAL (1),
...
I am then doing a:
loadercli -d DB -u user,pass -b license_db_schema
on a 7.5.0.23 server, having removed the duplicate DEFAULT from the
file.
Hi Alexei,
Alexei Novakov [mailto:[EMAIL PROTECTED] wrote:
> I just tried MaxDB 7.5.0.23 on linux (suse 8.2) and
> ran into issue with loadercli extracting user data.
>
> USE USER user-name xxx SERVERDB TESTDB
> //
> CATALOGEXTRACT USER OUTSTREAM FILE 'schema.ddl'
&
Hi all.
I just tried MaxDB 7.5.0.23 on linux (suse 8.2) and
ran into issue with loadercli extracting user data.
USE USER user-name xxx SERVERDB TESTDB
//
CATALOGEXTRACT USER OUTSTREAM FILE 'schema.ddl'
//
TABLEEXTRACT USER DATA OUTSTREAM FILE 'schema.dat.'
//
Last line gi
Hi,
if I import data with dbload, loadercli crashes with segmentation fault.
1. here is the dbextract command on the source system (maxDB 7.5.00.8 on
SUSE Linux)
loadercli>USE USER dba dba SERVERDB INXMAIL ON 127.0.0.1
loadercli>DBEXTRACT CATALOG OUTSTREAM FILE '/tmp/inxmail_ddl'
Hello,
I have a problem : a stored procedure call under php and loadercli
don't work, but work with sqlstudio !!! With this last software,
i obtain de good result. But i really can't figure out why it
doesn't work with the two others...
Do you have any idea why ?
The error me
oups... just forgotten to specify software versions :
- MaxDB 7.5.00.14
- PHP 5.0.2 (with maxdb-php-source-7_5_00_19)
- System : i386 Linux Debian Woody 3.0R2
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http://lists.mysql.com/[EMAIL PR
Hello,
I have a problem : a stored procedure call under php and loadercli
don't work, but work with sqlstudio !!! With this last software,
i obtain de good result. But i really can't figure out why it
doesn't work with the two others...
Do you have any idea why ?
The error me
Hy
i'm using maxdb 7.5.0.19
While i'm loading data that i've exported with loadercli (same version)
i get the error
// E -25010:SQL error -4005 = Unknown column name:(null) (error
position: 41)
the problem is that i don't know which table is involved
i suspect tabl
Am Donnerstag, 16. Dezember 2004 14:28 schrieb Schildberg, Steffen:
> Hi Herman-Josef,
>
> Hermann-Josef Krings [mailto:[EMAIL PROTECTED] wrote:
> > I try to give loadercli a command file which has been
> > extracted from the DB table triggers in UTF-8 format.
> > On L
Hi Herman-Josef,
Hermann-Josef Krings [mailto:[EMAIL PROTECTED] wrote:
>
> I try to give loadercli a command file which has been
> extracted from the DB table triggers in UTF-8 format.
> On Linux:
> file TRIGGER.001
> TRIGGER.001: UTF-8 Unicode text
>
> Since the f
Hello,
I try to give loadercli a command file which has been extracted from the DB
table triggers in UTF-8 format.
On Linux:
file TRIGGER.001
TRIGGER.001: UTF-8 Unicode text
Since the file has 3 Bytes in front (ef bb bf) which indicate it is an UTF-8
File,
loadercli -u $ADMU,$ADMPW -d $DB
Hi Filip,
Filip Sergeys [mailto:[EMAIL PROTECTED] wrote:
>
>
> I get this message on certain datafiles when trying to dataload them
> with loadercli.
> I don't understand what the problem is because the recordlength is
> rather small.
> Below is a piece of the dataf
I get this message on certain datafiles when trying to dataload them
with loadercli.
I don't understand what the problem is because the recordlength is
rather small.
Below is a piece of the datafile and the control file I use, and the
error message.
loadercli -d -u , -b t_postka
Hi Juergen,
Hoelker, Juergen [mailto:[EMAIL PROTECTED] wrote:
>
> Once again my request for helt, I'm really desperate here.
> I'm migrating some tables from ADABAS D to SAPDB 7.4, I
> extracted the needed
> Tables via XLOAD and want to load them to my SAPDB-Database
Hi,
Once again my request for helt, I'm really desperate here.
I'm migrating some tables from ADABAS D to SAPDB 7.4, I extracted the needed
Tables via XLOAD and want to load them to my SAPDB-Database with
loadercli/repmcli. I used the command:
repmcli -u dba,dba -d tst74 -b sc
bonjour,
Le mercredi 11 août 2004, Jim Sanders a écrit...
> loadercli -d ACMECO -u DBM,ABRACADABRA
> I get this error:
>
> Loader Server Protocol: '/root/.sdb/loader/log/loader.prt'
> Error connecting user DBM to database ACM
I can log into the DBMCLI using exact same switch settings AOK.
But logging into interactive mode on the LOADERCLI app using the command
line:
loadercli -d ACMECO -u DBM,ABRACADABRA
I get this error:
Loader Server Protocol: '/root/.sdb/loader/log/loader.prt&#
Hi,
I'm migrating some tables from ADABAS D to SAPDB 7.4, I extracted the needed
Tables via XLOAD and want to load them to my SAPDB-Database with
loadercli/repmcli. I used the command:
repmcli -u dba,dba -d tst74 -b script -E 50
the content of script is:
SET MAXERRORCOU
How can I get loadercli to dump numeric fields without quotes?
Currently all fields are in quotes. Here is my dataextract statement:
DATAEXTRACT * FROM ChainBasic
WHERE ZIP='97601'
OR ZIP='97603'
OUTFILE '/bk/ChainBasic97601-3.d'
--
MaxDB Di
Hi Hermann,
I'm terribly sorry for the delay in answering to your
problem (vacation, ... ;-) ).
Hermann-Josef Krings [mailto:[EMAIL PROTECTED] wrote:
>
> I run into a problem with loadercli when exporting data that
> ends in a german umlaut.
> sapdb Version: 74-7.4.3.32-1
Hello,
I run into a problem with loadercli when exporting data that ends in a german
umlaut.
sapdb Version: 74-7.4.3.32-1
SuSE Linux 8.1
Example that failed:
---
Loader Server Protocol File:'/var/opt/sapdb/indep_data/wrk/loader.prt'
User ADM connected t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I run into a problem with loadercli when exporting data that ends in a german
umlaut.
sapdb Version: 74-7.4.3.32-1
SuSE Linux 8.1
Example that failed:
- ---
Loader Server Protocol File:'/var/opt/sapdb/indep
LoaderCli still crashes. It exports 21 table definitions with triggers and then
crashes.
-Ursprungliche Nachricht-
Von: James Coen [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 24. Juni 2004 15:04
An: Sudhoff, Andre
Betreff: Re: catalogextract user, loadercli crashes
I don&#
Hi,
I try to extract the catalog of an user ("catalogextract user outstream 'user.cat'"),
but every time the loadercli crashes.
Can anybody help me ???
Platform:
Windows 2000 sp4
DB:
7.4.03.27
LoaderCli:
7.4.03.27
Thank you in advanced
<> <>
0100C
I'm trying to copy data from a 7.3 database to 7.5 using loadercli
CATALOGEXTRACT. However, all the CREATE TABLE statements are empty
except fo rthe table name and a trailing parenthesis. Looking at
loader.prt, I see that every SELECT fails because it's looking for a
column in doma
uot;
Same thing happens if I run loadercli directly and
start it as "loadercli -d test". But if I explicitely
specify host name like "loadercli -n localhost -d
test" everything works fine.
I checked my /etc/hosts - it's OK. I suspect that this
can be related somehow to the fa
Hi Zavier,
Zavier Sheran [mailto:[EMAIL PROTECTED] wrote:
>
> Is it possible to define a condition similar to this:
>
> DATALOAD TABLE DBA.cars_used IF length('POS 20 ') <= '1000'
>
> where the record is only imported when the length of POS 20
> is less or equal 1000 characters?
>
To make it
Is it possible to define a condition similar to this:
DATALOAD TABLE DBA.cars_used IF length('POS 20 ') <= '1000'
where the record is only imported when the length of POS 20 is less or equal 1000
characters?
Thanks
-Zavier
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
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
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.
DATA
Hi Steffen,
Steffen.Proksch [mailto:[EMAIL PROTECTED] wrote:
>
> 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
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
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
Hi Thorn,
Thorn Roby [mailto:[EMAIL PROTECTED] wrote:
>
> I'm attempting to restore a database from a dump which I have
> previously
> restored successfully on 7.5.0.8, and which was dumped from a 7.3
> system. However, on 7.5.0.11 loadercli fails with the following error
I'm attempting to restore a database from a dump which I have previously
restored successfully on 7.5.0.8, and which was dumped from a 7.3
system. However, on 7.5.0.11 loadercli fails with the following error:
Error opening file '/restore/r1catalog.dat': File not encoded as
Hi Heiko,
Heiko Giesselmann [mailto:[EMAIL PROTECTED]
>
> I am having problems with a simple load command. I checked
> the manuals
> and I haven't been able to find the probably very basic and
> simple problem.
>
> Table t1 was created using the following statement:
> CREATE TABLE t1 ( c1 TIM
Le vendredi 30 avril 2004, Jean-Michel OLTRA a écrit...
bonjour,
> You should look at the loadercli doc, too, especialy KEYWORDS and SET
> command.
Oops ! Keywords to look for are SEPARATOR AND DELIMITER
Search ML archives for syntax examples.
--
jm
--
MaxDB Discussion M
Le vendredi 30 avril 2004, Heiko Giesselmann a écrit...
bonjour,
> Thanks Jean-Michel, loading works with quoted data values.
You should look at the loadercli doc, too, especialy KEYWORDS and SET
command.
It can be simplier to describe the file, rather than quoting all fields
dy in charge of the docs can address this.
Thanks again, Heiko
-Original Message-
From: Jean-Michel OLTRA [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 29, 2004 2:24 PM
To: [EMAIL PROTECTED]
Subject: Re: loadercli question
Le jeudi 29 avril 2004, Heiko Giesselmann a écrit...
bo
1 - 100 of 169 matches
Mail list logo
