DSXchange

thanks guys. I had one of those "Im sure I had this problem before" memories. Not sure I trust the Usage Analysis, so I AWKed a dsx export file to determine jobs. Recompiled. Sorted. And the read only issue in our production system can be worked around using the multiple job compile :) A q...

Hello all, When a shared container is initialized into version control and then subsequently promoted to an environment where there are existing jobs that depend on the container, does the promotion process recompile the existing jobs or is recompilation a process that needs to be done manually, or ...

Wow... someone that actually reads the upgrade logs. :wink: :D Since all this was meant for support personel in the event of a problem, not us mere mortals, and since you don't seem to be having a problem - I wouldn't worry about it. At a guess, you'd need to open a support case to find out what ex...

Regarding the unable to initialize plugins... Ensure you have the correct env set up in $DSHOME/dsenv and then restart your DS server process. Ensure these env vars set: - ORACLE_HOME=/oracle_inst/tools/oracle/product/9i <- or wherever it is export ORACLE_HOME SHLIB_PATH=$SHLIB_PATH:$ORACLE_HOME/lib...

The upgrade logs contains reference to 'Record ID "$DS.NULLTRX" not found' The jobs appear to have been converted ok, but were not sure what these messages are telling us :? example cut from the log: - ================================================ Job AllmonthlyUsageData2 has been conve...

ray.wurlod wrote:The nice thing about ADN is that Ascential employees are officially permitted to post there.

Surely youre not suggesting Ascential employees would post here unofficially

Having had various reasons and needs to pick up values, write values etc in jobs and reading others posts on similar issues, I wonder if this could be a useful suggestion. What if there was a plug-ins developed that could act as a read/write store. A "variable manager" front end could be d...

Not sure about SQL Server, but with Oracle OCI stage can call SPs and Functions just by embedding the SP call into a select statement of a reference link such as: - SELECT funcX(:1, :2) REGION, :1, :2 FROM dual Should you wish to call it only once during a job, you could create a "parallel job&...

I started a thread 24 Nov 2004 on this same issue http://www.dsxchange.com/viewtopic.php?t=90045 Anyhow, on the other thread it was suggested it may be a Win2k client issue. Dont know if thats the case or not. We cant move off Win2K here so thats not an option for us. Theres an open eCase 63447 with...

Likely lame advice but which implementation of ODBC drivers are you using on AIX? Is there some of their documentation you could read? Im sure you thought of this already also, but if you cant use OCI and need a temporary fix to get *something* working, you could use to_char() and convert back and f...

"Just wondering if anyone else out there has had this kind of problem and managed to get 38 significant digits loaded using DS? " I can extract using DS type decimal length 38 numbers like 12345678901234567890123456789012345678 12.345678901234567890123456789012345678 using v7, regular orac...

Hi, We are having a sporadic problem with DataStage Version Control. It manifests itself occasionally when a job is promoted. If the promoted job is then viewed, it can be a completely different job from that that was supposed to be promoted. It cannot always be fixed by promoting it again and we ha...

trokosz wrote:Sarbanes-Oxley does not consider ODBC to be providing a secure environment. It's a interpretation that the top 3 accounting firms are using duing audits.

ODBC, like OCI, is a protocol, like many others.
If you want security, put a secure layer around it.

I checked the versions and they are ok.
There were anly about 60 files in the &PH& dir.
On the next attempted run, the job ran okay :O
We made no changes between runs except looking at the logs and &PH& dir.
No idea what the problem is.

I have a job which does a simple select... from a table into a sequential file. On occasion the job fails to do the select and finishes almost immediately. Looking at the log, it has lines:- (NB I have replaced the actual jobname with the word jobname in these below) Environment variable settings: F...