DSXchange

In the end we changed the code so that the transform of the date was performed in the oracle extract, instead of using the DS oconv(iconv) processing. No ideas why the original situation occured, but this solution solves the issue


thanks

I will ask the dev guys to try that


thanks


chris

We are migrating from a 7.1 server system to 8.1. We perform the following transform on a birth_dt column, ereplace(Oconv(iconv(ClmHdr.BIRTH_DT, "D-DMY[2,A3,4]"), "DYMD[4,2,2]"), " ","") an in 7.1 for all dates below 1930 its transforming as expected, eg 1923....

I have tried to look if there is a similar issue so I do apologize if this is a repeat. We are migrating from 7.1 server, onto 8.1. We are testing the job in both environments to ensure consistency, but for one particular job, the data is getting sorted differently. The job is as follows input file ...

Thanks for that, though unfortunately I have been told that we cannot have FP1 installed. Might have to see if just that patch can be installed on its own.


thanks for the info


chris

Hi, I have just had v8.1 installed on my laptop, and since installation I cannot load up 7.1 designer/director etc. I have the multi-client manager, but I understand on 8.0 there was a browse button on the app, to allow the addition of the second version of DS on the same machine. My query is, how d...

I have a sever job which reads in a flat file, then processes through a transformer before loading to an oracle table, with update action of insert rows without clearing. There are two ways of running this batch. #1 - there is a sequence job that is scheduled and gets the file off a server, then cal...

Was afraid that was the case, though trying to solve this issue is a problem. Had thought about bouncing the system, but we wont get that past the change approvers I fear.

will have to wait until all processes we know of have completed, and then see what unix thinks is still running.


cheers

All, at our installation, we have a live server and a dev server. Live has 5 licenses. Our jobs are all scheduled via Director. We set up a schedule for the main batches and they start most mornings at 4am, then run until all input files are received. We have 1 production user. The problem is, this ...

thanks for that, tried that and it appears to have worked.


appreciated


chris

thanks for that, tried that and it appears to have worked.


appreciated


chris

I have a server job in the following design Oracle OCI --> Trn --> Aggr --> Trn --> Hashed File The data extracted from the table has a policy id and a coverage. 1 policy can have many coverages, so the data extracted looks like this Pol Id Coverage 1 BAD 1 BST 1 CAD 2 CAD 3 BAD etc. upto a maximum ...

Cheers for the help Ray, will email support with the problem.

Will let you know if they can resolve this issue.

cheers

Ray,

added comment, didnt cause the compile to fail, also number of ends matches the number of Ifs.

got a new version of the routine to compile and work, so not a problem,
but an annoying glitch when it occurs.

Its a transform function.