data Load in to table partitions.
Moderators: chulett, rschirm, roy
data Load in to table partitions.
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
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
Rumu
IT Consultant
IT Consultant
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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....
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....
Rumu
IT Consultant
IT Consultant
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: