DSXchange

As timestamp.

I have some timestamps that are formatted with nonpadded month, day, and hour fields ('%m/%d/%yyyy %h:%nn') in the output stage, but are being printed out with padded fields ('03/04/2013 00:00') in the file. Is this expected behavior?

Is there a way to find the last occurrence in a string of a character?

For instance, if I want to get the file part of a file path (/a/b/c/file.txt), how can I extract that?

Is there a function available to convert unix epoch number (eg 1381816859) to timestamp (eg 2013-10-15 06:00:59)?

Thanks for showing the code!

I'll poke around. If i find anything i'll reply to this thread, if any ;)

Thanks

Hi
Could you share the script to deploy/undeploy a webservice?

Right now i have to use Service Directory itself to deploy/undeploy them.


Where can i read up to find out all command-line utilities that are useful for manipulating DataStage jobs or Service Director?

Thanks

Hi I am able to do the following in Service Director: - Create 2 webservices (WSA, WSB) - Create 2 users (userA, userB) - Grant CONSUMER role to both users - Write small C# console app to call either WSA or WSB from either userA or userB. My dilemma is this: I want to set up roles from Service Direc...

I am concerned about bucketing and reordering of rows, since I don't fully understand how DataStage handles these things. What is required to guarantee that the rows coming in from a file (probably BDFS stage, or maybe Sequential File stage) are processed all together in a bucket and in the same (or...

I would like to read in a file and remove the header section and footer section (beginning and end of data indicated by begin-data row and end-data row). There is nothing in the non-data rows to mark them as non-data. Can this be done in DataStage?