Window Functions Comparison Between PostgreSQL 8.4, SQL Server 2008, Oracle, ... share 4 days ago by Leo Hsu and Regina Obe PostgreSQL 8.4 has ANSI SQL:2003 window functions support. These are often classified under the umbrella terms of basic Analytical or Online Application Processing (OLAP) functions. They are used most commonly for producing cumulative sums, moving averages and generally rolling calculations that nee ... Postgres OnLine Journal - postgresonline.com/journal · Rank: 180,004 · 29 references | DB2-z/OS: Encrypt Data between Client and Server share 4 days ago by admin Symptom You want to encrypt data between the application server and the database. Other terms MVS, OS/390, DB2, DRDA Reason and Prerequisites Apply lib_dbsl patch #212 for kernel release 7.00. Solution This functionality is enabled if you set profile parameter dbs/db2/data_encrypt to the value 1. Wi ... SAP Basis Tech Supports - sap2048.com | DB2-z/OS: No DB connect with DB2 Connect 9.5 FP1 on Windows share 4 days ago by admin Symptom Problems with DB2 Connect 9.5 FP1: 1) After upgrading DB Connect to IBM Data Server Driver for CLI, ODBC, JDBC, SQLJ V9.5 FP1 Special Build 20615 no database connect is possible on Windows platforms; e.g. R3trans -x fails without displaying any return code. The error does occur only if DB2 C ... SAP Basis Tech Supports - sap2048.com | Two essential links: IBM Data Studio and a free book share 4 days ago by Henrik Loeser With a new version like DB2 9.7 there are other things you need or want, too. It's like with a house. You first remodel or upgrade something, then you need matching colors and hence buy new curtains, replace the carpet, try to get rid of some relatives (just kidding). Anyway, the point is that there ... IT, Life, DB2 pureXML, ... - blog.4loeser.net · 4 references | |