DSXchange

HI Arnd, Not sure if you ready to use intermediat stage/ files/Jobs, I gess it could be done through Datastage, if you are ready to pass the total count and average of the value that you need to find the SD as parameter. If you able to find the following for each record (x - pAvgx)*(x - ...

You can look for the full message for the column name. Perhaps post the same. Previously you might have read with compatable datatype and length which probably might be less when compared to the available. But now, the data in database migth be varied. Your full message can help more to identify the...

Are you reading it as number and converting it into Varchar later on?

So you need to workout in you script to make sure, the paths refered as the absolute path.

You can check if ascii value for each character lies under the range of nubmers or '-'.

Welcome to Dsxchange!!! :D Some hints. Prefer the corresponding Plugin for the database. You can try to stream the read and load process. Either based on the date, if its a dump or based on the division of key. You can increase the Array size. Rather than having Transaction size as 0, have some peri...

What is the size of cumulative amount of both the files? Hope you might have checked both /path/xx and /path/xx/ds_temp for availablility of space.

Is it a compilation error or runtime or error during import?
Is Balanced_Qty not a decimal field?
BTW: Are you adding up some extra rows or columns in the transformer?
Were you able to view the data from the sequential file?

Disable the RPC. IF you convert ustring_from_string() from the input stream, it should do lookup. At a worst case, write into a intermediate sequential file after the conversion. It will be useful for the verification as well.

Check if conversion of unicode using the existing inbuilt funciton works during lookup.

What is the version of DataStage that been used?
Try using tnsping to the Oracle server. Try to import metadata from using manager either by plugin or using Orchestrate.

Is this related to the other post of yours regarding timeout? If not, can you explain more on what is the error you are getting.

If you are trying form Adminstrator window, try to chagne the defalut Timeout settings available.

Hi Hemanta, Welcome to DSXchange!!! :D I belive that, its metadata that you have given as INPUT and OUTPUT. 1)Map Out-a to Field-a. 2) For Out-x If Field-b-typ = 'x' Then Field-b-val Else If Field-c-typ = 'x' Then Field-c-val Else If Field-d-typ = 'x' Then Field-d-val 3) Out-y If Field-b...

Do you get any more errors if you expand the pop screen?
Check if odbc settings been configured properly.