Hi All; i have input file with follwing 4 fields fund, date, TNA(AMOUNT), formtype same fund name exists with differnt form types; my requirement is to calculate change in TNA(AMOUNT) for the same fund name with days differnce between same funds is 360-370 there may exist same fund more than twice? ...
Hi all; i am getting error like this job1..Sequential_File_0.DSLink2: read_delimited() - row 1, too many columns in record. what might be the problem. please suggests me Initially i had 47 columns in source (tab delimited file). when i view the data using sequential file (source), i can able to view...
Hi all, i got it, thanks to evry one harithay Your design should look like this Target Table --->Hash File --------Ref Link For TransformStage1 Input File -----> Stream Link for TransformStage1 Out Put Link1 from TransformStage1 Target Table (Update) Out Put Link1 from TransformStage1 Target Table (...
Hi Kris Hi there, If you want to update existing record and insert new record, 'insert new or update existing rows' should be sufficient enough. But if your sequence number is the primary key?or is it the unique key in the table? In any case you would be populating new sequence numbers which is okay...
thanks sjhouse, i used sdkkeymgtgetnxt('account') routine for that to generate sequenc number . i dont know about updation , if i found key match i need to overwrite the record. for that what shoud i do. in target ODBC there is update action , can i select 'insert new or update existing rows. is tha...
Hi all, i have situation like this the loading of data take place every month. after intial load , the next month i may get both new records and already existing records (need to update existing records ) for updation i am taking target key column into hashed file for lookup purpose with source. for...
thanks ray quote="ray.wurlod"]Even TIME() does not give milliseconds on all platforms. On some platforms you can only do it in code, by specifying the compiler declaration $OPTIONS TIME.MILLISECOND. Try SYSTEM(12) - if I recall correctly - this will report in milliseconds if the system is ...
HI Arnd Harithay, the @TIME function doesn't return milliseconds, but TIME() gives milliseconds; but the OCONV doesn't support that format on output, so you could use: OCONV(DATE(), "D4-YMD[4,2,2]") : " " : OCONV(TIME(), "MTS:") : " ." : FIELD(TIME(),'.',2) {{...
Hi craig, thanks for you reply. Since we don't know for sure what you need, it either needs to look like this: [code1]if (Fundname2 <> Fundname1 or Fundname1='') and DateGenericDateDiff(Date2, Date1) < 365 then 0 else TNAamount2-TNAamount1[/code] or: [code2]if Fundname2 <> Fundname1 or (Fundname1=''...
tahnks craig ; i am sorry before i did not use parens properly so i got syntax error, now i am using follwing expresion but i am not getting proper output if (Fundname2 <> Fundname1) or (Fundname1='' ) and DateGenericDateDiff(Date2, Date1) < 365 then 0 else TNAamount2-TNAamount1 if it is wrong pleas...
Hi all, i am using follwing routine but i am not getting what i required in the output. i am using stage variables for that , i have written follwing expression in stage variable "change" if Fundname2 <> Fundname1 or Fundname1='' and DateGenericDateDiff(Date2, Date1) < 365 then 0 else TNAa...