Search found 138 matches

by Maximus_Jack
Mon Feb 03, 2014 3:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Stage: Regroup problem for multilevel child elements
Replies: 13
Views: 7581

thanks for responding.. yes followed your suggestion and created a regroup for each level and the mapping also seems to be working, but when i execute the job i'm facing an error as below and the job aborts XML_5,0: Message bundle error Can't find resource for bundle com.ibm.e2.Bundle_E2_engine_msgs...
by Maximus_Jack
Sun Feb 02, 2014 3:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Stage: Regroup problem for multilevel child elements
Replies: 13
Views: 7581

XML Stage: Regroup problem for multilevel child elements

Hi I'm using the XML stage( not the XML output), to create an XML file, i'm having a single input link, where the data is coming from a netezza database, which is having elements in multiple levels, meaning, each child element is having a sub child ( note: i'm getting a row each repeating elements a...
by Maximus_Jack
Thu Jan 09, 2014 3:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Importing Multiple root or Global elements in XML stage
Replies: 1
Views: 1207

Importing Multiple root or Global elements in XML stage

Hi I have created the an XML schema library and imported all the required the xsd files, now all the global elements present in all the xsd's are appearing ( but in a completely flat structure ), when i tried to create the actual xml files as per the xsd, i'm only able to pick only one global elemen...
by Maximus_Jack
Wed Jan 08, 2014 4:00 pm
Forum: General
Topic: XML Schema Library Manager - Error
Replies: 8
Views: 5756

Hi All I think i have figured it with some trial and error, before building a XML schema library, i think the first thing to do is to identify the XML schema flow, i painstakingly found the schema flow of all the files and i created separate library for each particular tree, seems like a XML library...
by Maximus_Jack
Wed Jan 08, 2014 8:40 am
Forum: General
Topic: XML Schema Library Manager - Error
Replies: 8
Views: 5756

Hi
i'm sure, i have imported the entire list, is there any other way to approach this issue?

thanks
MJ
by Maximus_Jack
Tue Jan 07, 2014 2:51 pm
Forum: General
Topic: XML Schema Library Manager - Error
Replies: 8
Views: 5756

Hi,
Thanks for your response

Tried that, but still facing the same error

thanks
MJ
by Maximus_Jack
Tue Jan 07, 2014 2:12 pm
Forum: General
Topic: XML Schema Library Manager - Error
Replies: 8
Views: 5756

XML Schema Library Manager - Error

Hi I tired to import few xsd files with the schema library manager , after it has been imported and validated, i'm seeing a lot of error as "sch-props-correct.2: A schema cannot contain two global components with the same name; this schema contains two occurrences of ',Classification'." I ...
by Maximus_Jack
Tue Nov 12, 2013 1:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple job has to write to a single file
Replies: 6
Views: 1772

thanks...

but it should work for dataset isn't ?
by Maximus_Jack
Tue Nov 12, 2013 1:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple job has to write to a single file
Replies: 6
Views: 1772

thanks chullet..


strange... is there no way do it.. ?
by Maximus_Jack
Tue Nov 12, 2013 12:32 pm
Forum: General
Topic: Controlling Multiple instance of a job
Replies: 1
Views: 964

Controlling Multiple instance of a job

Hi A job has to run in multiple instance taking the tablenames from a flat file as the invocation ID, but at any point there should not be more than 5 instances of the job, i have written a script where the job picks the table name and runs in multiple instance, but couldn't figure out how to contro...
by Maximus_Jack
Tue Nov 12, 2013 12:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple job has to write to a single file
Replies: 6
Views: 1772

Multiple job has to write to a single file

Hi I have a requirement where multiple instance of a job has to write to a single file, i tried with both sequential file and dataset, with sequential file- Somehow the records are missing when the job finishes.. with dataset - Sometimes I'm getting an error as "Error updating ORCHESTRATE File ...
by Maximus_Jack
Fri Sep 06, 2013 8:39 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Couldn't drop tables created by IADB
Replies: 3
Views: 4965

yes did that as well, but no luck

i'm not a db2 expert, i don't know how db2 first allows to create a table like
this?
by Maximus_Jack
Fri Sep 06, 2013 8:15 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Couldn't drop tables created by IADB
Replies: 3
Views: 4965

Couldn't drop tables created by IADB

Hi All the tables created in IADB has a "." in it like "dfdfdfd.eretere.2k0roc.mbnvnvbc_fd", when i tried to drop these tables, it couldn't be dropped getting an error as SQL0103N The numeric literal ".2k0roc" is not valid. SQLSTATE=42604 is there any way to drop these ...
by Maximus_Jack
Wed Aug 14, 2013 2:27 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: How Information analyzer is different?
Replies: 2
Views: 4262

How Information analyzer is different?

Hi I have one basic question... from a developers stand point, whatever the information analyzer is doing can be done by simple SQL queries/scripts as well, in some cases the task is much much easier when done in a SQL query, rather than writing all the rules, running the analysis, etc, etc..... so ...