Hi All
What is the best way of firing a delete command on the database.
One of the threads in the forum sugested that any operations on the database from Datastage Basic will stop working after 30 days as there are separate licences need to be brought for doing that from Data direct.
I guess the other method being A job with a oracle stage and some output link with a custom SQL in the oracle stage should do the trick.
Is there a much better of firing the delete on the database?
Any help will be really appreciated
Thanks
Pavan
Delete on a Database
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 133
- Joined: Tue Nov 23, 2004 11:24 pm
- Location: India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 133
- Joined: Tue Nov 23, 2004 11:24 pm
- Location: India
Hi ray
Sorry if the question was not properly asked...I don't intend to delete the whole table but delete it based on a some criterion in the where clause...
And can you also please re-confirm me that my understanding that SQL commands through basic will be revoked after 30 days without proper licensce from Datadirect for oracle or for that matter any database...I got this information from you and i was all over the documentation but still couldn't find this....
Thanks
Pavan
Sorry if the question was not properly asked...I don't intend to delete the whole table but delete it based on a some criterion in the where clause...
And can you also please re-confirm me that my understanding that SQL commands through basic will be revoked after 30 days without proper licensce from Datadirect for oracle or for that matter any database...I got this information from you and i was all over the documentation but still couldn't find this....
Thanks
Pavan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Send the keys of the records to be deleted from the job, and use user-defined SQL of the form DELETE FROM tablename WHERE key = :1
Data Direct ODBC drivers do expire after 30 days. But you can use other ODBC drivers (with different DSNs) from Windows-based servers. These - for example the Microsoft ODBC drivers - do not expire.
Data Direct ODBC drivers do expire after 30 days. But you can use other ODBC drivers (with different DSNs) from Windows-based servers. These - for example the Microsoft ODBC drivers - do not expire.
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.
-
- Premium Member
- Posts: 133
- Joined: Tue Nov 23, 2004 11:24 pm
- Location: India