FileLayout Facts
FIXED format
Be careful when you change the length or starting position of any file fields, or if you insert a new file field between two existing ones. It’s possible to overlay fields. Results are unpredictable.
When you insert a record into a file layout, fields of type Long are converted to type Character, with a length of 0. You must set a field length greater than 0 before you can save the file layout.
CSV format
• Both the qualifier and the delimiter accept a blank as a valid value.
• If a field is NULL, you don't have to use qualifiers. In the following example, Field2 is NULL.
Field1,,Field3,Field4. .
XML Format
• Your XML input file must contain at least the fields that are specified in the file layout definition you’re using. If the file is missing any fields, the input rowset won’t contain any data.
• If your XML input file contains extra fields that aren’t specified in the file layout definition, the ReadRowset method will ignore the extra fields.
• When you insert a record into a file layout, fields of type Long are converted to type Character, with a length of 0. You must set a field length greater than 0 before you can save the file layout.
Be careful when you change the length or starting position of any file fields, or if you insert a new file field between two existing ones. It’s possible to overlay fields. Results are unpredictable.
When you insert a record into a file layout, fields of type Long are converted to type Character, with a length of 0. You must set a field length greater than 0 before you can save the file layout.
CSV format
• Both the qualifier and the delimiter accept a blank as a valid value.
• If a field is NULL, you don't have to use qualifiers. In the following example, Field2 is NULL.
Field1,,Field3,Field4. .
XML Format
• Your XML input file must contain at least the fields that are specified in the file layout definition you’re using. If the file is missing any fields, the input rowset won’t contain any data.
• If your XML input file contains extra fields that aren’t specified in the file layout definition, the ReadRowset method will ignore the extra fields.
• When you insert a record into a file layout, fields of type Long are converted to type Character, with a length of 0. You must set a field length greater than 0 before you can save the file layout.
Comments
Post a Comment