SQL courses - recommendations please

[Bob Dalek]

Yeh I know, I realised when I started I'd get the usual Transact/PL-SQL "you can't do that" comments so I went for some generic pseudoSQL just to get the laboured joke over.

Are you from Mumbai?

[TheBigYinJames]

Are you from Mumbai?

Please switch your PC off then on again, then call back, and ask for Arthur.

[Bob Dalek]

Please switch your PC off then on again, then call back, and ask for Arthur.

Ah! You are.

[KathyWoolfe]

Whats DB2 ?

DB2 is IBM's relational database - replacement for IMS.

[expat]

DB2 is IBM's relational database - replacement for IMS.

And is what SQL was made for in the first place.

[Spacecadet]

DB2 is IBM's relational database - replacement for IMS.

replacement? from what I can see IMS is still current and hasn't been replaced

[darmstadt]

DB2 is IBM's relational database - replacement for IMS.

Yes and no. It is IBM's relational database but it is not a replacement for IMS which is still going very strong. Remember also that DB2 is quite varied across platforms. Most platforms use DB2 UDB so that it is pretty consistent across the various platforms but when you get to DB2 for VM/VSE then there are quite a few differences (as it is still not part of the UDB family) which means that a DB2 application/database/whatever which is fine on z/OS will not function on z/VM.

[KathyWoolfe]

replacement? from what I can see IMS is still current and hasn't been replaced

Yes and no. It is IBM's relational database but it is not a replacement for IMS which is still going very strong.

Sorry, maybe I should have used the word alternative instead. IMS is only current because of the inertia of companies to re-develop some of their legacy code with newer technology.