Search found 387 matches
- Mon Dec 24, 2012 11:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Can't read Variable Block Mainframe file
- Replies: 7
- Views: 5934
Merry Chrismas everyone. I still have some problem on this one with an additional question: I was told in Variable Block mainframe file, in the beginning of each record, there is a record prefix which indicates the actual length of the current record. So is DataStage able to read and understand the ...
- Sat Dec 08, 2012 9:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Can't read Variable Block Mainframe file
- Replies: 7
- Views: 5934
Yes, Craig. I have read the FAQ and also searched in forum about Mainframe and COBOL before I posted this. Although I learned a lot from that, i still can't figure out my problem. In FAQ, it says mainframe variable length data has the usual attributes: a field containing the actual length of the fie...
- Sat Dec 08, 2012 8:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Can't read Variable Block Mainframe file
- Replies: 7
- Views: 5934
Can't read Variable Block Mainframe file
Hi All, I am new to COBOL and I have been struggling for a week. I have a Variable Block file and 3 copybooks (header, detail and trailer) from our Mainframe guy. The record length in Mainframe shows 27840 bytes ( I guess it means maximum length for VB format). I created 3 COBOL FD by using the copy...
- Mon Aug 20, 2012 11:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Trying to understand job score (1)
- Replies: 11
- Views: 8915
- Mon May 17, 2010 9:19 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Read XML File - Size limitation
- Replies: 3
- Views: 2874
- Fri May 14, 2010 10:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Read XML File - Size limitation
- Replies: 3
- Views: 2874
Read XML File - Size limitation
Hi Gurus, I have searched the forum before posting the question and found many anwers to some of the issues iam having in reading the xml files. But i have one outstanding issue with my requirement. Requirement : Have to read around 40 multiple xml files with the same metadata and convert in to fixe...
- Thu May 13, 2010 10:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DataType Conversion -- Compilation Error
- Replies: 1
- Views: 1517
DataType Conversion -- Compilation Error
Hi All, I have job which pulls the data from file using CFF stage and loads into a dataset.CFF stage has 2 columns and their datatypes defined as below 1) ID - Char(20) 2) Date -Decimal (9,2) -- YYYYMMDD In the later job i have a reuqirement to join based on ID and Date coming from table with the da...
- Wed May 05, 2010 10:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need help in building the logic
- Replies: 2
- Views: 2151
- Mon May 03, 2010 3:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Change the host name of the repository
- Replies: 1
- Views: 1825
Change the host name of the repository
Hi I am new to the DS 8.1. I installed DS few days back but the instance on which metadata repository was built is moved to new host. I am unable to start WAS the reason being the Metadata Repository has been moved to a different host and during the installation of DS We would like to know how to ch...
- Tue Apr 27, 2010 3:16 pm
- Forum: General
- Topic: IBM Information Server DS 8.1
- Replies: 1
- Views: 1983
IBM Information Server DS 8.1
Hey
I am a new to DS 8.1. I am having few basic questons on architecture.
1) Does the WAS has to be up and running always for the DS jobs to run on DS Engine.
2) Does metadata repository stores the job designs etc.
thanks
Sunil
I am a new to DS 8.1. I am having few basic questons on architecture.
1) Does the WAS has to be up and running always for the DS jobs to run on DS Engine.
2) Does metadata repository stores the job designs etc.
thanks
Sunil
- Tue Apr 20, 2010 12:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Heap Allocation Error with XML output stage
- Replies: 9
- Views: 9674
Hi, I introduced a new column and using the function @inrownum/10(Test purpose) for that field and running the transformer sequentially to make sure all the source records process to one node . And in later job iam using new coulum as trigger option and creating the multiple files. So if the source ...
- Sun Apr 18, 2010 1:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Heap Allocation Error with XML output stage
- Replies: 9
- Views: 9674
Thanks for the response. I dont think i can use the columns that are passing from the source. So i need to introduce a new column in the transformer and use the new column as trigger option. But the question is how can i create one xml with 0.5 M and 2nd with 0.5 M to 1 M.. 3rd with 1M to 1.5 M.. Co...
- Sun Apr 18, 2010 11:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Heap Allocation Error with XML output stage
- Replies: 9
- Views: 9674
Hi All, Thanks for your responses. Other than writing a custom code to create a xml file,could anyone let me know is there a way to create around 500k records as one xml file with the same structure ( repeatition elements, (aggregating rows option)) and another 500 k records as 2nd xml file so on.. ...
- Thu Apr 15, 2010 9:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Concatination not working
- Replies: 6
- Views: 3445
- Wed Apr 14, 2010 2:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Concatination not working
- Replies: 6
- Views: 3445
Hi, I tried with by using the decimal to string fucntion but still not getting the desired output. Iam extracting the data from Mainframe DB2 tables. Is it something to do with the lowvalues? or inline nulls? if there are any chances of having low values could any one let me know how to convert and ...