DSXchange

Hi NaveenD,

The same holds good for UNIX. Actually I picked these tips from working on UNIX

Glad that I could be of help.

Hi Shivan, I m not using the sorting at all. Passing unsorted input data to an Aggregator, might work for a small number of rows, as Aggregator internally sorts it and then applies the aggregate functions to the data. However, it might not work in case of a large number of rows. Hence it is highly r...

Hi NaveenD,

One more tip along the same lines. If you want to append to an existing file and not overwrite it, use >>

Hi NaveenD,

Try redirecting the output of the command to a flat file
Hope that helps.

Hi NaveenD,

You can change the READONLY value from "0" to "1" and it should work.

Hi Kaps, Like you already noticed. UNIX uses "/" (forward slash) in the path. dscmdexport /H=server /U=username /P=password projectname /home/username/filename.dsx In the UNIX prompt, try to go to the specified file path and see whether the specified directory exists and you have permissio...

Hi NaveenD,

Did you by any chance make the project read only while exporting ?.

Hi Sanjeev,

Since the time interval for polling is 20 seconds. I feel that it can be best achieved at the database level using techniques like Triggers etc.

Hi Bob, On a side note, the column being complained about is also one that I didn't want in my input to the filter, but DS insisted on supplying it. I finally gave up and accepted in on input, even though I don't use it. If you dont want any particular column that you are reading from the input, you...

Hi Anu,
as Craig pointed out in one of his earlier posts.

Hi Sri,

There is a small error in your field transformation. The correct tranformation to achieve your output is

Hi Sai,

Give a person a fish and you feed him for today. Teach him finishing and he will feed himself for lifetime.

That was a really great proverb and so apt for the situation, but there's a small typo "finishing"

Hi Kim,

Thank you very much for the link. Somehow I missed it in my search, sorry for the trouble.

Hi Kim,

I couldnt find the topic which contains code to extract metadata from DS_METADATA posted by ray. I did find a link in one of the posts, but it says that the topic no longer exists. Anyway, thanks for your help.

Hi Kim,

Either that or you could save as comma delimited

Could you please tell me how to save the metadata in a comma delimited format ?