DSXchange

My output should be in MMDDYYYY format. But I'm getting YYYY-MM-DD.

I have changed my default to %mm%dd%yyyy.

Do I need to change any other thing.

Hi,
I'm getting output values. I have changed the default format to %mm%dd%yyyy.
But output is still in the format YYYY-MM-DD.
I don't know why?

Thanks for reply Nripendra and Ray. I tried this but I didn't get the output. I gave specification : date2:date = date_from_string [%yyyy%mm%dd] (date1) date1 in my input column varchar 8. date2 is output column as datatype DATE. there is no output from modify stage. Also job is not aborting and no ...

Hi,
I'm having date column in YYYYMMDD format. This is Varchar(8). I need to convert it to MMDDYYYY in modify stage. I don't want to use transformer. what is the specification do I need to give?

Is there any other way to do this without using transformer?


Thanks,
Sasikala

Hi, I need to write a fixed width output file. I have converted all the column datatype to CHAR. Job is running fine without any error. But All the fields are left justified and suffixed with blanks. They should be right justified and prefixed with blanks. I can pad spaces in front of all the colmns...

I'm using a stored procedure stage to call oracle stored procedure. I have given the properties as below Stored Procedure Statement : call #DSSchema#.PHR_UPD_URSULA_MASTER(:1) Stored Procedure parameters : RUNID RUNID is the input column name I'm getting the error : The parameter (RUNID) is not asso...

I'm havuing a column PERS_ID. I need to get the current and previous values on each run. My stage variables: PrevPersId : CurrPersId CurrPersId : InputLnk.PERS_ID (Initial Value=0) I'm using two nodes configuration file. I have used hash partition. Data are spliting in two nodes. Input 111 111 111 2...

If you use '$' then it should be a environmental variable. Just use #FilePath#/<Filename>.txt

If it is only ten columns. Try this in a transformer In the inut column you should have two columns one should be key and other one is the column to be pivoted. Add zeros to input colmns and sort it in descending order Stage Variables: Source => Ans0:Space(5-Len(Ans0)):Ans1:Space(5-Len (Ans1)):Ans2:...

My Project is having /bin/c++ compiler. How to write routines in enterprise edition? How to cal routines in parallel jobs?

I'm converting a server job to Parellel job.
I don't know how to replace a function Fmt(Column,"11RZ").
How to Suppress leading zeros in parallel job?

I got the error ;'Timed out while waiting for an event' while ruing a sequential file. I have called this sequntial file in a wrapper script. what could be the error?