![]() ![]() By the way, the objects created by SQL/Pro are the same objects used by IBM’s SQL/400 Query Manager. Report formatting criteria is submitted through a series of prompt screens that are automatically linked to the current SQL SELECT statement. Report formatting when output is directed to a printer is another SQL/Pro capability. SQL statements require field names, which could become cumbersome except that SQL/Pro has included a function key that displays the field listing of any file on the user’s system. Statements can run interactively or in batch from this screen. This is where SQL statements are keyed into the system using insert, split, copy, delete and split functions. The heart of SQL/PRO is the interactive SQL statement entry screen. A special command also permits users to run a saved query from a CL program. The screen shows all the saved queries alphabetically ordered in a subfile. Once saved, users can select and run a saved query from the Work With Saved Queries screen interactively or via a job queue. Queries can be saved directly from the interactive entry screen or indirectly through the history screen. Public access can be indicated for any saved queries making it easy to select the users that can use, change, or delete queries. The Save Queries feature allows users to name and save any SQL statement. The history log can also be used to create subsets with user defined filters for advanced searching.Īnd on the administration side–where security should always be a top concern–there are controls of SQL/Pro user and group authorities that limit the capabilities for SQL statements, services and commitment control. The browsing display feature shows the first 65 characters of the statement. The log allows users to quickly retrieve statements to rerun and to modify or create repeatable deployments. There’s also an enhanced history log that keeps a record of every statement executed. The SQL/Pro interface permits users to query, print, and manipulate data using the power of SQL. Output can be directed to a display, printer file or database file. In addition to more muscle, ProData built in useful features such as SQL statement prompting and the capability for statements to be executed in batch or interactively. But SQL/Pro is not all about high performance information retrieval. A demo of SQL/Pro gives you a quick lesson in interactive performance. Information retrieval gets a lot of attention. SQL/Pro 5.0 is an example of what SQL can accomplish.Īnytime there’s a conversation about DB2 for i and SQL, performance is going to be a big part of the discussion. Taking advantage of SQL is one of ProData’s pursuits. It’s true what the SQL advocates say: Programming with SQL is faster and easier than traditional methods. It’s funny how things have changed for those who learned to take advantage of SQL’s ability to combine and extract records from databases. Years ago, when IBM i was known as OS/400, SQL was an unwelcomed stranger. Any database-related development work is going to involve SQL. ![]() And when it comes to programmer productivity, the Omaha-based tech company gets it. The key to the IBM i platform is its database and how developers create applications that ride on top of it. ![]() Data access, data integration, and the DB2 relational database are ProData’s specialty. SQL/Pro 5.0 is the latest in a long line of hard-working IBM midrange computing utilities produced and perfected by ProData Computer Services. SQL Query And Report Tool Gets The ProData Treatment ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |