DSXchange

This is a topic for an orphaned message.

yes, your right. My mistake, its only in the OLE/DB stage that the View Data isnt available. Someone asked me that question, and I didnt verify. So I should reformulate my question: Why DataStage is not providing the "View Data" functionality in the OLE/DB stage? ) -----Original Message----- From: D...

Just out of curiosity....

Why DataStage is not providing the "View Data" functionality in their native stages such as Oracle OCI and Sybase OCI?

tks

christian

Dont know about the others, but view data has been available on Oracle OCI (ORAOCI8) in every version I have used (ranging from versions 3.5 to 5.2). -----Original Message----- From: Pelletier, Christian [mailto:CPELLETIER@probusiness.com] Sent: Thursday, 18 July 2002 10:05 AM To: datastage-users@ol...

The template job with all parameters is an approach I have been using since release 2.2. It works well when I hand over a project to other developers. It helps particularly if you know how to make your template job read-only, so that they cant accidentally overwrite it! However, documented and manag...

Does someone know if Parameter Manager is now (or will eventually be) shipped with DataStage XE, like Version Control? It seems useful but 10000$ is a little more that my manager is willing to spend... Any other alternatives out there? I am thinking of creating one baseline job with all the generic ...

Karthik: If I understand what you are doing, it is creating a snapshot of the data as it is sourced from a table. Then, you are going to read this snapshot and load it into a table. Things youre missing: (1) DataStage jobs are single threaded, this means that if your sourcing job is the only one sel...

This is a topic for an orphaned message.

Please could you include Polk St Albans and Polk Leeds as a requestor for this enhancement. Many Thanks Lawrence Ross -----Original Message----- From: Johnson, Carol S. (IS) [mailto:Carol.S.Johnson@CommerceBank.com] Sent: 17 July 2002 17:23 To: datastage-users@oliver.com Subject: FW: G33023 - Enhanc...

This is a topic for an orphaned message.

If you think this enhancement would benefit you, please notify Ascential. > -----Original Message----- > From: Johnson, Carol S. (IS) > Sent: Wednesday, July 17, 2002 11:18 AM > To: support@ascentialsoftware.com > Subject: G33023 - Enhancement request to add a utility to upgrade the > DataStage clie...

I guess I am curious as to how your program knows whether it will do an insert or an update. Most of this time this decision is made through doing a lookup to see if your key is already on the table. I would think in whatever mechanism this is done you could also store the value of the column you ar...

Nothing. As youve seen, most people misunderstood your situation. As people have since pointed out, youve got two primary options - either use two constrained links to write to Oracle, one which contains the column if non-null and one that omits it if null, or do a lookup to pull in the old value an...

Other than OCI and ODBC, there is also a SQL Server Bulk Loader. Riccardo Tani wrote:Hi, Yes, there is one for SQL Server 7/2000 (It should be this VMmsss15.so). So you can use ODBC stage!! Riccardo ----- Original Message ----- From: "Denzil Sander" To: Sent: Wednesday, July 17, 2002 1:25 PM Subject...

Hi, Yes, there is one for SQL Server 7/2000 (It should be this VMmsss15.so). So you can use ODBC stage!! Riccardo ----- Original Message ----- From: "Denzil Sander" To: Sent: Wednesday, July 17, 2002 1:25 PM Subject: Connecting to SQL Server > Hi all > > Is it possible to connect to SQL Server with ...