DSXchange

Hello there, Can anyone explain to me to get Day from 'yyyy-mm-dd 00:00:00' format. DAYOFWEEK = oconv(iconv(EXTRACT_DATE_TO[7,4]:'-':EXTRACT_DATE_TO[4,2]:'-':EXTRACT_DATE_TO[1,2],"D-YMD[4,2,2]"),"DWA") do you want something like "Monday", "Tuesday" etc. then ...

Hi I like to loop a record on certain number of times based on the incoming record value. have a routine and do you calcuations there. getting/fecthing the same records <b>5/n</b> times is a costly operation. if you can explain bit more of what you are trying to do , it will help to suggest a solut...

Hi again to everybody in DSXchange land, Is it possible to 'filter' which fields are written to a sequential file output based on a list which contains the field names? IMHO, if the seq file is defined as a stage , then it is static. means that you cannot conditionally remove a column from it. 1)tr...

Im trying to INSERT value from Sequential file to Oracle9i using method UPSERT. For UPSERT method, it should only insert data that does not exist in the database. My problem is, why it INSERT duplicate value into the database when i rerun it again? duplicate based on what???. try trimming the value...

Hi, The files cannot be accessed or deleted either. Looks like some process of the job that was stopped is still holding to files. that "some process" is the previous process used for creating the file. DS is sensitive in case of file locks. 1) Kill all the process using Windows taskManag...

Hi, I tried to load Binary Datatype(From Db2) to Sqlserver database binary datatype but i couldn't see any data in sqlserver database(all values <binary>). try by setting <b>Nullable</b> property of the column to <b>No</b> . this way you can check if the problem is happing during extraction(ie from...

I want to delete all of the rows from the table when I'm confident that the number of rows in the flat file are equal to the number of rows in the table. Regards, CB count is not a <b>reliable</b> way of checking if the operation is successful . you have to have something like this to be safe :D 1....