DSXchange

Hi, We're also trying to call a SQL Server stored procedure from DS. It seems that only the "ODBC" Server stage has the stored procedure option. I do not see the stored procedure option in the "ODBC Enterprise" or "Stored Procedure" PX/EE stages. Am I missing something?...

We've just tried installing the 7.5.1A client on Vista Enterprise. The install goes well and without errors. But, we've noticed that the stage properties look different (Oracle Ent., DRA, ODBC< Sequential stage, etc). They appear in the "grid style" on certain tabs (for example: properties...

FYI, I had a similar issue connecting to SQL Server 2005, on DSEE 7.5.1A on RHEL. IBM has issued me a patch, which resolved the issue. Please contact IBM: Scase:473187 Ecase: 74157 The patch contains updated versions of the following files: libdsplugin.so, liborpheus.so, dscapiop.so -rob good luck! ...

Hello, Does anyone know of a way to "mask" or hide the password when using the Oracle Enterprise stage as a target, using the Oracle Enterprise stage "Load" write method? This "Load" method uses the sqlldr Oracle utility to load the data, but uses the username and passw...

You won't get it for a server job or for a job sequence. Ahh, thanks. I was trying to add a message handler for a sequence, but wasn't testing the same thing on my other projects. :oops: Thanks. I don't really understand why this capability wouldn't be enabled for sequences? I'm guessing it's becau...

Does anyone know why I would not have the "Add Rule to Message Handler..." option in either Job menu or by right-clicking the log entry for any job in a particular project? I have the option in my other projects, but don't understand why the menu option is not there. Also, when I go to Mes...

From IBM: DataStage Oracle 9i Enterprise Stage has limitations with "ustring" (multibyte characters) due to the fact that it was originally written using Dynamic SQL, instead of ANSI Dynamic SQL, that Oracle recommends for all new applications. Here is some technical references: Ref: Pro*C...

FYI, this problem has not been resolved. However, after working with IBM on this, we've come to the conclusion that we will have to just deal with it. Evidently, the problem no longer exists after upgrading both database and client driver to 10g. To fix the existing problem for 9i, IBM would need to...

FYI, this problem has been resolved by applying a patch provided by IBM.

Please search for eCase 82152 in IBM's KnowledgeBase.

Just wanted to give an update on this. IBM has given us the same work-around... Use a project-level message handler. They have reproduced the error in-house, but prefer not to spend the time to fix it, since the warning doesn't seem to affect the data. :? btw, we're not using RCP; doesn't matter if ...

Is this a server job (as marked) or a parallel job (as posted)? The APT... environment variables will have no effect whatsoever on a server job. Have you tried using 000 as the field delimiter and as the record delimiter? We initially tried to do this with parallel job (as correctly posted). Howeve...

Hi Ray, I work with Shilpa, and have found that the problem here is as you say. The file is not formatted in the "usual" XML format, but in fact consists of a single line. Structurally, the XML is intact and properly formatted in terms of tags and so forth. We've found that the same file c...

Hi, I'm sort of new to XML in general, but have requirements to build some rather simple jobs to move XML data into SQL Server, then back to XML. The transformations involved are substring, concatenating, removing/adding columns, etc. Is there a drawback of using the XML Transform with XSLT, compare...

ha ha. very funny. I'm not the original poster... I used the search (like I'm supposed to), and just wanted to show my appreciation. :D

Yes! Ray, this was awesome advice. It took me two times to run, but I followed the instructions above to clear the log. The log is now able to be viewed successfully. This is what the files looked like before and after the CLEAR.FILE: $ ls -lrt total 2628008 -rw-rw-r-- 1 mhjb dstage 534386688 Feb 7 ...