DSXchange

kcs, I like your suggestion, but if you stick with DW conversion and an integer you can make your logic simpler, this assumes you will make your order go to the Friday before a weekend, see: StageVar "DW" = OCONV(Date()+30,'DW') StageVar "DWCorrection" = IF DW >5 ...

Parag, were you looking for advice on how to do this or were you looking for a solution? You now have the information you need - you can get the numeric day of week with the OCONV(juliandate,'DW', so if you want to handle Friday in addition to Sat and Sun you would change your condition to read ">4"...

...##W TBLD 000000 18:03:25(003) <main_program> Error when checking composite operator: Output from subprocess: Couldn't change directory to /tmp: No such file or directory ... Do you have a "/tmp" folder with write/read access for your user? Have you problems only with this transform or any transf...

You would use the OCONV function and the 'DW' conversion to get the DOW with 1 being Monday.

ravij,

when you use a job parameter you need to use #ParameterName# in many places where a constant string (as opposed to a function/routine/variable) is expected and this is what Ray referred to.

There are many ways of doing this and the optimal one depends upon the type and format of your source and where you are doing this comparison. How do you want to add a month? Add 30 days or take the current date and change the month part. If it does fall on a weekend, do you want to take the Friday ...

Hello Manish,

the export facilities are all windows and client-based. There is no dsexport available on the UNIX server side. You would need to trigger the export on the client through the manager or the command line and then copy the resulting .DSX export to UNIX if you need the file(s) there.

What Ray is stating is that if you have 2 processes write to the same sequential file at the same time you will most likely get corruption. Are both of these writes occurring in the same job? If yes, you need to look at the design to ensure that the file is first overwritten with one record and then...

You would need to do quite a bit of programming, either in C++ for a pure PX job or in the Server BASIC language, to implement functionality of this scope. If your structure file is well-formed it can be read and parsed and then a PX schema could automatically be generated for each type of incoming ...

Somewhere inyour sequence a DSAttachJob() was called and it did not return a valid handle. Could it be that the job is a multiinstance one and that you have specified an running instance name?

I can think of a couple of different approaches to this. But it does come down to how you want to identify the different formats. I would use an approach that reads each record in as one long string. If your files have column delimiters and variable length columns; then perhaps you could use a combi...

Have you recompiled the job on the new system? It looks like the generated transformer stage code is not present.

Have you checked to see if the problem is happening in your PX transform stage or in the pivot stage? It might be because the conversion isn't working correctly in the PX stage.

1. Urgent requests need to go to your support provider and don't belong in this volunteer forum. What is urgent for you is not necessarily urgent for anyone else. 2. Please post in the correct forum, this is for FAQs and not for general questions. 3. Please use the search facility, your question has...

I just wrote a test job to compare the relative speeds of generating a single VarChar(32) column and filling it with the constant value of "Test" between using a Transform and a Column Generator. After several runs of 5 minutes the average speeds worked out to Transform Stage- 515,463 rows per secon...