Question:

Is there a way to insert a null field into a Datascope record using the Perl Datascope API?

Answer:

You have to query the database for the null value for a particular field, eg,

@db = dblookup (@db, 0, 0, 0, dbNULL) ;
($null_sta) = dbgetv(@db, qw(sta)) ;

and so on.

This is a pretty unusual operation -- if you're adding a record, then any (or most) fields not mentioned get the null value. The exceptions are lddate and any id field defined by that table. (eg, wfid or orid).