DSXchange

I am trying to implement something similar to the following logic which works in Sybase. The metadata is identical.

IF <Condition>

BEGIN

Sql1

END

ELSE

BEGIN

Sql2

END

Is it possible use a conditional in the connector stage to execute a different query based the value of a variable? The BEGIN WORK clause is throwing an error when I try.

Have a requirement to write a file name in the MQ.RFH header and do not see any option to accomplish this. Is it possible using the MQ stage?

No it's not. There never has been, and never will be, the possibility to promote warning to fatal. There are too many implications. Ray I'm referring to the warning being a bug not the promotion of a warning to fatal. Every other Sybase error is fatal. It makes no sense that a deadlock that was kil...

No, this option is specific to the stage so it does not affect any other aspect of the job. Not according to our testing. We recreated the deadlock with the check boxes in both states and what should be a fatal error is a warning in both cases. What compounds the problem is that we cannot promote t...

Sorry, but you enabled an option that says 'treat errors as non-fatal' and then you're wondering why your normally fatal error was logged as a warning? :? Yes, it is due to this that the job is not aborted. Uncheck that option. These settings apply to the code in the before and after routines, no? ...

Sorry for reviving an old thread but was this resolved? I encountered the same scenario last night where a deadlock was killed by the RDBMS with a successful job status.

Sorry for reviving an old thread but was this resolved? I encountered the same scenario last night where a deadlock was killed by the RDBMS with a successful job status.

Is there a date format that will handle a string in 1/1/2009 or 01/1/2009 or 1/01/2009 or 01/01/2009 format and return a consitent result of 2009-01-01. Year will always be YYYY but day and month may drop the leading zero (source).

I have a value of Mar 23 2009 12:00AM on a sequentual file that I need to convert to 20090323 format. I'm wondering what the best approach is. String manipulation or date conversion functions.

Thanks in advance guys.

I'm encountering a strange problem calling a Sybase stored procedure in the stored procedure stage. The procedure is returning a result. When I excute the job I get the correct number of rows but all NULLs are written to the file. If I send the result set to a peek stage it shows the colums headers ...

Is it possible to handle differing column layouts returned from a Sybase Stored procedure call? For example say my rowset contains header, detail and trailer records with differing columns. The simple answer is to modify all the procs to return only detail records and handle the header and trailer i...

Mike wrote:Also check that you don't have a message handler masking the default behavior. The job log will tell you about Attached Message Handlers (if you have any).

Mike

I'm not using a message handler. I'm at a loss.

Doesn't that depend on your "Reject Mode" setting? From the docs: Reject Mode Allows you to specify behavior if a read record does not match the expected schema. Choose from Continue to continue operation and discard any rejected rows, Fail to cease reading if any rows are rejected, or Sa...

when the option Final Delimiter = end then it would look for the "end" after the last column you mention in the columns tab. if it does not see it, would report a warning in the director and the import would be unsuccessfull..that is what my experience reading sequential files.. That is e...