DSXchange

I've discovered that the new Oracle Connector stage available in Datastage version 8.1 allows for multiple commands in the close command. It also allows for partition reads and the option to execute a close command by stage or by node.

Interesting solution. So, no issues with quotes disappearing yet? It is notorious for stripping quotes from parameters, which usually means sql snippets are affected the most. ... Good point! I have not had to pass special characters or quotes in this job yet. I guess when that is a requirement I w...

Sorry, thought it supported multiple commands much like the before/after sql tabs do in other stages. I also thought that would be the solution but unfotrunately not. I developed an alternate method in which to do this. I created a "server" job that reads from oracle and writes to a sequa...

Doesn't the CLOSE command support that? There's no direct equivalent to the 'SQL step' you mentioned, in my world this would be a scripted call to sqlplus that executed all of those commands and checked for issues, called as a separate job / step so it can be restarted without being tied to the loa...

Hello, I am using Datastage 8.1 running on an AIX 5.3 server. My job is basically loading a table from an Oracle database (10g) into another Oracle database. After the load is complete I need to run a series of SQL commands (drop, delete, create index, etc..). Besides using the "Close command&q...