Adding data to Image - Advice needed

[Thomson, Martyn EDUC:EX]

Seamus
Here's part of a QTP program that does something similar.
This is using OpenVMS RMS files - ged_next_cert_no is a direct file
containing 1 record. 

RUN sess_score09
SET PROCESS NOLIMIT
REQUEST update_cert_no
ACCESS *ged$sbf:score08 &
LINK TO RECORD 1 OF ged_next_cert_no
TEMP t_certno INT*5
ITEM t_certno INITIAL NCONVERT(cert_no OF ged_next_cert_no) &
  COUNT
OUTPUT ged_stud ADD initialize from score08
ITEM cert_no   = ASCII(t_certno)
OUTPUT ged_next_cert_no UPDATE AT FINAL
ITEM cert_no = ASCII(t_certno + 1)

But my advice - hire a programmer ;)
Martyn Thomson
Ministry of Education, 
Victoria, BC

-----Original Message-----
From: Seamus BROWNE [mailto:Seamus.Browne@partage.org]
Sent: March 11, 2002 6:57 AM
To: powerh-l@cube.swau.edu
Subject: Adding data to Image - Advice needed


Hi,
We are using PH on an HP 3000 Image database.

I have practically no experience in QTP or QDESIGN (though I have some
experience with Quiz) and I now have to add new records to a base with data
coming in from the Net via email. For the time being this is just adding new
clients to an existing client database.

I have extracted the data from the email files and have it ready to input
into the database either
- from records in a subfile or
- directly from data within a job file.

I need some advice on what would  be the best approach.

As I see it, it's as if I did this :
1. Add a new blank record to the client file.
2. Obtain the last client serial number from the parameters file
3. Increment then update the last client serial number in the parameters
file.
4. Fill in the new blank record with the incremented client serial number
and the data from the email.


Do I have to start by getting all the data (name , address etc + new client
number) lined up in a (sub)file ?
Or can I have some of the data (name , address etc.) lined up in the subfile
and grab a new number from the parameter file just before updating the blank
record.

What would be best : QTP or QDESIGN ?
Are there any examples of this kind of job available ?

TIA
Seamus

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