set_server_host_internal.
int fid, total, who;
char *entity, ftype[32], *access;
int var_phys_id = 0;
int fid, total, who;
char *entity, ftype[32], *access;
int var_phys_id = 0;
EXEC SQL END DECLARE SECTION;
type = argv[2];
EXEC SQL END DECLARE SECTION;
type = argv[2];
total = 0;
EXEC SQL REPEATED DELETE FROM quota
WHERE type = 'ANY' AND filsys_id = :fid;
total = 0;
EXEC SQL REPEATED DELETE FROM quota
WHERE type = 'ANY' AND filsys_id = :fid;
- EXEC SQL SELECT SUM (quota) INTO :total FROM quota
+ EXEC SQL SELECT SUM (quota) INTO :total:total_null FROM quota
WHERE filsys_id = :fid AND phys_id != 0;
if (ingres_errno) return(mr_errcode);
WHERE filsys_id = :fid AND phys_id != 0;
if (ingres_errno) return(mr_errcode);
+ if (!total_null && (total != 0)) {
/*
* append quota (quota = total, filsys_id = fid,
* phys_id = 0, entity_id = 0, type = "ANY",
/*
* append quota (quota = total, filsys_id = fid,
* phys_id = 0, entity_id = 0, type = "ANY",
EXEC SQL set lockmode session where readlock = system;
#endsql
#endif
EXEC SQL set lockmode session where readlock = system;
#endsql
#endif