In this blog post, let’s learn about the error message “20072 First character of the field delimiter must be different than the first character of the row delimiter.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20072 First character of the field delimiter must be different than the first character of the row delimiter.
Reason for the Error
The field delimiter and row delimiter strings that you specified, either at the command line or in the DELIMITED FORMAT section of the format file, start with the same character. When only one of them is specified at the command line, the value for the other delimiter is either the default value, as specified in the IMPORT topic of the SQL/MX Reference Manual, or the value specified in the DELIMITED FORMAT section of the format file.
Solution
Specify a row delimiter and field delimiter that start with a different character and resubmit. If you specify only one at the command line, it should not start with the same character as the other delimiter
