DSXchange

The "REINDEX ALL" only applies to the DS Engine and that is not where your problem lies. I would certainly talk with the system administrators about what they did; it does seem to have affected your repository connectivity. What error do you get when you try to login to Websphere via the web client?

According to the Docs, only Oracle 10.2g is supported for the repository.

With Version 8 the metadata repository is not longer exclusively within the DS Engine - and your error message indicates that something has changed with your access rights to the repository. a) What database is your repository in? Is that database up and running? b) Has someone changed the Websphere...

At version 8 the IBM Information Server Planning, Installation, and Configuration Guide documents most aspects of the installation including the database dependant ones. Those items that aren't covered can be read in the Connectivity Guide for Oracle Databases . What is your repository going to be?

Why don't you post the actual error so that we might attempt to assist?

No, DS will not have issues due to this change.

No, the warning will always occur and you need to create a job or project level handler if you wish to deprecate/demote or suppress the warning.

I was guessing at the sed command. Please the man pages on sed to see what mistake I must have done with the first part; most likely I chose the wrong octal code for the FF character.

This is a good example of why you should try Search ing before posting. This issue has been around for a long time and every single developer who has used floating point columns has seen this message in the log files. It comes because internally the EE product does not fully support the complete ran...

Suresh - I am going to give up soon; I don't understand what you are doing or saying and it seems that you haven't done what I asked, but are posting other output. Please do one thing - if your input column DSLink4.test1 is of a number type then please do NOTHING except this derivation to a VarChar(...

I'm no sed expert, but you could put in

i tried with decimaltostring function, it is returning zero values... You are doing far too many things at the same time to debug your problem. Start with a simple test to check the DecimalToString() function. Once you have converted your DSLink4.test1 column from decimal to a string then your STR&...

The extra character is a @FM character, which you can convert to a carriage return with CONVERT(@FM,CHAR(13),YourString).

Suresh - try a test job that outputs your DecimalToString along with the original decimal to a test file and experiment until you get it working. Nobody here can magically solve your problem until you are able to successfully convert your decimal to a string. It is usually useless to post a "it didn...

Put in an explicit DecimalToString() function and see if it works.