Search found 22 matches

by joffijoy
Tue Aug 12, 2008 9:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML INPUTSTAGE
Replies: 2
Views: 1864

Please check the Input XML. More than likely that node may not be in that XML. It might be ok, since it is a warning and there is no guarantee that all the nodes you defined are in XML all the time.
by joffijoy
Tue Aug 12, 2008 9:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parameter Sets- Not passing value to jobs from sequence
Replies: 8
Views: 4764

Have you made sure that, parameter you passes to called Jobs are set to parameter set values?
by joffijoy
Thu Aug 07, 2008 7:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Executables of dependent Jobs could not be exported
Replies: 3
Views: 2047

ray.wurlod wrote:You should be able to select them from Quick Find (or maybe Advanced Search), in which you should be able to select all the executables you need.

This feature is a little publicized yet long-awaite ...

Thanks Ray, you are awesome. It Worked!

Thank you,
Joffi.
by joffijoy
Wed Aug 06, 2008 1:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Executables of dependent Jobs could not be exported
Replies: 3
Views: 2047

Executables of dependent Jobs could not be exported

Hi, I am tring to export the Job Design and executables of a Master Job and its dependent jobs from Project to another. I tried using Export from Menu and Command line. What I got in both case was Job designs for Master Job and all its dependent Jobs, but only Job executable for the Master was expor...
by joffijoy
Wed Jul 23, 2008 7:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML field truncation
Replies: 5
Views: 5451

Re: XML field truncation

Hi, I have a Job that read XML from a MQ. Size of the XML field is defined as varchar(999999). But I am getting the XML truncated after 100002 Bytes. Job reads the XML from MQ and writes to a file. The environment variables I have are: APT_AUTO_TRANSPORT_BLOCK_SIZE = False APT_DEFAULT_TRANSPORT_BLO...
by joffijoy
Wed Jul 23, 2008 6:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Heap Allocation Problem
Replies: 8
Views: 7881

Re: Heap Allocation Problem

log errors: main_program: The current soft limit on the data segment (heap) size (805306368) is less than the hard limit (2147483647), consider increasing the heap size limit main_program: Fatal Error: Throwing exception: APT_BadAlloc: Heap allocation failed. Check the ulimit first From unix Prompt...
by joffijoy
Mon Jul 14, 2008 3:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML field truncation
Replies: 5
Views: 5451

XML field truncation

Hi, I have a Job that read XML from a MQ. Size of the XML field is defined as varchar(999999). But I am getting the XML truncated after 100002 Bytes. Job reads the XML from MQ and writes to a file. The environment variables I have are: APT_AUTO_TRANSPORT_BLOCK_SIZE = False APT_DEFAULT_TRANSPORT_BLOC...
by joffijoy
Tue Jun 24, 2008 6:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Using FileSet in Look up Stage
Replies: 1
Views: 1338

Using FileSet in Look up Stage

Hi, I have a Job that needs to do a look up from a Table. Since the query is complex and the same query will be used in multiple places to look up, I thought it will be more appropriate to use a Lookup File set, and I created a lookup fileset with Range Look up = No. When I use this file set in my l...
by joffijoy
Fri Dec 14, 2007 3:07 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Adding Text field
Replies: 2
Views: 1914

Re: Adding Text field

Used a row genetrator to create a dummy record such that after sort the dummy record becomes the last one. The remaining logic remains the same and hence the dummy record got rejected.

Thank you,
Joffi Joy.
by joffijoy
Fri Dec 14, 2007 3:04 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: XML Output Stage - Repetative groups
Replies: 2
Views: 3807

Re: XML Output Stage - Repetative groups

I have finally implimented using XSL( Using XSL to do transform) and XSLT stage.
by joffijoy
Fri Dec 14, 2007 1:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading Large XML from MQ and passing it to MQ Input Stage
Replies: 1
Views: 1635

Reading Large XML from MQ and passing it to MQ Input Stage

Hi, I have a requirement to read a very large XML file from MQ and pass it in to XML INPUT and then to flat file. MQ------->XML INPUT ---> Transform ------> flat file. The file I have now is 26.5 MB in size and has 26113609 characters. I could read the same XML as input from a sequntial file (Using ...
by joffijoy
Tue Oct 30, 2007 12:22 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: XML Output Stage - Repetative groups
Replies: 2
Views: 3807

XML Output Stage - Repetative groups

Hi, I Have a requitement to create a XML with Multiple repitatve goups. How should I give my Input and XML Output stage parameters? What would be appopriate key to set? Do I Need to restucture my Input? I have used Single repetitative group in XML before, I have also read the XML design document and...
by joffijoy
Thu Oct 25, 2007 10:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Adding Text field
Replies: 2
Views: 1914

Adding Text field

Hi, I am using a transform stage to add(append) text filed. That is, I declared my keyfelds as 2 set of stage variables( previous and Current) in Transform stage. First Current is moved to Previous. Then Current gets data from Input link. Then, Current variables are compared with Prevous stage varia...
by joffijoy
Tue Sep 11, 2007 8:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Abend : XML output stage to MQ plug in
Replies: 5
Views: 7688

Just re-read your post up above. Could be the data element is screwing it up. That is for a very narrow usage on the Input link of an XMLOutput Stage. The myXMLString column above should be a character field of some type only. ...and "walk" before you run. Have a simple job, no reject lin...
by joffijoy
Tue Sep 11, 2007 2:58 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Abend : XML output stage to MQ plug in
Replies: 5
Views: 7688

quick answer to the first question --- put a single column on your output link, such as "MyXMLString".... put a single "slash" in the Description attribute of the field. Ernie I am getting following error on Reject Link when I added '/' $cat stat.xml XML output document parsing ...