Thursday, October 30, 2014

Coming up...

Inner view of a Seagate 3.5 inches hard disk d...
Inner view of a Seagate 3.5 inches hard disk drive Medalist ST33232A model manufactured in Malaysia in 1998. Parallel ATA interface, ultra DMA mode 2, I/O data-transfer rate 33.3 MB/s max, 3,227 MB, 3 platters, 6 physical read/write heads, spindle speed 4,500 RPM, cache buffer 128 kB, MTBF 300,000 hours, dimensions 146.8 x 102.4 x 26.2 mm, weight 540 grams. (Photo credit: Wikipedia)
30-October-2014


I saved all my scripts and command files in a portable HDD, and the disk is not in very good condition after some years of heavy use. At any rate, I was able to still copy over 99.99% of my files, so coming up... the actual scripts I used.

Hope they help somebody, as it did me.

Till then!

Tuesday, October 28, 2014

PROMIS - Login

Wikipedia login page
Wikipedia login page (Photo credit: Wikipedia)
28-October-2014


Perhaps the most ignored and seemingly insignificant part of the PROMIS session is the login part. And why not? Just invoking the session, then typing in your username and password gets you in, then what you do after that is no longer needing or relating to log-in processes.

Perhaps.

But if you do a lot of scripts, and I mean not just simple scripts, but if you have multiple log-in privilege, or that the script you wrote is run by many users who log in to different terminals at the same time, and they can run the script at the same time, then this is needing the variables you use in your scripts to be singletons, or they should be user-based, or ID-based.

ID-based would sometimes be a problem, because the same script can be run by a multi-session user, and the data cannot be crossing over. Same idea as Microsoft's "sandbox" concept.

Thus, variables can be set in the login.com file. Some other files can be invoked. Messages, etc.

But most importantly, Host- or Instance-based variables can be detected and set, and this will determine what kind of session you will be having, running.

Machines are either transaction-serving or report-serving, so having that set in your login.com file will help you know right-away which session you are running, especially if you are like me, who opens 4 sessions, at the minimum. The flexibility and speed of PROMIS running in VAX-VMS is such that multi-session is no native, making you very productive.

It was just unfortunate that the time I started learning and using PROMIS, there was not much furor about SAP, which was way behind Oracle. Our company was using SAP back then, and I would have learnt it also, maybe. That was about 20 years ago.

A lot has changed since then - but not PROMIS and VMS. They remain. And while the company I now work in has decided to build their own MES by creating their own version of a Manufacturing Execution System, the concept and base knowledge I gleaned from my almost 2 decades of working in PROMIS is in such a magnitude and scope - I learned other software and programming languages in the course of time, especially when parallel dBase was introduced, and I was one of those who "qualified and stress-tested" the new system.

And even with native PROMIS datalink extraction method, my knowledge in Excel was enhanced, as there was a lot of data massaging afterwards - which all went away naturally when reports were generated using the parallel database, all running in Oracle. Which made me very comfortable navigating the tables because I know very well the structure of the ISAM files in native PROMIS, so switching to Oracle tables was a breeze, and that gave me the advantage of simply focusing on learning SQL.

I will stop here, before I digress too far away. I will present the login that make a native session come up with a unique idea that can be used as a variable for scripts that can be run at the same time by different users, or even the same user with multi-session privilege.

Till then!



Thursday, October 23, 2014

New work, new focus

JavaFX Mobile
JavaFX Mobile (Photo credit: Wikipedia)
23-October-2014


For about 5 months now, I have taken on a new job, and my focus now is more on engineering. Still, my experience as an IT practitioner is recognized, and capitalized on, from time to time.

Before I forget PROMIS, and the things that I did for the past 18 years or so, I would be documenting what I practiced, so I will have something to go back to.

Forget? Maybe not.

But it is actually the problem of forgetting the small, small things, not the major things, that causes the problem, especially as the years go by.

And, I am advancing in the years, and still learning a lot of new things: AutoCAD, Java SE 7 and 8, ASP.NET MVC, Entity Framework, C# in depth, and JavaFX. I may pick up F# soon.

Thanks to PROMIS, I learned a lot. I was forced to learn SQL, VB.NET, C#.NET and ASP.NET. So I picked up CSS and HTML in the process, and also XML. I made it good, simply because there was opportunity to learn and practice what I learned.

And what I am learning big in my new job is 'to get disturbed.'

I had to learn to stop and answer questions, or do other things, and resume what I was previously doing - seamlessly. This is one thing that I hated, and kept myself from until now.

It is, however, already a requirement of my new job, so again, given the opportunity and guidance to learn and practice this work method - I would make good at it.

New venture, and very exciting!

Till then...