SW development with PowerBuilder and MS SQL Server
SW development with PowerBuilder and MS SQL Server for a customer in the area of energy supply.
Project tasks:
-
Adaptation of SW-interfaces for SAP data exchange
-
SW-development of Power-Builder batch programs. The allow the generation of export- and import-files for the transfer of data between a MS SQL Server database and the SAP system.
-
Transformation of a host based application for the import of COBOL-formatted files into a client / server environment, using PowerBuilder-scripting, GUI representation and data storage in newly created MS SQL-Server database tables.
-
SQL tuning, code review of existing SW, Enhancement of database design
-
Execution of plausibility test in order to eliminate error sources in the input data of the applications. Implementation of new functionality in existing PowerBuilder applications to document company-internal on duty time tables.
Project environment:
-
MS SQL Server 2000
-
Enterprise Manager 8
-
Query Analyzer, Transact SQL
-
PowerBuilder 9
-
COBOL
-
Windows XP