DSXchange

in generated sql UPDATE "HCTEST" SET "HIRED"=TO_DATE(:2, 'DD-MON-YY') WHERE "NAME"=:1; INSERT INTO "HCTEST" ("NAME","HIRED") VALUES (:1,TO_DATE(:2, 'DD-MON-YY')) to match this format i put this one Oconv(Iconv(DSLink71.HIRED, "DDMY[2,2...

I applied Oconv(Iconv(DSLink71.HIRED, "DDMY[2,2,2]"),"D-DMY[2,2,2]") this in transformer got the below error saying invalid month for HIRED column HealthCenter_EBR802..Transformer_73: The value of the row is: NAME = ABBOTT,JOANNE TITLE = DENTAL ASST EMPNO = 269403 STATUS = CLASSI...

craig,

I removed the derivation.I got this warning


processing column "HIRED"
Value treated as NULL
Attempt to convert String value "11/03/07" to Date type unsuccessful


it put null value to that column.

Can you please advice me what needs to be done here

Thanks

I checked in oracle table ,data format is like this 03-NOV-07 03-AUG-07 01-AUG-76 01-JUL-78 01-APR-94 01-FEB-97 03-MAY-07. my job design is like this seqfile --------->transformer ---------->OCISTAGE I defined data type for column 'Hired' as varchar while reading from seq file and in the transformer...

Hi,

I used this function ,it is working now

Iconv(linkname.columnname, "DMDY")

HI, my sourcce is from .csv .in that file date format is like this '11/03/07' I am trying to load this date filed into oracle table with data type 'date'.I didn't do any conversions. I got this error while processing column "HIRED" Value treated as NULL Attempt to convert String value &quo...

Thanks Ken,for your reply by inserting IPC stage between the active stages or by Enabling 'enable row buffer' and selecting inter processing option under performance tab in job properties , we get the same result, right ? if not can you please explain me ? one more question can we do both inserting ...

HI, one of peoplesoft delivered job design is like this drsrsage------>IPC--->TRANS--------->TRANS------>DRS STAGE in job properties performance tab 'projects default button' is checked I went to adminstrator and checked properties for rowbuffering,'enable row buffering option' is not checked-i.e ro...

Hi, When I am running job I got this error job design is like this DRSSTAGE ----->IPC------>ROWMERGE-------->TRANS------>ROWSPLIT------>IPC----->DRSSTAGE J_Stage_PS_S_NAMES..IPC_in.Source_out: ds_ipcput() - timeout waiting for mutex from source it is pulling morethan 40,000 records and trying to upd...

you mean this is not correct (setting the null value to the key)?we have to put some default values, right ? if len(Source_Row_Split.DT_ISSUED)=0 then @NULL else Source_Row_Split.DT_ISSUED in the update statment's where clause the update statment is comparing value of source and the value of the tar...

HI, in one of peoplesoft delivered maps, the logic in transformer stage is like this if len(Source_Row_Split.DT_ISSUED)=0 then '@NULL' else Source_Row_Split.DT_ISSUED DT_ISSUED coulmn data type is timestamp.so for the first time ,if there is no values in that column ,it is putting null values in the...

Yes Craig,

there was a space in sql after tab.After removing it ,it went fine.Thanks

Thanks for all of your suggestions

Hi, I am updating records in DRS Stage with the following update statment.(generated statment) UPDATE tablename SET EFF_STATUS=?, DESCR=?, DESCRSHORT=?, GVT_VET_RECR_CODE=?, GVT_VET_RECR_PTS=?, HRS_ROW_ADD_DTTM=TO_DATE(?, 'YYYY-MM-DD HH24:MI:SS'), HRS_ROW_ADD_OPRID=?, HRS_ROW_UPD_DTTM=TO_DATE(?, 'YY...

Hi DsGuru adn Cetin

both 'settings of 'incomplete coulmn' and adding dummy column to the files worked fine.

Thanks for your suggestions

HI, I saved excel file as CSV file and reading it from sequential file stage I got below error test_excel..Sequential_File_0.DSLink5: read_delimited() - row 38, column ENDDATE, required I checked 38 th record in the file.there is no value in the last column 'ENDDATE'. when I add the value to this co...