DSXchange

When I am compiling it say : Compiled with no errors But then the Test button does not get bold. So I cannot click and test it. Moreover I tried to build a transform routine which worked fine with this code : FileName = Arg1 FilePath =Arg2 CurrDate = Oconv(Date(), "DMDY[2,2,4]": @VM : &quo...

When I am compiling it say : Compiled with no errors But then the Test button does not get bold. So I cannot click and test it. Moreover I tried to build a transform routine which worked fine with this code : FileName = Arg1 FilePath =Arg2 CurrDate = Oconv(Date(), "DMDY[2,2,4]": @VM : &quo...

Ahaaa. I got my BIGGEST MISTAKE. I didnt notice by mistake, I have posted OS-Windows in my question. But its Unix. Moreover stupid enough that I am using DOS command in the subroutine.

Extremely Sorry guys. So what modifications needed now ??

Yes kris I have tried in Manager but I can only compile and not Test. Dont know why...

May be becoz of the RETURN ??
Because in last line of subroutine posted its Ans=.......
And in bottom tab of routine dialog box its just RETURN.

So may be its not returning the value properly....

Ok I have tried but its creating the file with name :

test.txt

No renaming is done and no date is appended to file name.

Is the subroutine given by DSGuru good. Can someone check it please ?


Thnx

Thank you so much. Hope i should be able to get it now.

Thank you everybody for your time.

Can you please point out where I could be making the silly mistake if I am using the above subroutine and above mentioned details while running the job. The other option of using Macro I have tried following way in the sequential file stage of output: test_#DSJobStartDate#.txt But i have a problem i...

Yes I am using the same path in both. There are no different parameters used. What kriss suggested I have tried but getting error. And yes chulett basically I want to create an output file with timestamp appended like test_08152006.txt. So my question to you is do I need to first create a file test....

No I am getting error. Cannot create file. See in Job properties I am using Parameter Value FILE Path/test.txt Now I have a built above subroutine under name testsubroutine So In job properties I am selecting this as after subroutine and in its input value I am using #FILE# Now In sequential stage i...

Ok I tried this to build as an After job subroutine Now its getting compiled without errors. But how shall I include in the job ? I have selected the subroutine as after job subroutine in JOB PROPERTIES. Then in input value I have used file name for eg : "test.txt" Then in Sequential file ...

If you are doing a look up then why are you unchecking the mark in hash file ?

Confused... What actually are you doing ?
Look up is not done or something else ?

Thnxs everybody. I got it . I didnt knew there is inbuilt available. So was trying to build a routine. Trying to act smart unnecessarily

I dont simply want to down case the string. Please see my question:

I want the first letter of each word to be in Capital letters.

Hi Everybody,

I want to build a server routine which will give me output like:


Input Output

MEL GIBSON Mel Gibson

TIGER - WOODS Tiger - Woods

Please share your experience

Thnx.