| bcp2load 2005-03-30, 7:08 pm |
|
okay I would BCP out using -c for ascii
That way any problems can be manually be edited via vi or
another
non pure editor
once we have our files
you load with isql with this type of command
SET TEMPORARY OPTION ESCAPE_CHARACTER = "ON"
SET TEMPORARY OPTION CONVERSION_ERROR = "OFF"
SET TEMPORARY OPTION NON_ANSI_NULL_VARCHA
R = "ON"
GO
load table user.table
(
row 1 "\x09"
,row2 "\x09"
,row3 "\x09"
,endrow "\n"
)
FROM '/full_path/whatever.bcp'
STRIP ON
QUOTES OFF
ESCAPES OFF
WITH CHECKPOINT ON
NOTIFY 1000
ON FILE ERROR ROLLBACK
IGNORE CONSTRAINT ALL 0
MESSAGE LOG '/full_path/something.log'
ROW LOG '/full_path/something.trace'
go
COMMIT
go
Good luck
> Hi,
>
> I'm trying to write a simple script that bcp data out from
> ASE and loads IQ. As of now I can't see any straight
> forward solution in order to achieve this. Would any one
> know witch load table options to use. Combination of
> "delimited by" and "row delimited by" and what should be
> after the last column in the column-spec?
>
> Your help is appreciated.
>
> Nik
>
> Platform: IQ 12.5
> OS: Sun 5.8
> App: isql
|