DSXchange

Hi All, I have source file say file.csv where it contains following data Empno, Deptno 12,1 13,1 23,2 45,3 now my requirment is when i read this file in datastage it should read only the records where Deptno=1,2...not every time 1 and 2 the Deptno will keep on changing. I am thinking that i will cre...

Just to replrase ny sentence, i want to capture these records in a seperate file.

I have used merge stage but one question here was

Unmatched Masters Mode:Drop (I want to capture these drop records how can i do this)

Warn On Reject Updates:True

Warn On Unmatched Masters:True

Hi All, I have a requirment as below. Main Link: 1 2 3 4 Reference Link: 1 2 3 5 1. After doing lookup i will pass the matched rows. 2. I will pass the unmatched rows from the main link by using reject option so that 4 record will pass. 3. My question here is i want to pass the unmatched row from th...

Hello

I want to replace . from integer, how can i do this. I searched in fourm not able to find.

Input file.
1.0
2.0

Output should be
1
2

can anybody please help.

Thanks
Pavan

Hello All, When i tried to multiply the data getting the following error. Source data:- 2345 2346 2347 2348 In transformer i am doing this logic 2345*0.08 My source is Integer and while loading with decimal(8,7) getting the following error APT_CombinedOperatorController,0: APT_Decimal::ErrorBase: Fr...

Hello All, I am geeting this warning in lookup stage Lookup_126: When checking operator: Operator of type "APT_LUTCreateOp": will partition despite the preserve-partitioning flag on the data set on input port 0. These are 3 datasets which are refrence link to lookup stage and i made Preser...

Thanks for your reply.... in my source link data is coming form days say from (0-1000)...i want this to converted this to years by using by using (365.25 days = 1 year). I have tried with above example with 10 records from 1 to 10...anf all the records giving me as 1. My doubt here was how 1 day wil...

i am getting the value from source(Integer) like this

194
2037
20438
32599

want to convert this to years

Hello All,

I want to convert the value to years by using (365.25 days = 1 year).

Can any one help me how this can be done in datastage parallel jobs.

Thanks
Pavan

Try StringToDate(Column name,"%(m,s)/%dd/%yyyy") It might work.. Hi, I used this function StringToDate(Column name,"%(m,s)/%dd/%yyyy") and it worked for me....thanks for that..... i haved read what 's' specifies and it specify this option to allow leading spaces in date formats....

Hi, there are a lot of examples recently given for StringToDate conversion. Please check those posts. Still if you have any doubts, please let us know. Yeah.. i have see those posts..and applied the logic but still geeting the error I haved the function like this StringToDate(Column name,"%mm/...

Hello,

Can you please in coverting my date fuction.

My input is dataset --- transformer ---- DB2 stage.

Input is varchar field and output is date field

date coming from source is mm/dd/yyyy and i need to convert this to yyyy-mm-dd.

Ay help is much appreciated.

Thanks
Pavan

Hi All I have a job for converting EBCDIC file to ASCII, this job is failing with the below error Field "RMS_CMQ_CCR_DETL.CUST_NO" has import error and no default value; data: {@ @ @ @ @ @}, at offset: 16 We have recently migrated to DS 8.1 , this is still running fine in 8.0.and is failng...

Still showing the same error that i pointed out