DSXchange

Using DOUBLE as type. It is not only the viewer, when I write these values to a file they are converted.

I have a process that reads a flat file of UOM data to insert into a table for subsequent processing. The column in the table is defined as DECFLOAT and I insert it as DOUBLE with no issues. Querying the rows in my SQL tool shows all values the same however when I read the table with Datastage some ...

the XSD document itself has a size of 248kb and the XML message will be coming from the message broker. The messages will be coming in constantly from 2500 facilities and I am sure there will be 100s of thousands of 'instance' documents for each patient object being sent. I have been unable to save ...

We are currently trying to use the 8.5 fix pack XML stage with a very large XSD. By large I mead 9700 plus xpaths and over 65 or so objects. (patient admin, lab tests, results etc) in a modified HL7 format. Many of these entities go down several levels and can hold multiple values. IBM says there is...

I still think there is some sort of problem. This element has a data value in the first element of the group. The following three tags are empty and do not show in the tree. Any others of this type show fully, when they are empty, and can be mapped. I was able to map this via the XML input and get t...

In a large XML file we want to just pull segments into different links. When mapping however some sub-elements show without the drop down to allow these values to be mapped. When you choose the top element the entire XML definition under it gets parsed with the data value as well. Is this some kind ...

Can this DB be treated like a DB2 or SQLServer DB and will the ODBC stage work. I have the server ID and DB name and I assume I will need a userid/pasword with select rights to access. Can anyone confirm or share anything?

Connect to queue manager using channel failed with reason code: 2539

Got this from GOOGLE;

2539 (09EB) (RC2539): MQRC_CHANNEL_CONFIG_ERROR

Appears to be some sort of config problem.

I have a parameter string written from a UNIX script and need to bind them to the defined parameters in my sequence job. I know this can be done but cannot find an example for the proper format. Can anyone help?

I am using a UNIX script to write a text file with variables that will be used as job parameters and I have used this before several years ago but cannot recall/find the syntax to bind them to the common variables in the sequence job.

Why not funnel each link together and then write them?

File_len =`cat path/path/file.txt | wc -l'
if file_len > 0
then
mailx command with parms.

Be careful those are tics not apostrophes!
You set sender and recipients to parms.
The sequencer also has a mail stage that can be conditionally called.

This is a problem with their scheduling system that submits jobs. They have escalated to vendor.