DSXchange

Hi all, I am using Oracle stage for load append, when data got duplicate error with Primary key, it will automatically generate log and bad files under scratched directory. But, I checked in bad file, record's content missing. Table: BWAN Field: SID number Not null (Primary Key) NAME varchar2 Data f...

Hi all, I want to import ERwin XML file "Via MetaBroker" with DataStage Manager, but after conversion and press "Select All" / "Filter" button, Metabroker process terminated abnormally. After clicking the button "Select All" / "Filter", the process &...

Hi all, I got error in remote connection to oracle DB. Error: ##I TOSH 000002 10:31:14(001) <main_program> orchgeneral: loaded ##I TOSH 000002 10:31:14(002) <main_program> orchsort: loaded ##I TOSH 000002 10:31:15(000) <main_program> orchstats: loaded ##I TFSC 000001 10:31:15(001) <main_program> APT...

Hi Ernie, I tried experiment by using sequential stage as target, it works in both setting and result in 1 row. After that I re-try in MQ (DSjob1), it works in 1 row. But, for DSjob2, it comes with 3 rows. Is it normal? How can I identify this 3 rows come with same message? DSjob1: Folder stage --->...

Hi all, I am new in MQ Stage, I have a file with 2 rows of record. I use folder stage to read the file as input, and then put to MQ. If I set the Preserve CRLF to "Yes", 2 rows put to MQ. While Preserve CRLF to "No", 1 rows put to MQ (line1 and line2 link together by "?"...

Hi suunil,

In MQ stage at "column" tab, many options to get MQ message information at field "Data element", e.g. MQ.CORRID, MQ.DATE. But in the list box, which one is for MQ message content itself?

thanks,
Brigitta

Hi Ray,

We will develop in both parallel and server jobs. Any different in getting MQ message content?

Cheers,
Brigitta

Hi all,

I am new in MQ stage, I want to know how to get the MQ message.
At "column" tab, many options to get MQ message information at field "Data element", e.g. MQ.CORRID, MQ.DATE. But which one is for MQ message content itself?

Many thanks.

Cheers,
Brigitta