DSXchange

chulett wrote:That or "Timed out while waiting for an event". ...

Wow, that search gives me exactly 6 hits. All of which more or less say "why don't you try searching for "'timed out while waiting for an event'"?

That's why this is such a helpful site.

Continuing a related conversation from here. A stored function is selected in a query just like a table column and DataStage doesn't change how any of that works. If the function performs an insert, delete or update, it cannot be used in a select statement just like a column. So if anyone knows how ...

You could use: DateToString(StringToDate(link.FROM_DT,"yyyymmdd"),"dd/mm/yyyy") or: Right(link.FROM_DT,2) : "/" : Left(Right(link.FROM_DT,4),2) : "/" : Left(link.FROM_DT,4) or: link.FROM_DT[7,2] : "/" : link.FROM_DT[5,2] : "/" : link.FROM_D...

Or, you could instead be helpful and answer the question so that those who have encountered this irritating flaw in the product (WTH does a simple, built-in utility routine that can't possibly fail return a code that's interpreted as an abnormal result anyway?) don't have to waste many precious minu...

Anyone have anything more to add to this? We are experiencing the same situation where a query in a SYBASE OCPX stage is hanging for hours at the "Logging delayed metadata" point. We have obtained the following results: 1. The query runs quickly when submitted via isql or DBArtisan. 2. The...

Can't set the default to a space because there is already a non-space default!

Anyway, my workaround for now (because this has to be in place by tonight) will be to add substitution handling in the sequence for some_param=NONE.

But there's got to be a better way...

Try this typeset space=" " dsjob -run -jobstatus -param some_param=$space myProject myJob Good idea. I tried, but it was interpreted as passing an empty string for the parameter value. edit: Tried that, too (the quotes), but that just substituted the space so I'm back to the same syntax e...

I need to pass a single blank space as a parameter value using dsjob: dsjob -run -jobstatus -param some_param=' ' myProject myJob Single or double quotes used as shown above produce a syntax error: Invalid arguments: dsjob -run... I've tried omitting the quotes, escaping the quotes, using a single b...

I have a decimal[24,6] value 'D1' and a decimal[20,2] value 'D2' going into a parallel transformer. Within that transformer I have a stage variable 'SV' declared as decimal[20,2]. In the transformer, I set SV = D1 * D2. I then convert SV to a string using DecimalToString( SV, "fix_zero,suppress...

Why can't I compile a job that uses a shared container just because someone else who could be on the other side of the world for all I know has the container open for editing? One would think that shared containers would not be a hindrance to working in a shared development environment! Where is the...

For future reference, the errors above were indicative of an attempt to perform a decimal divide-by-zero. I must admit that there was one more divide operation buried deep in the bowels of my transformer logic. Although the divisor in that case should not have ever been zero, partitioning issues ups...

I'm getting the following error message from a parallel transformer stage: APT_DecimalNumber::analyzeAndPrepare:divisor is 0. followed by: Fatal Error: APT_Decimal::asDFloat: invalid representation in the decimal; the leading nybble must be zero with odd precision. I'm having trouble tracking down t...

It's been my experience that you cannot edit a wrapped stage definition.

If you want to change the stage, it appears you must delete the old version and start from scratch.

Sorry.

Sainath.Srinivasan wrote:Include a transformer in the middle.

Use a copy stage instead of a transformer - your job will compile and run faster.

Tim

Well, the issue does not seem to be dependent on timing... putting in the sleep or wait is not the key. The problem instead seems to be with the way job parameters are being set by environmental variables. I'm initializing a dozen or so job parameters with environmental values through $PROJDEF. Thes...