Clear questions and runnable code
get the best and fastest answer
erichansen1836by erichansen1836 (Sexton)
|on Mar 24, 2015 at 21:10 UTC||Need Help??|
1983-1988 Condor 3 RDMS DBA & application programmer on the CPM operating system, Kaypro PC platform. MANUFACTURING/WHOLESALE DISTRIBUTION within the BROOM/BRUSH/MOP handle/dowel industry.
1990-1993 Ryan McFarland, Microsoft, and Micro Focus: PC COBOL DBA & application programmer on the MSDOS operating system. SINGLE INTEREST, COLLATERAL PROTECTION INSURANCE for the BANKING and LENDING INDUSTRIES.
1994-2004 Informix Standard Engine (SE) 4GL/SQL DBA & application programmer on the SCO UNIX operating system. SINGLE INTEREST, COLLATERAL PROTECTION INSURANCE for the BANKING and LENDING INDUSTRIES. TELECOM PAGING & WIRELESS SERVICE PROVIDER INDUSTRY.
1994-1997 Informix Dynamic Server (DS) 4GL/SQL application programmer on the HP UNIX operating system. SINGLE INTEREST, COLLATERAL PROTECTION INSURANCE for the BANKING and LENDING INDUSTRIES.
1998-2008 Microsoft Jet "Red" Database Engine/MS-Access Driver, SQL/ODBC-enabled Database, DBA & Win32 Perl application programmer on Windows O/S using Dave Roth's Win32::ODBC module, and with reporting done in the background via MS-Excel through a Perl COM connection established by the Win32::OLE module. Used Aldo Calpini's Win32::GUI module for DB "native Windows" user-interfaces. RETAIL FINE JEWELRY INDUSTRY. TELECOM EXPENSE MANAGEMENT INDUSTRY. TELECOM PAGING & WIRELESS SERVICE PROVIDER INDUSTRY. MANUFACTURING/WHOLESALE DISTRIBUTION within the BROOM/BRUSH/MOP handle/dowel industry.
2009-2014 no activity. I took time off from IT to work in the Tennis Industry at a Country Club
2015-Present Windows(tm) PERL (ActiveState ActivePerl 5.26.1) GUI application user-interface programming to, and Database Architecture & Administration of: Embedded PERL tandem/joint/dual relational Flat File databases, where binary external PERL SDBM database files of key/value pairs are tied to PERL program hash tables at run-time, for persistent random access indexing to Flat File fixed-length record byte offsets (within 128-GIG flat files, each containing 100's of millions of records), used to set the position of the file pointer before performing Read/Write operations. Indexes of type: Unique Primary Key, Unique Alternate Keys, and Alternate Keys with Duplicates (1000's of duplicates) are utilized for random access, as well as REGULAR EXPRESSIONS for sequential scans of records. Indexes are arbitrarily constructed upon the data within fields of records, not upon record numbers. This mimics SQL, but without all the overhead of SQL. One or more fields and/or partial fields within records are used to construct indexes.
RESEARCH & DEVELOPMENT ONLY at this time. Not currently working for any IT Department. Looking for an opportunity to implement/manage such a shared file system database for a small or medium sized corporation, and with Operational Databases no larger than 5 Terabytes. Data Warehouses, Data Marts, and Decision Support Systems (DSS), can be larger.
### QUOTES: ###
"REMEMBER THE ALAMO!" 3-6-1836
"I don't care what anything was designed to do, I care about what it can do." -- Gene Kranz, NASA Apollo 13 Flight Director
"What goes on in that tiny pea brain of yours? I told you a 1000 times, it's the T.V. !!" -- That Darn Cat!, actor Neville Brand
"You wanted confirmation Captain? THERE'S YOUR CONFIRMATION !!" -- Tora! Tora! Tora!, actor Neville Brand
"Mister, I don't think you're an engineer over at the aircraft factory...and I don't think that you have a little wife, who lives upstairs, who's waiting on you." -- That Darn Cat!, actor Neville Brand
"40,000 pads in this city and you have to pick one sitting on top of a human radar station. And now she has a sister staying with her who's the "head roach" up at the "state birdhouse". Now we have the two of them flapping their ears downstairs just waiting for us to make a mistake. NICE !!" -- That Darn Cat!, actor Neville Brand
actor NEVILLE BRAND, was a very cool actor, and a highly decorated WWII combat soldier (e.g. Silver Star, etc.). In a rare 1966 interview in which he consented to speak of his wartime service, Brand recalled how he earned his Silver Star when his unit came under intense fire from German machine guns located within a hunting lodge. "I must have flipped my lid," he said, for "I decided to go into that lodge." Disregarding his own safety, he worked his way around to the rear of the lodge/command post, burst in through the back and single-handedly dispatched the enemy within. Later, on April 7th, 1945, exactly one month and a day before the official German surrender, Sergeant Neville Brand was wounded in action by the Weser River. Felled by a gunshot to his upper right arm, and pinned down by withering enemy ground fire, Brand lay there slowly bleeding to death. "I knew I was dying," he said, "It was a lovely feeling, like being half-loaded." Rescued and treated, Brand was evacuated to a military hospital and, on September 17th, 1945, he departed for the United States. Less than a month later, Staff Sergeant Brand was honorably discharged from the U.S. Army at Fort Sheridan, Illinois.