Are you are using a driver (eg ODBC) to connect to the database? We saw a problem where for large results, the driver would truncate the data because it did not allocate enough memory to hold the complete result. Is the data truncated when you run dbunload directly from the command line? answered 10 Feb '13, 23:21 Mark Yes I'm using ODBC driver to connect to database, I think it is Sybase jConnect JDBC. Probably I didn't it use directly from command line because I need application to do this. The biggest problem is that on my instance of application dbunload started to work correctly however on the other one it fails. And I did nothing here. Any idea ?
(11 Feb '13, 02:37)
Kurkey
Replies hidden
I'd still recommend to use the exact command directly from the command line to see if that truncates data, too. (I have never ever run into this issue...). IIRC, 11.0.1.2044 is the original 11.0.1 maintenance release and rather "old" nowadays, so you might as well try to use a current v11.0.1 EBF - cf. Breck's helpful EBF list here...
(11 Feb '13, 07:19)
Volker Barth
I did unloaded database from command line then I reloaded it using dbisql from command line and data wasn't trucated at all. But I think on the other machine it would fail, but I will check this out soon. To point that out I changed nothing so far. I'll keep you informed if this is fixed.
(12 Feb '13, 08:01)
Kurkey
|
Please post the SQLA Version you are using
How exactly are you running the command?
Well version is 11.0.1.2044 and I'm running the command from C# which look like this dbunload.exe -xx -q -y -c "{0}" -t {1} -r "{2}" .", conString, tables.ToString(), Path.Combine(dirPath, "reload.sql")); where conString is connection string, tables is array of table I'm unloading and the last one is path to reload.sql
Whats more. I have a in one column data which has someting from around 200KB to around 800KB its binary data for image. And sometimes dbunload cut it to size of 512KB and my program cannot read that
Please explain exactly what you mean by "it cut data"? How are you looking at the data? Perhaps an example table definition and sample output would help us understand what problem you are having.