DSXchange

jfiddespayne wrote:See my original post for more info and please note I am using DS version 6.

Not supported in your version. Upgrade to 7.5.x so you can use the Stored Procedure stage.

Or build a standard script to handle situations like this. It can do all the 'setup the environment' chores necessary to ensure success and then 'run' the file in question.

Start with your DBA. ODCIIndexUpdate When a user updates a record, Oracle calls your ODCIIndexUpdate() method, passing it the old and new values in the indexed columns and the corresponding row identifier. Oracle Error :: ORA-29877 failed in the execution of the ODCIINDEXUPDATE routine ORA-04030: ou...

How would you do it outside of DataStage? What is the command line utility for DB2? For Oracle it would be sqlplus but I have no idea what the DB2 equivalent is.

Short answer - no. One of the joys of using a standard 'widget' for an interface, not all fields apply to all stages.

And sometimes they're just not cleared, period. Best to create them off someplace else where you don't have to worry about them.

The best way to delete these sort temp files from the Project is to not create them there in the first place! There is a property in the Sort stage that tells it where to put them when it runs. By default it is blank which means the Project. Never leave it blank. I always set that property to "/tmp"...

You can't transfer a file with the FTP stage? Isn't that what FTP stands for? As long as the 'from UNIX box' box means the DataStage server box, then you certainly can. Use a Sequential File stage to deliver the data to the FTP stage and point it at the remote server. Perhaps all this negativity com...

With the level of changes involved here, any idea how 'upgradable' a 7.x Server installation will be? Or is the preferred methodology to create a new 8.x installation and then import everything in?

In other words, a bug in the 9.2.0.6 Oracle client... who would'a thunk it?

Perhaps you should roll up and not down, I think the latest version for 9iR2 is what - 9.2.0.8?

It's a perfectly fine approach. The 'cost' to look for those files will be minimal and I always prefer the simplest approach that satisfies the requirements. For what it's worth, I've done things very similiar to this in the past, well before I learned how to spell DataStage. If it was me, I'd have ...

In other words, a one time warning you shouldn't see in the project again unless something happens to the SDKSequences there.

This would be the 'other one' mentioned that a patch exists for: Brief description of problem (ecase 72758) ========================================== It appears that the Datastage designer client crashes intermittently when editing job sequences. The problem has been reported with the Datastage Cli...

This is getting boring... pretty soon Ray will be competing with McDonald's for Umpty Billions Served.

Wow... just over one year later.