DSXchange

Hi All; I am using the file pattern to read the source files.And during the rejection process i want to capture the row number and the file name into the error log table so that user can know which record is rejected and from which file in the file pattern is it rejected. Thanks in advance Thanks; S...

Hi All;

I want to capture the reject records that doesn't met the condition in the constraints . i checked the otherwise/log checkbox. but i cant able to capture the records thatdoesn't met the condition in the constraints. how i can capture those records?

Thanks;
Syam

Hi all; I am trying to load the data into oracle table using load method .When the data is loaded the constraints for the table which i am loading are disabling.I want to append the data each time when the data is going to come .can any one please help me in this concern. Thanks; Syam.

Hi all; I am trying to read the source file in which some records are having the record length of 126 and some records are having record length of 114. i am able to read the data of length 126 only. but i want both 126&114 field length data to be read. one column in the source file has 26 length...

Hi all; Can you any body please guide me where i need to check reason(s) for reject records.let me explain some more details. I am loading the data from source file(fixedlength flat file) to oracle data base.And i am capturing the reject records in sequential file. Log file is showing 1000 records i...

the job type is parallel . and mentioned the same in the question also.

WHAT I WANT IS CONVERSION OF JULIAN DATE TO DATE. HOW ICAN DO THIS BY USING STRING TO DATE. HOW TO CONVERT THE 2006346 TO DATE0F TYPE EG:2006/12/12 . WHAT IS THE FUNCTION USED FOR THIS CONVERSION. ANY WAYTHANKS FOR YOUR REPLY.

Hi All,

I want to convert the date format of the type 'yyyyjjj' ex:2006346 to date. and i am trying to do it by using the julianday to date function. but it's not working . The format of the output date is 'yyyy/mm/dd'. how to convert this .
Any help is appreciated.

syam.

Hi All I am getting following error while running the oracle enterprise stage. ##E TOSH 000205 18:54:43(000) <main_program> PATH search failure: ##E TOSH 000000 18:54:43(001) <main_program> Error loading "orchoracle": Could not load "orchoracle": ld.so.1: /export/home/dsadm/Ascen...

Hi All,

Please help how to convert string to date in PX

Ex. 20061122 to 11/22/2006


thanks in advance

Hi All,

Please help how to convert string to date in PX

Ex. 20061122 to 11/22/2006


thanks in advance