DSXchange

An actual LONG column? Yuck. Oracle doesn't even support them well and they are long gone, no pun intended. ETL tools don't typically support any kind of "LOB" well and while there are some ways to work around that with a CLOB, I'm not aware of any such viable mechanism for a LONG. I'd sug...

And then *if* you still need to remove the quotes, do so after you read it.

Pretty sure we understood all that and what Ray posted still stands regarding how they could be executed. However, still curious about the "and then what?" part of the question. Sure, you need to "run" them - but then what? Where does the output need to go?

I would involve your official support provider at this point, see if this is any kind of known issue with that O/S and if there is a patch available. The last 7.x version before 8 was released was 7.5.3 from what I recall, is that the release you are running?

sandeepgs wrote:use the modify operator to specify a value to which the null should be converted

That or don't alias the column to a new name in your sql.

No, while CPE_KEY may very well be non-nullable, CPE_ID is 'derived' and thus assumed to be nullable.

It is not possible to leverage any incoming row data in the 'before' or 'after' SQL tabs.

What database? Have you asked your DBA?

Not always possible as your source must be static and repeatable. When it is, you need to code that ability into your jobs. At a very high level, you need a mechanism to track the most recent commit point and in the event of a failure, a constraint can be used to only pass rows after that point / re...

Does this happen just to you or to everyone that connects to that server? Did it work at one point and then stop working or has it never worked? What is your client O/S? What first comes to mind is an old problem with "Service Pack 2" for Windows XP, the advent of SP2 broke some things in ...

Index()

That's the way rejects work in the Server product. You can capture rows that were send down a link and (essentially) 'come back up' when they are rejected by the target. There are specific link status variables to check for these situations or a generic reject link will do much the same. If you are ...

No, from the Transformer to some other structure, like a flat file, wherever you want to write the reject. It's also important to understand that the reject link must be ordered after the main link but that will happen automatically for you in this case.

Not sure I follow. A colon inside quotes is not concatenation but just a colon and you seem to have quoted it correctly: ':30012 -run '