DSXchange

Hi,

Thanks for reply.

This means if my source data is like 21-03-11 then it should be
StringtoDate(Columnname,"%dd-%mm-%yy") and output will be as
21-03-2011.

Thanks,
Santosh

Hi, I reading from Oracle database and loading into sequecial file. From Oracle source Date is coming as 21-03-11 15-04-00 16-11-81 and we need output as 21-03-2011 15-04-2000 16-11-1981 I am trying to function StringtoDate(Columnname,"%dd-%mm-%yyyy"). But its not getting converted in requ...

Thanks Chulett.

Yes effdt is an actual date but its also coming in format 20110131.
I tried the solution mentioned by you but still not able to fetch data.

Please help me if I am doing something worng. It is just a select query.

Thanks,
Santosh

Hi Team, We have a requirement to develop a datastage job which fetch 7 days old data in every run. Our source in DB2. I have tried below user defined query in DB2 Select * from Temptable where effdate >'#BIzDate#-7' and effdate <='#BIzDate#' But it did not work. BIzDate is a parameter which we are ...

Hi, We are using the derivation in stage varibale as If (IsNull(LNK_SRC.PARTY_NO=1)) Then SetNull() Else LNK_SRC.PARTY_NO. We are getting compilation error as "##E IIS-DSEE-TFEV-00026 12:11:59(010) <transform> Error when checking composite operator: Setting null to this non-nullable field: Stag...

ray.wurlod wrote:Split the data (Copy stage), use two Column Import stages, then Join the streams back together. Or use a Transformer stage. ...

Thanks a lot Ray!!
It worked for me.

Hi Ray,

I have tried the Column Import option but Its provided the option to seprate only one column. I am not able to seprate more than one column in single job.

Hi Team, We have a typical requirement. Source data is comming in format- PA_No AC_NAME AC_NO 123 d1#d2#d3 30#45#75 145 c1#c2#c3 10#20#25 We need to populate in target as PA_No AC_NAME AC_NO 123 d1 30 123 d2 45 123 d3 75 145 c1 10 145 c2 20 145 c3 30 We need to implement this logic in datastgae. Any...

braj wrote:Use:
StringToTimestamp(<input Column Name>,"%dd-%mmm-%yy")

This will take input as '17-APR-10' and output as 1910-04-17 00:00:00

Thanks
Brajesh.

But We need output as "2010-04-17 00:00:00' not "1910-04-17 00:00:00"

Hi Team, We have a job to laod data from Taradata table to table. We are facing problem with the timestamp column. Our source table is having all the columns as varchar even the date/timestamp column. Data in source is like '17-APR-10' and we have to load in format "2010-04-17 00:00:00". W...

Thanks a lot for information.
I will check with IBM Support Team.

We have already installed the 8.1.FixPack.1.

Could you please let us know which pack we need to install to resolve the issue?

prashanth.spl wrote:Hi Santosh,

May i know which version of datastage and Teradata are you using now?

We are using DataStage 8.1 (UNIX), Teradata Connector 12 Version.

Any transformation must have the column(s) to which it applies present on the Transformer stage input link - it must be there explicitly, it cannot be provided via RCP. So, unless this transformation ... . Hi Ray, You are correct. I have mentioned that coulmn (Job_EXECUTION_ID) explicity in the tra...

Do you have a particular need to have RCP enabled? ... Actully our parallel job is a generic job, where at run time we just passing source and target table name from parameter. We are not loading the source and target metedata in the JOB. If I do not enable RCP, we need to load metedata for each co...