DSXchange

The entry in tnsnames.ora is correct,i have checked it.
I am able to connect through Oracle Sql plus,I checked all the parameters i am passing in the Oracle Enterprise stage too.
They are also set up correctly.

Yes,they are set up correctly.
I am able to access another oracle server but not this one.

Hi, I have to connect to server abc,using usid :xyz and password :abc. I have an entry in the TnsNames.ora file for the particular server. I am able to login using Oracle Sql plus,but when i enter the same details in Oracle Enterprise stage as remote server :abc,user id as xyz and password as abc it...

Thanks Tom,that gave the desired result.Thank you.

Hi , I have a String coming in as mm/dd/yy i.e 04/15/06 now i want to convert this string into another string of fotmat YYYYMMDD i.e 20060415. I am using a transformer stage to do the conversion. i tried doing StringToDate, it is giving the output as 1906-04-15. How do i get output as 20060415. Thanks

Thanks Ray.

Hi, I have a requirement where i have to FTP a Zip file(.zip) from a remote server then Unzip it into .txt file. Can we use FTP Enterprise stage to FTP a zip file. when i have done a search it was clear that FTP plug-in does not transfer zip files.Is this the case with FTP Enterprise stage too.Can s...

Hi, I have a requirement where i after the Job is run successfully ,I have to compress the file and Archive it. Right now i am just using a Execute command stage to Archive the file by using mv #Path#/file1.txt #ArchivePath#/file1.'date +"%Y%m%d"`.txt without compressing it. How can i comp...

Hi, I have a sequence where in I have 3 execute commands to FTP 3 different files from server to the datastage server and when the files are FTP'd i have 3 different server jobs to be executed(where in each one of these jobs uses 1 file each).But i want to design sequence in such a way that if i get...

Thanks guys...its working now

I need to convert mmddyy format to mm/dd/yyyy

071007 -->7/10/2007

I tried stringtodate(date,'%mm%dd%%yy)-->out result is 7/10/1907 but i need 7/10/2007

Thanks in advance.

Raj

Thanks alot Ray,that worked out absolutely perfect.

I Even tried D/MDY[2,2,4] in the format parameter.
But even that returns a value 1,When i pass Parameter for the TheDate field as 'Nov 20 200'.

As Suggested by Kris,i have passed the value 'D/MDY' for the parameter value Format and Date parameter as 'Nov 20 200' ,this gives an output of 1(which means the date is valid).
But my requirement is if the format of the date is other than mm/dd/yyyy than it should say,invalid date(i.e return 0).

I am sorry,I had tried the below routine before posting this question FUNCTION IsValidDate(TheDate, Format) If UnAssigned(Format) Or IsNull(Format) Or UnAssigned(TheDate) Or IsNull(TheDate) Then Ans = @NULL End Else Test = Iconv(TheDate, Format) Ans = Not(Status()) End RETURN(Ans) But when i test th...