DSXchange

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 ...

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...

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...

Hi all,

Hope someone can give some advice, thanks in advance.

1) How many nodes defined in the config file? 4 or 5? Is there a conductor node?
2) For SMP do we need a conductor node?
3)Is there a process generated by conductor node other than those 13 processes?

Regards.

Hi ,

Thanks for your response.

Yes im talking about Kilobytes's only not Megabytes.Thats weird.

Do i have to do any changes in the job design and properties?

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...

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...

Thanks for your reponses. I will try these options and let you know if i get any issues.

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...

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

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 ...

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...

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.. ...

Hi Ray,

I found the reason for the issue. Out of 12 fields one of the field is of char datatype of length 10. But in the source sql iam doing substr [4,7]. So when i changed the length of the field from 10 to 7 it got worked.

Thanks for you suggestions.

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 ...