Portable Subfiles VAX to HP

[Roger Marcinik]

I do have a solution to your particular problem, but I do have some general
suggestions.
Usually I avoid using portable subfiles when interfacing data between
different systems.  This is because many times the task is to move data
to/from PowerHouse systems to/from PC-based systems not using PowerHouse,
or HP to DEC, or DEC to HP.  Often, I need to make an ASCII CSV file to be
read by LOTUS, EXCEL, ACCESS, etc.  Or SQL files to be read by Oracle, etc.
A method which has never failed me yet is to use QUIZ to make a normal
ASCII file with fixed length fields and records:
SET REPORT DEVICE DISC NAME filename SPACING 0
SET PAGE LENGTH 1       ;gives one record per line
SET NOHEAD              ;custom headers may be used in init hdg.

The ASCII file can then be transferred by FTP or Reflection file transfer,
etc.

On input to the DECs, I then use QTP to build a subfile to match the layout
of the ASCII file, then use the CONVERT utility to convert the ASCII file
to a subfile readable by PowerHouse.  I do the same on input to the HPs; I
don't have an example handy right now, but I believe it's FCOPY that will
do the conversion on the HPs.  Or I just use SuprTool to describe the input
and do the PUTs.

Roger
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.