590 likes | 699 Views
This overview explores the changes and advancements in the SIR/XS system, tracing its evolution from early versions like SIR 2 to the latest SIR/XS. The presentation showcases key differences and enhancements, including the shift from batch processing on mainframes to interactive use on PCs. Highlights include new features like Windows interfaces, multiple database support, enhanced syntax, and graphical user interfaces. Detailed screen shots will illustrate common activities across different versions. Join us for an in-depth exploration of these significant developments.
E N D
Changes I have seen. What I like about SIR/XS.
Introduction • I shall show you some examples of the versions of SIR I have used so that you can see some of the differences. • SIR 2 • SIR 3 • SIR 4 • SIR2000 • SIR2002 • SIR/XS
Introduction • The first version of SIR that I used was SIR 2.1.3 and this was on and ICL 2970 mainframe. • This was initially a mostly batch system using punched cards.
Introduction • Use was made occasionally of interactive use. • Sometimes a specialist device as shown next which used HOST to access the database.
Introduction • SIR came to the PC world and I shall show some screen shots of the SIR interface in the various versions using a PC. • I can demonstrate these if anyone would like to see more at the end.
Introduction • The screen shots will show a common set of activities across versions. • Startup • Connecting company database • Entering a retrieval • Running a retrieval from a file
SIR 3.2 • NEW FEATURES • Menu System • New Editor • Easy
SIR 4 • NEW FEATURES • First Windows Interface • Works with No Database attached • WDL Windows Design Language • API Interface
SIR 2000 • NEW FEATURES • Toolbar • Multiple Databases • ODBC • SQLSERVER • WEB Support • Master logon/logoff • Execute DBMS • Spreadsheet • Graph
SIR 2002 • NEW FEATURES • Database Secondary Indexes • PQLForms • Dialog and PQLForms Screen Painter • New Grid Control with VisualPQL interface • Extended Strings • Automatic compression of database strings • Extended VisualPQL limits on constants • Redefinition of array dimensions and sizes • Sorting array values • HEX format on READ and WRITE for binary strings • Auto Increment Keys • LOOKUP command • SHOW/HIDE elements in dialogs • POPUP lists in menus and dialogs • Extended number of elements (4000+) in a dialogs • HELP message for dialogs • Parameterized ODBC queries • New Menu Interface • New DEDIT Dialog Type • Extra VisualPQL functions including tabfile schema
SIR/XS • NEW FEATURES • Extended syntax allowing names up to 32 characters • Non-standard names • Enhanced standardised syntax • STANDARD SCHEMA and STANDARD VARS • New Common Vars definition • New variable documentation • New write schema options • Upgraded record schema modification • ADD VARS, DELETE VARS, MODIFY VARS, RENAME VARS • Multiple Data Files • New Batch Data Utility features including CSV Input/Output • New Journaling and Recovery • New XML Procedure • New GUI Debugger • New PQL Server • Regular Expressions • SEEK function to control file position • Timestamp functions • Extended syntax on PROCESS CASE • CAT VARS in VisualPQL • PQLForms update • Encryption • Enhanced date and time format specification • Enhanced picture specification on WRITE and PFORMAT • New GUI Controls • IN=stdin and OUT=stdout on sirbatch execution command