A little different from what I’ve been used to writing but the way it breaks down the select statement, it would definitely be helpful for complex joins. We also learnt that CE_JOIN statement can only join two tables at a time, but you can take the bp_addresses table and use it again in another CE_JOIN to continue joining tables.
And lastly Rich talked about imperative logic in SQL script. Very nice flow, you can ‘select’ into an internal table and then ‘select’ from the internal table into variables and do control logic based on these variables.
Then Ron took the center and talked about what is XS Engine and how (and where) it fits into the HANA. Letting you expose data via XS, publishing OData service, do server side JavaScripting and all. Ron also made the best of of the handy white board.
Thomas took the center once more and gave the demo of how to create a ‘Hello World’ html page using HANA developer Studio linked with Developer workbench, which has to be configured with HANA client. He didn’t stop there, of course. He then gave a demo of how to create a oData service (and how easy is to do that!) as well as demo SAPUI5 based application with google like (autocomplete) feature as well as a simple table retreiving 1.1 million records.
Of course it was easy for them to say! :smile: When I started creating and compiling the code I kept getting ‘completed with errors’ but it was also good to get Thomas’s first hand advice and then Ron’s on how to look up the error and try to make the best of it to know what I did wrong. You can look up the excercises here:
CodeJam SQLscript Exercise.pdf
We got lots of input from the gurus on what is there and what is yet to come. Some of things I remember were:
Special thanks to Craig and Thomas for making it to the codejam, in spite of flight delays and sleep deprivation! There was a good SAP IT presence at the codeJam, among the attendees were Thomas Hamm, john.astill, Dirk Pluschke, Ivan and myself. It was a great event, I can only ask for these events to happen more often!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
21 | |
16 | |
13 | |
12 | |
11 | |
10 | |
9 | |
9 | |
8 | |
7 |