Erasing Portable subfile

[Ole Hansen, ScanConsult]

Richard,

You can even take it step further by writing your own dictionary file
(.psd).

If you e.g. have a tabular output from another system of the form :

PersonnelNo      Firstname       Middlename      Lastname      
---------------------------------------------------------------
A123456          Jill            Hawkes          Thorne        
A789012          Joe                             Johansson     
B123456          Joan            Anne            Andersson     

Save that file as personnel.ps (all lines must alle have same length).

Then write a corresponding personnel.psd file, e.g.

;Subfile definition created 08 MAR 2005  by OH
Element PersNo     Char Size 10
Element filler1    Char Size 7
Element Firstname  Char Size 14 
Element filler2    Char size 2
Element Middlename Char Size 14 
Element filler3    Char size 2 
Element Lastname   Char Size 14 
 
Subfile personnel Organization Direct
Record personnel
  Item PersNo      Datatype Char Size 10
  Item filler1     Datatype Char size 7
  Item Firstname   Datatype Char Size 14
  Item filler2     Datatype Char size 2
  Item Middlename  Datatype Char Size 14
  Item filler3     Datatype Char size 2 
  Item Lastname    Datatype Char Size 14
; end source

You can then ACCESS *PERSONNEL from either Quiz or QTP and have all data
available. Of course, the first 2 records are the 2 header lines of the
input file and must be discarded.

We use this on a regular basis to import external data received as (tabular)
files.

On MPE, the .psd-file must have file code 647 and be a 80-bytes file, and
the .ps-file must end in Q, e.g PERSQ and PERS (code 647).

Mange hilsner / With kind regards
 
Ole Hansen
 
===========================================================
E-mail: oh@scanconsult.dk         Cell Phone: +45 4040 1150
===========================================================
ScanConsult IT-Partners ApS         Voice   : +45 8738 7474
Jegstrupvej 96A                     Fax     : +45 8738 7475
DK-8361 Hasselager         Support : support@scanconsult.dk
Denmark                    Sales   :   sales@scanconsult.dk
                 http://www.scanconsult.dk                
= ParaSuite :  A Suite of Air Cargo Handling solutions    =
= ParaSafe  :  A Suite of IT-Security solutions           =
= Partners  : Hewlett-Packard, Cognos, Microsoft and more =



-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Guy Werry
Sent: 8. marts 2005 15:04
To: powerh-l@lists.sowder.com
Subject: RE: Erasing Portable subfile


Yes, Richard, it can be done.  I know that I've done this routinely with
regular subfiles. (Ux 10.2, Ph 7.33.D3).

Often I will use qtp to create a one record subfile, so that I can then use
the subfile in a Quick screen.  I will do the following:

* Create using Qtp (personal preference, Quiz can also be used)
* I now have either:
  * FRED.sf
  * FRED.sfd (for regular subfiles)
 OR
  * FRED.dat
  * FRED.idx
  * FRED.sfd
* I just do 'rm FRED.sf' or 'rm FRED.dat' 'rm FRED.idx'
* Then I do a 'touch' on the file(s) that I've just removed.  

So, that should work with portables as well.

Guy L. Werry
Senior Systems Analyst
Hudson Bay Mining & Smelting Co., Limited. 

-----Original Message-----
From: rsfrench@verizon.net [mailto:rsfrench@verizon.net]
Sent: Monday, March 07, 2005 4:55 PM
To: powerh-l@lists.sowder.com
Subject: Erasing Portable subfile


Does anyone know if it is possible to erase the data portion of a portable
subfile (on Unix) while maintaining the dictionary structure? Typically
these subfiles exist as 3 files something.dat, something.sd and
something.idx. Can I simply remove the dat file and recreate with touch? Or
do i have to recreate? Thanks.

Richard S. French

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber. = =
= = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.