var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Can Someone Help me with OLAP?
DB2 noob here and I have avoided learning OLAP too long. I've read a few tutorials, and the functions are still completely alien to me.
So I tried to code one with our existing data to get an idea of how it functions. Great, syntax errors. I can't figure out what I'm doing wrong. Here is my code:
ROW_NUMBER() over (order by ANTY_PYMT_NET_AMT desc) as test
I get "unexpected token ( was found. Any idea what I'm missing? Granted, I don't have a clue what the Row Number would show me. What does "over" mean anyways?
What platform and DB2 version/release are you using?
If you are using DB2 for z/OS, OLAP specifications are supported from DB2 Version 9.1 for z/OS.
Download db2 cook book:
DB2 SQL Cookbook