Adding data to Image - Advice needed

[David Morrison - Corporate]

Seamus,

My experience (on an IBM AS/400) is that you're better off using QDESIGN
than QTP, when you have a parameter file that needs to be locked for a short
period of time, in order to grab a system-wide counter that needs to be
incremented.  We use the following technique to lock a single record:

LOCK parameter-file RECORD
GET parameter-file OPTIONAL
IF NOT ACCESSOK
THEN BEGIN
	(do error handling here)
END
(Increment the counter)
PUT parameter-file
UNLOCK parameter-file RECORD 	

David Morrison

 -----Original Message-----
From: 	Seamus BROWNE [mailto:Seamus.Browne@partage.org] 
Sent:	Monday, 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.