database - Sybase bcp error -


what want copy table file, truncate table , copy data table.

for this, using following 2 commands:

out: bcp table out file.csv -s server -u user -p password -r '\n' -t '^|' -c
in: bcp table in file.csv -s server -u user-p password-r '\n' -t '^|' -c -j iso_1 -b 5000

this error get:

cslib message: - l0/o0/s0/n36/1/0:
cs_convert: cslib user api layer: common library error: result truncated because conversion/operation resulted in overflow.

the interesting part ( me, @ least ) error rows first column being odd number. first 3 million rows, cuts half of them, having first column ( pk ) odd number.

i tried different options, none seem work: no problem charset far can tell, there no huge columns such truncated , not carriage return missing.

any appreciated.

update: after creating format-file there no more errors, copies half of data table.

update: managed create format file works , loads data, cannot use on server (it works in testing environment, needs run in production environment), since says attempt read unknown version of bcp format-file.? know means, there way of finding correct values of version?

solved: after digging in database, seems problem indeed data inconsistency due fact view used in production copy table copied 25 columns, table has 26 columns ( altered table , didn't know , hadn't noticed happened ). fixed view , works.

since going out of/into same server, recommend use bcp native flag.

bcp dbname..table out file.bcp -sserver -uuser -ppassword -n bcp dbname..table in file.bcp -sserver -uuser -ppassword -n -b5000

character mode can wierd, , use when required.


Comments

Post a Comment

Popular posts from this blog

image - ClassNotFoundException when add a prebuilt apk into system.img in android -

i'm in trouble add prebuilt apk system.img based taiwan mtk android phone platform, when push apk onto device,after reboot phone,the apk can installed succecessfully,but if add apk alps/out/target/product/$prj/system/app or vendor/mediatek/$prj/artifacts/out/target/product/$prj/system/app ,and produce system.img,the apk can't installed normally,the logcat say: a.lang.runtimeexception: unable instantiate activity componentinfo{com.sec.android.widgetapp.ap.hero.accuweather.widget/com.sec.android.widgetapp.ap.hero.accuweather.widget.weatherclock}: java.lang.classnotfoundexception: com.sec.android.widgetapp.ap.hero.accuweather.widget.weatherclock. can tell me what's problem ? when package manager installs apps part of system partition different installing apps on data partition. looks app using libraries somewhere else. when install on data lib directory created in apps data directory , symlinked /data/app-lib/. when apps installed on system it's expecte...
Read more

I need to import mysql 5.1 to 5.5? -

i have mysql 5.1 database , need import localhost running 5.5. how import 5.5 or downgrade mysql? install phpmyadmin 5.1 os: http://www.wikihow.com/install-phpmyadmin-on-your-windows-pc or https://www.digitalocean.com/community/articles/how-to-install-and-secure-phpmyadmin-on-ubuntu-12-04 then login, click on database, hit export, , export in sql format (quick fine). import .sql file 5.5 server (after installing phpmyadmin) logging in clicking database , hit import. hope helps!
Read more

Java, Hibernate, MySQL - store UTC date-time -

i saw here on few related questions (like this one , of course, this one )... essentially, want store date-time utc, , let application user choose time zone wants display date-time in. since seems date-time fields affected underlying jdbc driver, wonder if acceptable way go storing utc date-time: set both mysql , application server machine utc time zone (no need separate) both mysql , jvm should pick underlying system time settings (if not instructed otherwise) use datetime table columns on mysql side use java.util.date corresponding mapping on hibernate side (i guess java.sql.timestamp used too) let application worry interpreting date-time fields - i.e. let user choose preferred time zone is ok? edit clarify - here meant refer timestamps created strictly on server (e.g.date-time of record creation). application server instantiates date objects (new date() equals current date-time on server, , time zone agnostic). if client user wants supply date searching/filte...
Read more