DSXchange

Here are two sample xml files which we are processing in DS job. The job is running fine in 8.5v , but recently upgraded to 8.7v. The job is failing for second xml. since "ModelType" element is not coming from the xml. First XML PGMedical <?xml version="1.0" ?> - <CoveragePattern...

I got the below warning message. main_program: Ignoring message with bad cookie; expected 1349978497.578000.c8d0, received 1349978493.428000.d6d8 My job reads a sequential file and directly loads into MS SQl server database. This process goes every day will lot of files, from last 2 years, i never s...

Hi All, I have a scenario like below. Col1 Col2 Col3 Col4 Col5 Col6(seqno) A Ram 1000 Ch Vi 1 B Krish 2000 BA SA 1 C MUR 3000 LA BU 1 C MUR 3000 LA BU 2 C MUR 3000 LA BU 3 C MUR 3000 LA BU 4 D ABR 1500 FA KL 1 E FBG 2000 BL RO 1 I am getting source data (Col1, Col2, Col3, Col4, Col5) and I have to g...

I have source data like below 3902 10AM 3902 11AM 3902 2PM 3902 4PM In target data base , i have data like this rec1 3902 9:45AM rec2 3902 9:50AM rec3 3902 10:30AM rec4 3902 11:10AM rec5 3902 11:45AM rec6 3902 1:30PM rec7 3902 2:05PM rec8 3902 2:35PM rec9 3902 3:59PM rec10 3902 4:23PM Now for every ...

This is know error to dsxchange, today I got this error. This is not the first time I am running the job, it ran almost from a year back everyday. APT_CombinedOperatorController,0: [IBM (DataDirect OEM)][ODBC SQL Server Wire Protocol driver]Invalid character value. Error in parameter 7. Recently, th...

I appreciate your reply. Yes, be default, we are processing as per the guidelines/blueprint of the IBM CDC. We are setting up the subscription and doing the filter options. And more over, I create a user exit function in java to handle special characters in source column as well. Now the requriermen...

What do you mean by "mirrored" in this context with CDC? Mirrored - Setting up/ Identifying the column for CDC to capture the changes on this column. By default, if we create a subscription, we need to sepcify in CDC that , if any change is occured on a specific column then create a recor...

How to build "User exits for InfoSphere CDC" ? My requirement is I have source table which is having 100 columns, I dont not want all the columns to be mirrored and more over I want a user-defined SQL select query to define the columns to get mirrored.

Is there any forum for "IBM InfoSphere Change Data Capture" ?

Hi all, One of my requirement is to source Japanese data and process it through ETL framework to production While doing profiling, I am not able to read the data in a correct form and not sure how these character are encoded in MF file. If anybody has any idea Kindly share across with me which will ...

Dear Experts, request you please provide your valuable inputs on the same . We have have a similar requirement like "IDC".

Thanks for your help and support in advance.

We are also facing the same issue where by when we do want to capture the record count for datasets using DSJ.LINKROWCOUNT , it yields 0 where as if the stage has been replaced with some other stage the record count gets captured. Initially , the dataset stage itself was not getting captured since w...

Hi Ray,

This is similar error which I am facing in recent days.
but not every day.. its is occuring atleast once in a week, what could be the cause for this error other than permissions, if it was purely based on permissions, then we should get this error for every run.?

Chulett: This is 8.7v; Yes, around 450 xml's are processing successfully without any single warning/error, only few xml files, where the tags are missing are getting faling.

Hi, In XML INPUT Stage , under Stage tab - Validate input XML box is unchecked only, I defined all the tags properly .. around 450 xml files are parsing successfully, only the xml files which donot have all tags are failing. I defined the columns as Nullable No;