DSXchange

Try this....
StringToDate(DSLink3.Testdate,"%yyyy-%mm-%dd")

Is any thing worked for you?

Check the datatype in the DataStage output column...it might be expecting the TimeStamp..and your output column might be in date type.

Is it possible for you to use the distinct function in the Source when you are getting all these values or do you have specific requirement to do this in transformer stage..

Hi, In one of the ETL job we are getting the Fatal Error as : Fatal Error:Not a list value ;table. I was not able to figure out,what was the exact error in the ETL job. About the job design: Basically we are reading the Data from Database table and doing 6 look ups including Range look up on some of...

Hi all, Can we write the user-defined sql for creating the view inside the odbc stage.If yes means i have done the same thing in the odbc stage. O.S:windows 2003 server Version:DS 7.5x2 Oracle client:Oracle 10g. odbcstage--->copy--->sequential file Inside odbcstage i have given user-definedsql as: C...

Hi, We have installed datastage 7.5 on Windows 2003 server.All the server jobs and parallel jobs are running fine.But the parallel jobs are aborted.And we went and check in the director it was showing the fatal error as: "This jobtype is not currently runnable on this platform Attempting to Cle...

Hi Deepak, Error: "Reject link is not allowed unless an input reference link failure property is set to reject" .Means you did not specified the lookup stage condition correctly.Go to the lookupstage and check the condition.There you have to give it as lookupfailure reject.And take some se...

Hi,

Can u please check whether RCP is enabled or not?

Cheers
ds_sai

hi,
Look upstage will not reject any rows(even null values also),please check whether you specified the meta data correctly or not.

Cheers
ds_sai

Hi,
Please check in the Administrator for the project properties inside that their is one tab called permissions in that check whether user role is Data stage developer or not?

Cheers,
ds_sai

hello sir, Thank you very much for giving this advice to me. As u said i did the same thing,telnet the data stage server.I was able to connect to data stage server using telnet in putty.My o.s is Windows XP professional and the ssh server is cyberspace.com.Could you please guide what is the next ste...

Hi,
Thank you,I really do not know how to see and do with ssh.Could you please guide me how to proceed and what needs to be done from my end?



Cheers,
ds

Hi sir,
Thank you,I really do not know how to see and do with ssh.Could you please guide me how to proceed and what needs to be done from my end?



Cheers,
ds

Hi all, My O.S :Window XP Professional Datastage: 7.5x2 I am having some free shell account in some public site i.e using ssh. Can i connect that ssh shell to our data stage server i mean like telnet ?Is it possible means please let me know?If anyone have an idea please share with me?Thank you very ...

Hi all, Thank you very much for all.I resolve the issue with the help of following thread in our forum by using search. http://www.dsxchange.com/viewtopic.php?t=102175&highlight=Datastage+Repository+Interface Once again thank you very much for all,for giving this kind of valuable help by spendin...