DSXchange

When you get this error message?
Is it during compilin the jobs existing in the project?
If so, was there any change in permission for either the project directory or for the userid or group?

Put a reject link from your target DB2 stage. It will carry two new fields, sqlstate and sqlcode. These hold the return codes from the RDBMS engine for failed upsert transactions. To trap these values add a copy stage to your reject link, add sqlstate and sqlcode to the list of output columns, on th...

What is the value of the decimal in the source?
Try DecimalToString(InputField,'fix_zero').

Isn't too many same question at same time?
Ramsdanda - The reason been asked is, if you have Database as source stage, you can eliminate the duplicated while selecting by doing a group by.
You can also eliminate by using Sort stage, by assiging a key and Allow Duplicates option to false.

Hi Ramsdanda,
If you explore the options available in the oracle stage, you can find that the Update option has 'Truncate Table Then insert Rows'. There are several other ways too. Try to make a search in this forum as well.

Try to print the rc and check for the value.
Try to set $DS_ENABLE_RESERVED_CHAR_CONVERT to true. There is a ecase opened for the same reson.

Or type 'dsjob' in command prompt, which will give you list of all parameters the usage of each when you proceed with passing each parameter.

Find the full detail of CLP here.
http://publib.boulder.ibm.com/infocente ... 010412.htm
And revert back if you still find any further issues.

Its better to see code is not executing than Itz not working ... Add Loging command and check the director log for what is been passed and what is been executed and what is teh return code. Call DSExecute("UNIX", Command1, Output, SystemReturnCode); Call DSLogInfo("Command...

Oracle_Enterprise_5: Incorrect dboption list; it failed on Expected "," or "}", got: "@", line 1. It is not just complaining about the wrong password, but the parameters and the way in which it is passed to Oracle stage. Do you see any '#' in the encrypted pwd. If you click on view data, will it sh...

When I am in India or Australia, no matter what, I will see almost all the 'Last Post' by Ray.
Whether its Monday or Weekend or National Holiday, no matter what, I ll receive a Blog alert by Vincent through mail.

Welcome to Dsxchange!!! :D

This will allow those records which starts with ".." and with one more character. And rest will be filtered. If you requirement is to avoid those data that starts with ".." use Not like or <>.

Sorry I dont remember what I did to get rid of this issue.
But check if file patter is used, at every end of file and start of next file during concatination, the error occurs.

Consumed more than 100,000 bytes looking for record delimiter

Should refer to the missing delemiter.

I too missed it.
Excellent job Blogman.

I was expecting you photo as well Kenneth. :D