Search found 13 matches
- Fri Jul 13, 2012 6:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Conversion factors inserted as double are read and converted
- Replies: 4
- Views: 2779
- Fri Jul 13, 2012 5:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Conversion factors inserted as double are read and converted
- Replies: 4
- Views: 2779
Conversion factors inserted as double are read and 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 ...
- Mon Aug 22, 2011 7:40 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Recommentation to pick right tool to process XML files
- Replies: 11
- Views: 36214
More info;
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 ...
- Sat Aug 20, 2011 6:20 pm
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Recommentation to pick right tool to process XML files
- Replies: 11
- Views: 36214
My two cents;
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...
- Thu Jul 28, 2011 11:21 am
- Forum: General
- Topic: XML stage parsing problems
- Replies: 3
- Views: 2489
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...
- Tue Jul 26, 2011 4:28 pm
- Forum: General
- Topic: XML stage parsing problems
- Replies: 3
- Views: 2489
XML stage parsing problems
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 ...
- Wed Jun 01, 2011 6:12 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Accessing Axapta (Microsoft) financial DB
- Replies: 1
- Views: 1880
Accessing Axapta (Microsoft) financial DB
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?
- Mon Mar 14, 2011 9:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MQ queue error
- Replies: 0
- Views: 8518
MQ queue error
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.
Got this from GOOGLE;
2539 (09EB) (RC2539): MQRC_CHANNEL_CONFIG_ERROR
Appears to be some sort of config problem.
- Tue Feb 08, 2011 4:52 am
- Forum: General
- Topic: Setting parameters in sequencer
- Replies: 1
- Views: 1819
Setting parameters in sequencer
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?
- Mon Feb 07, 2011 3:02 pm
- Forum: General
- Topic: binding variables in sequencer for uservariables_activities
- Replies: 1
- Views: 1985
binding variables in sequencer for uservariables_activities
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.
- Fri Dec 03, 2010 9:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Records missing in the sequential file
- Replies: 15
- Views: 8797
Re: Records missing in the sequential file
Why not funnel each link together and then write them?
- Tue Nov 09, 2010 6:49 am
- Forum: General
- Topic: sending reject file if records are rejected.
- Replies: 10
- Views: 4553
If running via shell script;
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.
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.
- Tue Oct 19, 2010 12:21 pm
- Forum: General
- Topic: running multiple jobs
- Replies: 1
- Views: 1772
running multiple jobs
This is a problem with their scheduling system that submits jobs. They have escalated to vendor.