For the one case; there is exactly 11 students in the xml file; resulting in 257 rows in total. It seems I have to work my way up from some random number like 60 then it will go to 85 then 114 and so on until it finally reaches the total.
I will continue to debug; thanks for the heads up
Search found 15 matches
- Wed Nov 28, 2018 11:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage -- Produces More Rows after each run
- Replies: 2
- Views: 2619
- Wed Nov 28, 2018 9:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage -- Produces More Rows after each run
- Replies: 2
- Views: 2619
Datastage -- Produces More Rows after each run
My job is working though it has a peculiar property. It seems to produce more rows with each execution. I doesn't produce too many rows; but with each turn it can read more rows until it can consume the whole file. I have hierarchical stage that reads xml, in that stage it produces at the beginning ...
- Thu Aug 23, 2018 10:32 am
- Forum: General
- Topic: Scheduling of Jobs; a Director problem
- Replies: 7
- Views: 4141
- Thu Aug 23, 2018 8:39 am
- Forum: General
- Topic: Scheduling of Jobs; a Director problem
- Replies: 7
- Views: 4141
- Thu Aug 23, 2018 8:26 am
- Forum: General
- Topic: Scheduling of Jobs; a Director problem
- Replies: 7
- Views: 4141
- Wed Aug 22, 2018 3:48 pm
- Forum: General
- Topic: Scheduling of Jobs; a Director problem
- Replies: 7
- Views: 4141
Scheduling of Jobs; a Director problem
I have completed my job and it is ready to be scheduled. I think I have to use Director to do this; all I think I do is simply launch Director; schedule the job to run at a certain time. I don't save the job somewhere; I compile it in design; verify it runs. However nothing ever executes; I check th...
- Wed Jul 25, 2018 4:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Out of String Space
- Replies: 3
- Views: 4204
Sorry for the late reply; I found my work around. The testfile generated in the parser step seemed to bog the system down; I found a workaround by first generating a sample XSD file then a test file from that to test the Main XSD document. If I left it blank it also worked. Question is; why would it...
- Tue Jul 24, 2018 9:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Hierarchical Stage Produces No Rows
- Replies: 9
- Views: 8363
Solved
I have solved my own problem. 1. Datastage does not like the XSD document I had; I had to reverse engineer one of the XSD documents to make it an element a complex type just so Datastage could drill down into the XML. The XML had an embedded XML document where that document could be 1 or many. 2. I ...
- Thu Jul 12, 2018 3:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Out of String Space
- Replies: 3
- Views: 4204
XML Out of String Space
I have hit a wall. It is a very simple job, which is supposed to parse xml The newest problem is that now I get errors: 1) Out of String space when you save 2) Error message: Error calling subroutine: *DataStage*DSR.ADMIN (Action=36); check DataStage is set up correctly in project ETL_TEST_PROJECT_W...
- Fri Jul 06, 2018 10:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Hierarchical Stage Produces No Rows
- Replies: 9
- Views: 8363
Update: I got 1 row to work; seems as reason the hierarchical stage didn't want to drill down into the xml was that it couldn't resolve where the schema location was........I think. Anyway I got it to resolve 2 different ways: 1) I butchered the xsd and made the highschool a complex type xs:complexT...
- Wed Jun 27, 2018 1:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Hierarchical Stage Produces No Rows
- Replies: 9
- Views: 8363
- Fri Jun 22, 2018 1:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Hierarchical Stage Produces No Rows
- Replies: 9
- Views: 8363
Hope this helps; its the HighSchool XSD; the include CoreMain is far to large to paste here; the AcademicRecord is quite big as well. Those 2 files don't appear in the Library as name spaces; only the AcademicRe ordBatch and HighSchoolTranscript can be found to be used as XSD documents in the parser...
- Fri Jun 22, 2018 10:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Hierarchical Stage Produces No Rows
- Replies: 9
- Views: 8363
XML Hierarchical Stage Produces No Rows
I have successfully read on 4 XSD files I have 1 xml source test file to read in. The source xml file has really 2 parts, one called AcademicRecordBatch which has basic Sender/Destination info that does not change; I can read in that. it produces rows in a seperate job. I The second part has high sc...
- Wed Jun 20, 2018 9:30 am
- Forum: General
- Topic: Combining multiple XSD's
- Replies: 3
- Views: 3688
- Mon Jun 18, 2018 9:53 am
- Forum: General
- Topic: Combining multiple XSD's
- Replies: 3
- Views: 3688
Combining multiple XSD's
I hope someone can help me here. I have 4 xsd documents that are interlinked. Their names are: 1)AcademicRecord_v1.9.0 2)AcademicRecordBatch_v2.1 3)CoreMain_v1.14.0 4)HighSchoolTranscript_v1.5.0 Crazy I know.... I have a test xml file that imports the "AcademicRecordBatch" and the "Hi...