DSXchange

you can use the oconv format function for decimal conversions.

Oconv(1234.567, "MD20T") will give 1234.56 without rounding off. Replace '2' in MD20T with the number of decimal places that you want in your output.

We have done the same Craig...waiting for their reply...

Thanks for your help!

Hi,

When we set the $DB2CODEPAGE vlaue to 1208, we are able to successfully run the job, but the special characters are not sent to the output correctly!!!

Can anybody suggest what needs to be done in order to read a Latin-2 data in DataStage?

Thanks.

Hi Craig, These are the steps followed to set the codepage at the job level. Add the environment variable $DB2CODEPAGE in the job parameters and set the default value as 912. From the NLS tab of the Db2 stage, select the option IS08859-2. This is because, the AS400 library from which we are trying t...

No Ray, this happens even in other existing projects. To add more information from our analysis, the source database codepage is Latin -2 and the DataStage default is Latin -1. We are trying to set the codepage corresponding to Latin-2 which is 912 to the environment variable $DB2CODEPAGE in the job...

The files do have data. From more analysis, when I try to query just a single column which has numeric data, I am able to see the contents from the same file/AS400 library. The issue is only when I try to view data from a character column. I get two kinds of error which keep changing at random. Eith...

I am extremely sorry to have confused. Since the original job was aborting I designed a new job with just the three stages and the message in my last post comes when I view the data in the Db2 stage itself. The error message that comes in the job log (director) for this simpler job is testjob..Trans...

This is the error message shown when I try to view the data, if it helps

testjob.DB2_UDB_API_0: /?( and one blank space)

It is a very simple job.

DB2 Stage --> Transformer --> Sequential File

Even when I try to view data in teh DB2 stage I am not able to see the data properly. Sometime it throws a DataStage repository error message and at times it shows junk values in all columns.

Hi Chulett,

There is no other error message even when I reset the job. It just shows this message. Any clues on how to attack teh problem?

Hi, I get a fatal error when I try to run a DataStage job connecting to a AS400 file. The job is trying to read from a AS400 file and write to a hashfile. The error message is not very clear. It shows HashfilestageName.IDENT3: |-100|. This error message comes only with a new library file created in ...

Hi Sainath, after you put that question I just noticed that the line termination was Dos style. I changed it to Unix style and it works fine now.

Thanks!

It is comma for both the input files.

Hi, I am trying to use the Merge stage for the first time and I am not seeing expected results. My first input file: 1111,aaaa My second input file: 1111,bbbb and my ouput file is : 1111,1111,aaaa ,bbbb whereas what I expected was 1111,1111,aaaa,bbbb what could be going wrong? I have set the propert...

Hi cpppwiz,

Thanks for the information. I think the option you have provided is for enterprise edition. But mine is a server edition. Any idea on whether the server edition 8.0.1 will go well with db2 9.5?

Thanks,
Gaya3