CS-FTP-DB

CS-SQL-COMPARE

CS-TP-SPY

A very useful tool for those who work with large SQL databases on the NonStop™ platform, CS-FTP-DB allows you to use standard FTP clients to transfer files to and from the NonStop™.

CS-FTP-DB provides a gateway that performs like an FTP target but uses SQL databases rather than files. This tool also will not alter the system in any way to achieve this because it uses only standard Tandem functions.

Use CD-FTP-DB to transfer SQL tables to a PC to be read with a spreadsheet software or transfer Excel tables to the NonStop™. Macros can be established to provide convenience for several users.

CS-FTP-DB offers an inexpensive resource for data analysis.   This product allows you to directly transfer to or from NonStop™ SQL tables to any other system in your network including workstations, PCs and other databases.

Benefits:

• Mass Data Transfers – Quick and Easy

• Retrieve data in Excel compatible format

• Automatic Pre and Post-Processing of file transfers

• Records NonStop™ SQL configuration data in a version management system

Product Information:

• CS-FTP-DB is a single process on the NonStop™ platform, no client components are required

• Use a CSV format or custom-configure your own

• Get direct access to a HP NonStop (Tandem NSK) Enscribe or NonStop™ SQL database via standard filetransfer applications

• Create data on a PC or UNIX system and upload it via FTP directly into the HP NonStop™ database

• No temporary files and additional processing steps are required

Product Requirements:

CS-FTP-DB requires the TCP/IP protocol to be installed on your NonStop™ system.

CS-SQL-COMPARE is also very useful when working with SQL tables on the NonStop™ .

• Use this tool to positively verify that a replication process is working correctly.

• Refresh the main table to force any replication triggers that update other tables.

• Use the compare tool in regression testing to ensure that code is effecting the expected changes to the database by comparing with a reference table of expected results.

SQL-COMPARE is the simplest way to compare NonStop™ SQL tables without shutting down your database. The easy command line interface offers an array of features such as Checkpointing that allows the user to interrupt a compare and restart at his convenience.  

Application Areas:

• Check referential integrity by comparing key columns

• Compare configuration databases in the test environment with those in production

• Compare test results against reference tables

• Compare replicated tables to their source

• Choose from multiple actions for any difference found (such repair, update, insert or delete)

Benefits:

• Easy to install, configure and manage

• Compare active databases

• Customizable comparison settings

• Compare different types of data i.e. character to numeric

• Use the batch compare or interactive compare