DSXchange

DSguru2B wrote:Did you add the entry in the uvodbc.config file in the project directory?

Yest i did....The DSN created for DB2 is working but for the SQL server is throwing up the error

thuan wrote:You also need to add the entries in uvodbc.config in the project directory.

As I said earlier i did add an entry there......

hi , I am rtying to set up a dsn for the MS sql Server that in a different box from the DS box.What i have done is i have create a new ODBC set up on the odbc.ini files also i did updata the uvodbc.config file.afetr that i restared the engine.But the new DSN did not appear.So is any thing else i nee...

Forget about the error in Red. Its not an error. The one in blue and green means that your source and target datatypes are not identical. If they are not, you need to explicitly do datatype conversions, using either the transformer functions or modify stage. Do an "search on all terms" on...

ray.wurlod wrote:Try Decimal(12,n) - your source number is unsigned, and DataStage can be finicky about having space for the sign. ...

I tried with the Decimal 12 i get an error numeric value out of range...
is some thing else i can do..Pls help me out....

Let's review. It used to work. Now it doesn't. Nothing's changed in DataStage. Some DB2 patches have been applied. WHY do you think there's anything you can do in DataStage to remedy your situa ... As you said it is the problem with the service pack..The service pack the we installed will make the ...

Hi, I having an issue with my DB@ plug in not working for pas two days...It was working fine two days back...There was some patches added to our DB2 installs after that it did not work when i try to connect it just hangs there...I itred stooping dsengine and restrating there is no result..I have my ...

the one i marked in red i don't have any dir called that...

the one i marked in blude i have no idea about that....

The one i marked in green i am not doing any decimal to string conversions

Pls help me out.....

Click the More button to get full output from the compiler. Read it carefully; try to understand the cause. There is usually a lot of useful diagnostic information in the compiler output. If you do ... this is what am getting from the more Output from transformer compilation follows: ##I IIS-DSEE-T...

chalasaniamith wrote:Nothing wrong in your job.Just close your designer and recompile it it will work.Same thing i did it worked for me.If same thing repeated just ask your admin to restart your project.

I did what you have said still the same....

I have a parallel job which is just a data to data transfer.... When i complie that job it says error in compling the transformer..but i matched all the columns..I am not having nay stage variable..i am not creating any surrogate key..The partioning is kept to auto...It looks weired because there no...

PIC 9(10) COMP-3 won't fit into an int32. If you need integer you will need int64. Or a decimal data type with sufficient precision. ... So i tried with the decimal 10 as of what there in the source i get an error saying DBMS.CODE=-99999, SQLSTATE=22003, [IBM][CLI Driver] CLI0111E Numeric value out...

Check out Brad's last reply here. . Make sure you converted the COBOL datatypes to DataStage datatypes correctly. Its o ... The type i have is PIC 9(10) COMP-3 that what i have in all of my decimals also the converted data type is decimal 10...also in the target i have it as integer....Brad'd thing...

What are you doing in the job? Any sort of arithmatic operation? Maybe you have defined a column as int at getting a value suitable for BigInt. Possible? In the Arithmetic perspetive i have only decimal values in the source cobol file.I am not really doing any data transfer..it's more of like 1-1 t...

Hi,

I am doing a Cobol file to DB2 table job in which i am getting an error called Arithmetic overflow then after that there is no more infor for me to debug.I presume it's a database error is to to do with long type..If any body can help me out in debugging will be great....