DSXchange

There is no LATIN 01A inthe drop down list. I try changing the NLS at the job lebel but did not help. The error says: from codepage UTF-8 to Unicode. We are using Netezza and it does not accept Unicodes when loading to the database. The address is a VarChar, does anyone have any suggestions how to h...

The stage this is happening is Data Rules.

Data Rules does not have a way to change the the character set. I will try to change at the job lebel and see...

Hello: I am getting this type of warnings: Data_Rules,1: Invalid character(s) ([xBD]) found converting string (code point(s): 906 N. 23RD [xBD] STREET) from codepage UTF-8 to Unicode, substituting. When I look in the database the address shows as: '906 N. 23RD ￜ STREET' I tried using the Conver...

I started to use SCD and it was extremely slow and buggy seem like. I started to go a different route by using transformers. Someone had a SCD alternative in a server edition. I tried to build similar process in parallel but there was lots issues I run into. First let me describe my job: XRefTbl Tar...

Got it resolved.

You have to pick at least one rule definition and bind the varialble.

Once this is done than the output page gets populated.

Ray,
The Data Rules is to use within a DataStage job to validate the input data.


The rules are working in IA.

I have not applied any rules yet however, first all the columns need to show up in the Data Rules Editor and that is my issue...

I appreciate any advice.

I am also getting this error message when trying to create a new job and adding a new Data Rules Stage. After the input and output links to the Data Rules have been established and click to open the Data Rules Editor I am getting this error: '<', hexadecimal value 0x3C, is an invalid attribute chara...

Hello Friends, I recently started incorporating the QualityStage Data-Rules Stage within DataStage. I was able to get one DataStage job to run successfully using the stage. I then wanted to develope another job using a different table and datasets as outputs but can't seem to get the Data Rules stag...

Thank you Ray:

It appears that just needed to tweak the command to bellow and now works:
Thanks Again!
Learned some great lessons... :D

Thanks ArndW and Ray :D CCYCONV run after compiling and cataloguing, however is now saying: Output from command ====> OPEN FAILURE ON CCY_CNVRT_RATE FILE. Is not able to write to the hash file which is in the H:\IBM\InformationServer\Server\DSEngine\ folder. Do the hashfile need to be now in the BP ...

CCYCONV is an in-house program created long ago, much before I started working here. It is a universe program that does some calculations with rates and writes it into a hashfile.

Does it need to be compiled?
Can it be compiled?

Thanks for your help!

Thanks for the response Ray.

When I run these commands I am getting these errors:

command: BASIC BP CCYCONV

Unable to open "BP" file.

command: CATALOG BP CCYCONV LOCAL FORCE

No record found in the VOC file for "BP".

I was able to run the program from the command prompt like this:
Does anyone know why DS is not able to run it?

We are transitioning from 8.1 to 8.7 and the following command run in 8.1 using the Execute Command but now it does not run in 8.7. Here is the command: cd H:\IBM\InformationServer\Server\DSEngine && .\bin\dssh CCYCONV it first said that CCYCONV was not in the VOC, so I added it. it then sai...

Ray,

Thank you for your help.

I appreciate it!! :D