Thank you both in it i am working on Dwh development and usually we don't have test /development server so can I still enable debugger? What are pros and cons

Hi

So I will have 1xtra phone number table with customer ID as a foreignkey right? And what do you mean by business requirements for data usually it's business requirements?...

Each table may have 15 columns. ...

give me a ball park, I can afford any reasonable server

Layout means UI segment layout or COBOL code? I checked BMC Website and couldn't find migration software?

I need help on Data modeling in general? Normalization Testing....

Thanks Ed, couldn't follow your message to Jeff though...

So, here is the scene, It is kinda small to medium app I should say with 3 functions / screens need to...

Thank you All, appreciate your thoughts and time. It is kind of overwhelming to digest especially cobol code of META DATA conversion.

Now, as far presenting business cases is concerned:

...

Wow! W O W What a Nice Approach. Thank you so much Sir, I will make an attempt to approach this as NEW application, that way I...

Please see the INLINE response I got, for the question - how the records link to each other - I could not quite comprehend again 🙂

Rankerg (5/2/2016)

---

Thank you so...

Oops I missed your quote "You will also need to consider that it is highly likely that a IMS dataset contains several type of records and that you will need...

Ok, thanks

1. I will ask Cobol Developer if DB calls are segregated like Client Server app ? But in the Cobol source code, how the DB calls are separated?,...

Thanks Again and see my inline response

frederico_fonseca (5/3/2016)

---

going to reply to your 4 comments.

1 - you do not need to migrate to Microfocus - I was just stating what we...

Thank you so much

Please see my INLINE response below

frederico_fonseca (5/2/2016)

---

I've done such a migration 4 years ago - migrate a IMS db to Sql server and mainframe cobol to Microfocus...

So creating a store procedure and like to pass table name as parameter?

I get a flat / EDI file from client and ETL to the DB and since the client is sending entire yearly data instead of DELTA I need to filter...

so the application which I am going to feed this NEW Files expects DELTA (amended and new) records only, if it is existing / duplicate records then it will move...