Wiktionary(0.00 / 0 votes)Rate this definition: 1  nose(Noun) The organ of the face used to breathe or smell. 2  nose(Noun) A snout, the nose of an animal. 3  nose(Noun) The tip of an object (e.g. the nose of a fighter plane).
SQL is a set-based, declarative query language, not an imperative language such as C or BASIC. However, there are extensions to Standard SQL which add procedural programming language functionality, such as control-of-flow constructs. Transact-SQL is one of those extensions.
Today, the best language for embedded SQL is ILE RPG, in particular, free-format ILE RPG. If you haven't become acquainted with this great tool, it's time. I'm going to walk you through a complete, albeit simple, example. In this tip, I will show you how to use SQL for one of its most basic functions: reporting.