DSXchange

Then there is always DataStage TX, which is real time with good automatic triggering mechanisms. I don't know how it compares to RTI as I have never seen RTI though.

I am going to Sequential Stage, so I can set Null field value = "" in Format, Field Defaults it does kind of work.

However if I was going to other stages I may not have this option.

I shall try this out.

This may be a stupid question however; if I have a Nullable field (say varchar(12)), why cannot I set the derivation to SetNull()?

Surely if a field is nullable it can accept a Null, as a value. And setNull surely sets Null to be the value?

Thanks, that sounds like the solution to my problem.

I'm sure that the Sybase OC software is installed correctly on the DataStage server as I can get data out of the Sybase tables, I just can't get a resultset from a Stored Procedure.

It seems that I need to obtain and install an ODBC driver on my Solaris box. Oh well

It seems to support Sybase, as it is an option from the property help of the Database vendor field. I had a look at the documentation you mentioned and it does document the Stored Procedure stage but only from a Oracle point if view, so I am guessing that 7.5.1. supports Sybase Stored procedures, ho...

I am trying to obtain the result set from a stored procedure. The database is Sybase and as I am running 7.5.1 I have the new Stored Procedure Stage. Unfortunately there seems to be no documentation on it. When I try and use it, I am asked to supply a DSN. My questions are therefore. 1) Can I only u...

Yes I have checked the APT_ORCHHOME in director and it is fine. I think that DataStage uses the APT_ORCHHOME to find the etc/jobmon_ports which tells it which Ports to use. The log tells us "Failed to discover JobMonApp port" I don't know whether DataStage is having a problem getting the p...

Yes, all the projects have the same APT_ORCHHOME

mmanes wrote:You use that project by the same user?

Yes, with the same user

Have you run out of space on a filesystems?

We have a problem obtaining Performance Statistics for all the Parallel jobs in one project. The other projects are okay, as are the server jobs in this project. We have an error in our Event Log Failed to discover JobMonApp port, APT_ORCHHOME environment variable may not be set correctly. We think ...

Thanks, yes that does kinda work. The Float is already defined as 15,2, however the scale may be meaningless for a Float. However if I convert the Float to a Decimal 15,2 and then do the DecimalToString in another Transformer this does indeed work (an extra transformer though). I can also do the fol...

I am performing a type conversion from a Float to a String using the following Trim(DecimalToString(DSLink2.NOMIN_QTY,"fix_zero,suppress_zero")) This works fine apart from the fact that I have no control over the number of decimal places. For example the output may look like 14256.43676 Wh...

My guess (don't know for sure) is that PX jobs may not have a 'User Status' area like Server jobs do. :? That's possible I am new to PX, however in the Sequence you can access the $UserStatus for the particular PX Job using ActivityVariables. I am accessing $JobName and this seems to work, $JobStat...