sybase 问题请教 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

sybase 问题请教

sybase 问题请教# Database - 数据库

s*12010-03-14 08:03

1 楼

我现在要load flat file 到sybase table
这个表比flat file多一个rundate 列
请问怎样在scripts里把这个rundate列也
加上然后bcp到表里
还是我只能把其他列bcp，然后在表里再update
那个列？
thanks a lot for your suggestion.

j*n2010-03-14 08:03

2 楼

bcp to a staging table that has a rundate column with default value as
GETDATE.

s*12010-03-14 08:03

3 楼

thanks for reply.
then how to cp from staging to final one?

【在 j*****n 的大作中提到】

: bcp to a staging table that has a rundate column with default value as
: GETDATE.

j*n2010-03-14 08:03

4 楼

now you got all you want in stating table...
insert into destinationTable
Select * from stagingTable
when you do ETL, staging table is a good practice for doing data massages.

【在 s********1 的大作中提到】

: thanks for reply.
: then how to cp from staging to final one?

j*n2010-03-14 08:03

5 楼

I haven't using sybase for years... so I can only give you the universal way
. I am sure there would a better way for using sybase ETL tool. such as in M
$ SQL Server, you could have a derived column to do so in SSIS without
sacrifice performance and storage space.