Back up sids the same way we back up gdss signatures.

diff --git a/backup/db2bkup.awk b/backup/db2bkup.awk
index fe1c91b02345c11099075411355146d89557c095..eea66b7aef4641376b170e09526c907f2b1d4185 100644 (file)
--- a/backup/db2bkup.awk
+++ b/backup/db2bkup.awk
@@ -49,9 +49,9 @@ NF>=2 {
                t = split(temp[2], temp2, ")");
                if (t != 2) printf "Can't parse %s\n", temp[2];
                printf "  char\tt_%s[%d];\n", vname[count], temp2[1]+1;
-               if ($1 == "signature") {
+               if ($1 == "signature" || $1 == "sid") {
                        vtype[count]="bin";
-                       printf "  EXEC SQL VAR t_signature IS STRING(%d);\n", temp2[1]+1;
+                       printf "  EXEC SQL VAR t_%s IS STRING(%d);\n", vname[count], temp2[1]+1;
                } else {
                        vtype[count]="str";
                }

diff --git a/backup/db2rest.awk b/backup/db2rest.awk
index c1a5e6fa146d159505637dfe4d1cd308a60d6d60..07e637e9e17a1041f41ee5d05952132e3ffacd4d 100644 (file)
--- a/backup/db2rest.awk
+++ b/backup/db2rest.awk
@@ -50,9 +50,9 @@ NF >= 2 {
                t = split(temp[2], temp2, ")");
                if (t != 2) printf "Can't parse %s\n", temp[2];
                printf "  char\tt_%s[%d];\n", vname[count], temp2[1]+1;
-               if ($1 == "signature") {
+               if ($1 == "signature" || $1 == "sid") {
                        vtype[count]="bin";
-                       printf "  EXEC SQL VAR t_signature IS STRING(%d);\n", temp2[1]+1;
+                       printf "  EXEC SQL VAR t_%s IS STRING(%d);\n", vname[count], temp2[1]+1;
                } else vtype[count]="str";
                vsize[count] = temp2[1]+1;
        } else if ($2 ~ /DATE/) {