DSXchange

Hello I increased the value of EXACTNUMERIC to 36 and even to 56 but it is not working. -I stopped the server , -I increased the value to 56, -I executed bin/uv -admin -regen -I restarted the server -I recompiled and ran the job The same rounding occurs Is it something else that needs to be done? Th...

I agree and I use this principle all the time.

Thank you all for your answers.

Madi.

Hello, I have to extract a large volume of data from some tables, concatenate some columns based on conditions, handle null ( if a string field is null, fill it with spaces; if a numeric filed is null then fill it wth zeros, etc). At first, I thought to extract the data as they are in the table and ...

Hello, Thank you for your answers. Starting from your answers, I decided to go on a solution using aggregator, funnel and sort. In the first step, I draw the design in order to analyze it, to see where it can be optimized. For the moment, I'm working at the extraction part. I'll get back to you with...

Hello, I have in input file that looks like this: id|colA|colB 1|x|z 2|y|t 1|a|b 3|c|d and the required output: id|colA|colB 1|x|z 1|a|b 1|2| 2|y|t 2|1| 3|c|d 3|1| My input is a sequential file and for each id, I have to calculate the number of lines for each id. Could you give me any suggestions in...

I wanted to move the post

I know but I am being ask to deploy it automatically so I have to find a way

Hy,

I exported a server routine into a dsx file and I put in on a Unix server.Now I want to import it into an other project using a command line.

Is it possible to do this?

Under Unix I can not execute dsimport.exe

I tried
dsjob -import project DsxFileName
and I'm getting the error:

No job found to import

So...

Hy,

I exported a server routine into a dsx file and I put in on a Unix server.Now I want to import it into an other project using a command line.

Is it possible to do this?

Hy,

In my opinion the fastest method to parse a file ( for exemple testing the length of the lines ) is to do it in a script.

I wanted to see if my opinion was right.

So, thank you all for your answers

Madalina

Hello, I have a curiosity: I have a script ksh which launches a job control which launches a job sequencer. Before launching the job sequencer I want to parse a file and verify its structure. If the structure is ok then I should launch the job sequencer else nothing should happen. Parsing of the fil...