DSXchange

hi,

I have this scenario where i will get a file and will load into table, this job runs daily, everyday when it loads it has to delete all old data,completely erase andinser only new reords. i gave "delete and insert" , that doesnt seem to work? how shall this be acheived?

hi, I have to bring the latest date from a table which has tis column.I used the aggeragator groping on dummy and pulled the maximum value, now the valuse by default is in double, but i need to palce it in the datetime feild ib the target table. I am using 8.1, there is no direct decimal to date con...

there is no daysinmonth function in 8.1? how shall i write vthe loic without going into if then else

i foud, looks like daysinmonth should work

i get yyyymmdd format date , i need output as yyyymmdd(but dd has to be last day of month 'mm', is there a direct funtion to pull last day of any month,

For Example: Input filed = 20130814, then output should = 20130831

i have this requiremennt, if input field is "abc123456" then output should be "abc123456," if input is "ab123456" then output should be "ab 123456"(1 space), if input is a123456 output should be "a 123456" (2 spaces), all the time output is 9 varchar...

I'm getting the exact same error. Did you ever get this resolved for yourself? I'm trying to load 100mil rows using zLoader.

I am using 8.1

the size is 150 varchr coming in input, looks liek the value of N can be anythng between 1-10 mostly

yes, sapce is the only delimeter, but its not just 3 words, it can be 4, or words or 2 or 1, input may also come lilke "input may also come lilke" then output is IMACL

Hi, if in input field, "Change Section Design" i need output as CSD , the first letter of each word in the input.how do i dot his?

thanks

Hi, its is notnull and varchar. To give little history wt ia m doing, i have this two bills i am comapring , Prior Vs current, In would be nending to go aand get the employeereconid added in current bill, dropped from prior bill. i ahve joined the two sqls on employee reconid and in trnasormer based...

main_program: Fatal Error: Destination "leftRec.leftRec_EmployeeReconId" is already bound.

does anybody have any idea what does this mean?

I am using this as key in full outer join

Thanks a lot ray