Interoperability Decision need to made for interpreting the SIARD 2.1 and 2.2, to state if a second subfolder is allowed for LOBs within the SIARD package with Internal LOBs. Is this within the interpretation of the SIARD specification or should a validator report it as an ERROR?
For SIARD with External LOBs som tools allows the user to specify the number of files per folder, f. ex. max 1000 files per subfolder due to handling problems if too many files are placed in the same folder.
Full Convert as SIARD tool use a fixed 1000 files per subfolder both for External LOBs and for Internal LObs, adding a second subfolder below the lob[n] main LOB column folder for the files.
DBPTK Developer v2.9.9 validator report ERROR on this structur for Internal LOBs inside a SIARD package:
Example 1: content/schema0/table3/lob6/seg0/rec1.bin
While using only the lob6 subfolder validates
Example 2: content/schema0/table3/lob6/rec1.bin
P_4.2-3
The individual table folders contain an XML file and an XSD file, the names of which (folder designation and both file names) must be identical. With the ex-ception of BLOB and CLOB folders together with their content (BIN, TXT, or XML files, or a file extension associated with the MIME type of the lob files in case this is known, e.g. JPG), no other folders or files are permitted.
Interoperability Decision need to made for interpreting the SIARD 2.1 and 2.2, to state if a second subfolder is allowed for LOBs within the SIARD package with Internal LOBs. Is this within the interpretation of the SIARD specification or should a validator report it as an ERROR?
For SIARD with External LOBs som tools allows the user to specify the number of files per folder, f. ex. max 1000 files per subfolder due to handling problems if too many files are placed in the same folder.
Full Convert as SIARD tool use a fixed 1000 files per subfolder both for External LOBs and for Internal LObs, adding a second subfolder below the lob[n] main LOB column folder for the files.
DBPTK Developer v2.9.9 validator report ERROR on this structur for Internal LOBs inside a SIARD package:
Example 1: content/schema0/table3/lob6/seg0/rec1.bin
While using only the lob6 subfolder validates
Example 2: content/schema0/table3/lob6/rec1.bin
P_4.2-3
The individual table folders contain an XML file and an XSD file, the names of which (folder designation and both file names) must be identical. With the ex-ception of BLOB and CLOB folders together with their content (BIN, TXT, or XML files, or a file extension associated with the MIME type of the lob files in case this is known, e.g. JPG), no other folders or files are permitted.