EXEC SQL BEGIN DECLARE SECTION;
char label[FILESYS_LABEL_SIZE], path[FILESYS_NAME_SIZE];
char type[FILESYS_TYPE_SIZE], key[FSGROUP_KEY_SIZE];
+ char alias[ALIAS_NAME_SIZE];
int status, fid;
EXEC SQL END DECLARE SECTION;
EXEC SQL CLOSE group_cursor;
}
+ EXEC SQL DECLARE alias_cursor CURSOR FOR
+ SELECT name INTO :alias FROM alias
+ WHERE type='FILESYS' AND trans=:label;
+
if (!*strtrim(path))
continue;
fprintf(out, "%s:%s\n", label, path);
+
+ EXEC SQL OPEN alias_cursor;
+ while (1)
+ {
+ EXEC SQL FETCH alias_cursor INTO :alias;
+ if (sqlca.sqlcode)
+ break;
+
+ if (!*strtrim(alias))
+ continue;
+ fprintf(out, "%s:%s\n", alias, path);
+ }
+ EXEC SQL CLOSE alias_cursor;
}
EXEC SQL CLOSE filsys_cursor;