DSXchange

What do you mean by "dynamic"?

If you want the previous row to be available then you must set transaction size and array size to 1.

pandeesh wrote:But i need to use only transformer for removing duplicates.

Why?

There is nothing out of the box. It could be done easily with a job sequence scheduled using the Information Server scheduling service. In this case there would be no entry in crontab.

If your client is operating in that language you can use the character directly (if your client NLS map in DataStage is correct). Otherwise use the UniChar() function for the Unicode code point of the character.

Look again at the error message. LONG is not the same as LONG VARCHAR2 or LONG NVARCHAR2.

You can program in whatever else you like. Most people find that the "current flag" and the dates are sufficient.

You'll certainly see a marked improvement in the startup time of jobs. The total execution time of jobs is subject to far too many variables to make any deliberative statements about the effect on performance of any single measure. It's a definite maybe. You can state with confidence that fewer file...

... and the virtual table can be based on a sample of the rows in the base table.

DataStage TD Connector includes some clever code that allows fastload to append.

Well, I began with the intention just of mentioning the special files.

Clearly permissions aren't the problem. Can you perform a UVFIXFILE scan of the file?

Some special hashed files (for example system tables like UV_SCHEMA) have a read-only bit set in their file header. You will never be permitted to clear these, or even to edit them inappropriately (via DML), because doing so would break the engine. Which hashed file did you try to clear, and what ar...

I would like the ability to mark a thread as unread, or flag it in some way, so that I can return to it later if I am busy during the "now" that I am reading the new posts on DSXchange.

Although it's not documented anywhere, I believe that the alphabet string must either begin with, or contain, at least one alphabetic character. I can't remember which.

There are two conventions when quoting strings that contain the quote character - either double them or escape them. So if the source data were ABC"",""EFG as you stated, the two possible results are "ABC"""",""""EFG" or "ABC...

You could start by explaining what "not working" means in this case and any error messages that are getting. You might also advise whether you're using a 32-bit or 64-bit operating system because that, too, will make a difference.