DSXchange

Since routines and transforms are obviously in different namespaces. how does DataStage know which one to use (assuming you have a transform and a routine with the same name) ? There's a rule, a precedence - Transforms beat Routines in a hand of DataStage poker. If you have a transform and a routin...

Yes, it is possible to use the FTP stage as an input stage, but I personally would try to avoid using it in that manner. You are (in most cases) better off to use 'normal' FTP to move the data local to your DataStage server and then picking it up with the Sequential stage. When you say you 'activate...

I'm calling the command from a sequencer after the job in question has run. As Vince noted, we'd need to see your code. Everything would need to be spelled and 'cased' correctly for it to work. Get any of the parameters wrong and you'll get one of a variety of negative return codes. I have a generi...

I'm pretty sure you are correct, support for Oracle 7.x has officially been dropped by pretty much everyone, including Oracle. That doesn't necessarily mean it can't be made to work, however. First off, what version of Oracle 7 are you running, exactly? The 'normal' ODBC drivers are supposed to work...

Are you logging in with the administrator user - typically 'dsadm'?

I would guess that your production server is a new DataStage installation and not just another project on your current server. That being said, when the product was installed the optional plugin you are having a problem with wasn't installed. You need to run through the installation again, it will k...

Another option would be to stop using the 'Oracle ODBC' stage and try using the native OCI stage instead. It shouldn't get... confused.

Well, there have been several posts on the subject by the likes of Ray and Ken, who counsel that it is generally Not A Good Idea. This makes all hash files 64 bits, including the internal hashes used by the engine. That being said, from what I recall it would only affect any new hash files created a...

I think the other question is why are you using this function? What are you trying to accomplish in this routine? Perhaps if you spelled out the details, there may be 'better' ways to get you where you want to go.

Right, that's one approach. You can also sometimes do this in a routine and use the $ReturnValue in much the same fashion. Depends on how the second parameter is 'generated'.

shamshad wrote:second parameter is generated dynamically from database

Can you explain exactly what this means, how it is generated? The answer will help drive your solution.

There are several posts here that indicate that the DB2 stages need dates in internal format, contrary to any other stage. I don't do DB2 myself, but I believe from reading posts here that all you need to do is an appropriate iconv of the source data.

ray.wurlod wrote:More complete answer: from the Administrator client Command window for the project.

More than likely, your dsrpcd deamon is not starting. A couple of things to try... With the server shutdown, kill any errant client connections - things like 'phantom', 'dsapi_slave' or any other entries associated with DataStage. After doing that, try restarting the server. If it still doesn't star...

Easiest answer... from the Administrator.