Cerner CCL
 |
This article is an orphan, as few or no other articles link to it. Please introduce links to this page from related articles; suggestions may be available. (February 2009) |
 |
This article does not cite any references or sources. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed. (December 2008) |
Cerner CCL (Cerner Command Language) is the Cerner Corporation fourth-generation programming language, which is expressed in the Cerner Discern Explorer solution. CCL is patterned after the Structured Query Language (SQL). All Cerner Millennium health information technology solutions use CCL/Discern Explorer to select from, insert into, update into and delete from a Cerner Millennium database. Usage of CCL allows Cerner Millennium to remain independent of database-specific nuances of SQL syntax. CCL provides unlimited possibilities for using Discern Explorer to query and report on the Cerner Millennium data. CCL allows a programmer to fetch data from an Oracle database and display it as the user wants to see. With features like, Record Structure and subroutines, it allows us to get data from database and manipulate it by storing in a temporary structure; execute a particular section of the code, if required using a subroutine.
Discern Explorer provides several applications that can be used to create, execute, and analyze ad hoc queries, reports and programs. These applications provide flexibility in the skill set needed to build programs and design reports. Discern Explorer programs can be written using, VisualExplorer.exe (VE), DiscernVisualDeveloper.exe (DVDev), an operating system command-line editor, or any other text editor. ExplorerMenu.exe (EM) is used to execute Discern Explorer programs on demand. ExplorerAnalyzer.exe (EA) allows its users to analyze the system resources used by RDBMS queries.
