Changes I have seen.

1. Changes I have seen. What I like about SIR/XS.

2. 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

3. 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.

4. Introduction

5. Introduction

6. Introduction • Use was made occasionally of interactive use. • Sometimes a specialist device as shown next which used HOST to access the database.

7. Introduction

8. 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.

9. 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

10. SIR 2.3

11. SIR 2.3

12. SIR 2.3

13. SIR 2.3

14. SIR 3.2 • NEW FEATURES • Menu System • New Editor • Easy

15. SIR 3.2

16. SIR 3.2

17. SIR 3.2

18. SIR 3.2

19. SIR 3.2

20. SIR 3.2

21. SIR 3.2

22. SIR 4 • NEW FEATURES • First Windows Interface • Works with No Database attached • WDL Windows Design Language • API Interface

23. SIR 4

24. SIR 4

25. SIR 4

26. SIR 4

27. SIR 4

28. SIR 4

29. SIR 4 WDL

30. SIR 4 WDL

31. SIR 2000 • NEW FEATURES • Toolbar • Multiple Databases • ODBC • SQLSERVER • WEB Support • Master logon/logoff • Execute DBMS • Spreadsheet • Graph

32. SIR 2000

33. SIR 2000

34. SIR 2000

35. SIR 2000

36. SIR 2000

37. 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

38. SIR 2002

39. SIR 2002

40. SIR 2002

41. SIR 2002

42. SIR 2002

43. SIR 2002

44. SIR 2002

45. 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

46. SIR/XS

47. SIR/XS

48. SIR/XS

49. SIR/XS

50. SIR/XS