data Load in to table partitions.

rumu · Post by **rumu** » Tue Jan 13, 2009 2:57 am

Hi All,

Could we load data in to table partitions through ODBC stage?
Our database in SQLSERVER 2005.
Could we use 'user defined sql' to achieve the same.

Regards,

rumu

keshav0307 · Post by **keshav0307** » Tue Jan 13, 2009 6:27 am

what is your findings?
are you able to load or not?

rumu · Post by **rumu** » Tue Jan 13, 2009 6:51 am

we have not applied it so far,we need to define the strategy hence I am asking.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 13, 2009 3:03 pm

You advertise yourself as "IT Consultant". Try it, and report your findings. If it's doable in user-defined SQL then you ought not to have any major issues with DataStage being the database client that executes that particular SQL statement.

rumu · Post by **rumu** » Wed Jan 14, 2009 2:44 am

Ray,

Attacking someone personally is not a good thing......people may ask query in the forum and I believe forum is for that ....if u r not interested in helping others then pls do not attack like this....

In our client place DS tool has not been installed and hence we are not in a position to test anything.....since our project is in pre-analyse phase,they are defining strategy ...so this question arises and I thought to ask a query and I belive if someone receives such a reply then he will thinki twice before accessing this forum....

fmcmullan · Post by **fmcmullan** » Wed Jan 14, 2009 11:45 am

rumu, read Ray's comment again.

He is saying to try it in SQL Server as a user-defined SQL statement. If it works there, then DataStage won't have any problem doing the same thing.

chulett · Post by **chulett** » Wed Jan 14, 2009 11:56 am

rumu wrote:In our client place DS tool has not been installed and hence we are not in a position to test anything

Just an FYI - this would have been something worth mentioning in your original post.

DSguru2B · Post by **DSguru2B** » Wed Jan 14, 2009 12:25 pm

I would have a chat with the SQL Server dba to understand how the partitioning works in sql server. It might be seamless and just a simple insert would work. The database might handle sending the right data to the right partition. I know this is what happens in a partitioned db2 table. Do not know about sql server.

rumu · Post by **rumu** » Thu Jan 15, 2009 2:28 am

Hi All,

Thanks for all your comments.

In SQLSerVer datainsertion is perfect ..no issue with that ,we just wanted to know if this is possible through DS and I checked it in my friends machine yesterday and it is perfectly working.

This issue is resolved.

Regards

ray.wurlod · Post by **ray.wurlod** » Thu Jan 15, 2009 3:45 am

Quod erat demonstrandum.