Okay. I come to the tree of knowledge. And kneel at the alter of information, posing this question.
I need a good book on scripting and DB2. I have skills with PL/SQL and SQL Server(SQUELLLLLLL). But know I work for a Company that uses DB2 for most of it's database storage. So is their a printed book that will help me learn scripting and proper formation of SQL and DB2, like prompts(&), column formating and spooling to a file with results. All RDBMS engines have there on twist on the same stuff.

Regards

Grass Hooper

You are lucky - the legacy DB2 command line processor (CLP) does not support prompts or column formatting, so there isn't much to learn. At the bottom of this page: IBM - DB2 database product documentation you will find links to the PDF manuals for your DB2 version. Download Command Reference and print it if you are not too much concerned about the destruction of rain forests.

DB2 9.7 comes with a much improved CLP, which is called, surprisingly, clpplus. It is mostly compatible with Oracle's SQL*Plus, so again, there is not much to learn. Details can be found here: What's new in DB2 V9.7: SQL*Plus compatible command line processor has been added

SQL for DB2 follows the standard very closely, which effectively makes it its own dialect because none of the others do.
A free reference: DB2 SQL Cookbook
A paid reference: Amazon.com: DB2(R) SQL PL: Essential Guide for DB2(R) UDB on Linux(TM), UNIX(R), Windows(TM), i5/OS(TM), and z/OS(R) (2nd Edition): Zamil Janmohamed, Clara Liu, Drew Bradstock, Raul F. Chong, Michael Gao, Fraser McArthur, Paul Yip: Books#