DSXchange

I think your Look Up is not returning the null value when the join condition is not matching.Is the date field is coming from reference ?Check whether the nullability is set to 'Y' in look up for that field.

Hi,

Did you change any values in parameter set?

If you are changing anything in parameter sets,it will get reflected in the jobs only after the compilation of jobs.You can use the multicompiling option,if this is the scenario.

Yes on the common key. Yes on the output for a single delimiter (comma). But your nth column will be the entire row from the second file which is pipe delimited. ... Hi, Thanks for the reply.I think you are trying to say,we have to add all the fields from second file into last field and concatenate...

One job creates two files, one with comma and the second with pipe; with an extra column that has a running number. Use a second job to join the two files on the running number you created in the firs ... Thanks for the reply DSguru2B, But i am unable to see the full message. I assume that what you...

Thanks for your reply.But if i am doing that i will get output as

Ab,cd,ef,gh
Jk,lk,mk,op
de,ki,po,lk
Ab2|cd2|ef2
Jk2|lk2|mk2
de2|ki2|po2


But i need the output as


Ab,cd,ef,gh Ab2|cd2|ef2
Jk,lk,mk,op Jk2|lk2|mk2
de,ki,po,lk de2|ki2|po2


Thanks
Jyothisdas

Hi everyone, I have a requirement in which we needed the output file in the following format "OPEN,20101027,160000,CUST_KEY_1,2007-05-05,Open,Y,P,,,,,2007-07-25,NON-EXEMPT CUST. VALID W-9 ,,,,,,,,,|NOT|TANNER|N||||SCHAPMAN|HOME TELEPHONE|5135348500^|NOT|EMAIL|EMAIL|NOT|1234||^|NOT|DRIVERS LICEN...

Hi, I need to combine the two vector fields and the desired output is Parent Key [17095 130000 25 Ajai Bhupi PM] 1 [17878 145000 30 Das DAS RM] 2 I am using Make Subrecord stage for this. Inside the stage using the options Vector Column for Subrecord-Columnname1 Vector column for Subrecord -Columnna...

Hi, i am trying to make a subrecord by combining two vectors.I am using a subrecord stage for that. My Input fields are Columnname1 columnname2 Key [17095 130000 25] [Ajai Bhupi PM] 1 [17878 145000 30] [Das DAS RM] 2 Output fields are Key Parent But i am not getting any values in the output field Pa...

Hi, I have to load a decimal field(14) from database(DB2) to a sequential file. There is no change needed in length and datatype. When i am trying to do this i am getting leading zeros and an extracharacter '_' at the end in sequential file. For ex: Input-100000 i am getting the o/p as - 00000000100...

Hi,

I need to load the job details like source stage and target stage names,Row count etc to a text file.Can any one help me to create a job for this?

Thanks and Regards

I checked with diff command .Thers is no difference in the datas .

One more thing I noticed is,If i am using left outer join in 8.1 i am getting the same number of rows as in 7.5.But if we use complete set option differnce in rows will come.

Thanks in advance

Hi, I have migrated one server job which contain merge stage from 7.5 to 8.1. Now when i am trying to run the job ,i am getting more number of rows in 8.1.When i checked the target file , some blank rows are present at the end of the file which are not in 7.5. The size of the two input files in merg...

Thank you guys

You are right..In 7.5 server file size limit is 'Unlimited'.That is why i am able to transfer files in that one .In 8.1 i have only limited file size as you said.

I used the command ulimit -a and i am getting the o/p as Time- Unlimited file(Blocks)-2097151 data(Kbytes)-131072 Stack(Kbytes)-32768 memory(Kbytes)-32768 Coredump(blocks)-2097151 nofiles(descriptors)-10240 What does it mean?Cant i transfer a file of size > 131072KB? Please help me to figure it out ...

I gave the Trace On command as mentioned below ftp>Put file name Trace On Result is PORT Command SuccessfulOpening Data connection for Trace Error Writing file : Error 0 ABOR command Successful Then i am geting 1gb of the file instead of 2gb Is this what you explained? or anything else i have to do?...