DSXchange

Firstly, check the size of your match groups on the match output report in the data folder of the project. Go to the bottom of the report where this information is held. They should be less than 100 although it depends on the data, machine size etc etc. You are looking for a very large maximum group...

Have you tried recreating the target file?

QS uses the rule name as part of the column name, so if you are using file definitions based on the ruleset that you copied they will not match up to the rule set you are using now.

Hope this helps.

Try using a Stage Variable to hold the Header Date and in the derivation check for @INROWNUM = 1 or record type of Header so you only update the Stage Variable once. The Stage Variable can then be used to populate the column in the detail records. You may also need to control the parallel processing...

The "not a valid number" problem is likely to be caused by a european number in the MProb and UProb parameters eg. 0,1

If you open the export file in notepad and search for MProb you will see if this is the problem. You can edit the file if you wish.

I've had a similar problem here.

My problem was code page related. If the code page of your source, ds job and target are not aligned you tend to get this sort of problem.

Try utf-8 as your ds job code page or nls setting and see what happens.


Hope this helps!

I now find that it is $DS_PXDEBUG=1, you have to define it as an environment variable and then include it in the job .....

A warning message appears in the log to show it is switched on and logs appeard in <projectdir>/Debugging/<jobname>

Thanks for responding, Ray.

I found out eventually through support that the env var is PX_DEBUG=1

I also discovered that there is a unix core dump file in the project directory in addition to the DS dump.

Guys,

I am trying to get DS to produce a dump when it aborts.

I understand that by setting DS_PXDEBUG=1 (True) and APT_DUMP_SCORE=True this should happen, but it is not.

Does anyone have experience of doing this that they could pass on?


Thanks,
Bob.

What I would do is to run a word investigation stage over the name column. This will produce several files one of which is effectively a .ucl or .cls file. It looks a bit like this: AAAAA AAAAA ? The problem is that for a name like FRED SMITH you will get FRED FRED ? SMITH SMITH ? I imagine you want...

As I understand it, Autosys needs to be a member of the same group as qsadm. Your unix admin guys should be able to sort it!

What match comparison are you using? Char, I suspect. Trying using Uncert with param 1 set to 800.

Also, how many records are you matching? With small number of records match scores tend to be lower because of low frequency values.

hth
Bob.

I have a job which stores data in an oracle table and works fine with European data. However with double byte characters the job aborts with the error "ORA-01401: inserted value too large for column". My question is when working with double byte characters is it necessary to double the siz...

It's not quite clear to me exactly what you're doing with the stage variables in the stage, but here's one approach you can try: Assuming you can detect header, detail and trailer records which might be a little tricky as they header and trailer appear rather similar!, here's the logic: Detect the h...

I'm not sure if I undertand correctly, but I think you're using a string like "ABC DEF" as the delimiter of the main string. If you are, field my not return the results you're expecting. Here's an example: String = "aaaa123bbbb123ccccc123dddd" Ans = field(String, "123",...

Sorry, good question!

Yes, you can do that that or edit the .imf file.

Bob.