DSXchange

Hi I have a job where the input file format is Delimiter | Quote double. But i got one record like this "aaaaa"|"bbbbbbbb"|"cccccccccc""|"ddddddd" Now this record is getting rejected because of the extra double quote in "ccccccc". is there a way...

Even after converting it into 'DD-MON-YY' , i am not able to update it. I tried this Oconv(Iconv(Substrings(LkpMatched.AH_ACCT_RECLASS_DATE,1,10),"DYMD"),"D-DMY[2,A3,2]") The format of AH_ACCT_RECLASS_DATE is 'YYYY-MM-DD HH24:MI:SS' CvBT0002Job3AcctHistLoad_New.3273.XF1: At row 1...

ok, i saw that this is present in the update statement

AH_PREV_ACCT_RECLASS_DATE=TO_DATE(:93, 'DD-MON-YY').

how do i convert my date into this format

Hi, I have a field Col1 with data type Date. From the oracle stage i am extracting this field like to_char(col1,'YYYY-MM-DD') and storing this value in the col. I have one more field Col2with data type Timestamp. From oracle stage i am extracting this field like to_char(col2,'YYYY-MM-DD HH24:MI:SS')...

Hi,

I have a date in the format 'YYYY-MM-DD' and i want to convert into timestamp format with OCONV. How can i achieve that.

no, i dont think i have..but how to find that out?

what would be the value..1 or 0?

Hi,

When we compare two fields

If (link1.A=Link1.B) then 1 Else 0

Now when Link1.B is a null value what would be the result?

Hi We have got some requirements to create reports. We have to compare a file and a table and based on the conditions , we have to give the count. For example Col A in file matches Col A in table and Col B in file matches Col B in table--count of this Col C in file matches Col C in table and Col D i...

Hi, I am getting sqlcode:1403 while inserting the record into the table. Only one record gets rejected with this issue. I searched the forum, but couldnt find any resolution. Can anyone please help i am using ORA OCI stage and upsert method, where for update i have mentioned the where clause as 1=2,...

my target tables are same for multiple jobs.

so if i start the jobs parallely then i will get the same value for all the jobs as input.

i can get uniq nos not a problem. but when multiple jobs run at the same time all will query the database and get the max(col)+1 value, which will be same and when they calculate unique values, all will have the same values and cannot insert if it is a primary key for the output table. i want to hav...

Hi, I am trying to generate uniq ids for the data i am inserting. i know that there are lot of ways to achieve it, but i will be running the jobs parallely so i think there will be a problem. If i use the max(col) and pass it as a variable to the job and use @OUTROWNUM , then if parallely i run many...

Hi, I am creating a statistics file in a job based on the count in the incoming link. I have aggregators to count the number of records. But if there are no records o.e zero records in the input link, it is creating a 0 byte output file , which is normal. But i want to create an output file(which is...

i understood..thanks a lot.