HPE NonStop SQL/MX Error – 20087 One or more of the specified command-line arguments are not valid. Syntax: import catalog.schema.table -I input-file [-C number-of-rows] [-E error-file] [-F rows-to-skip] [-L max-errors] [-R multiple of trans-size] [-S] [-T trans-size] [-U format-file] [-W file-type] [-FD field-delimiter] [-QL field-qualifier] [-RD row-delimiter] [-Z character-set]

In this blog post, let’s learn about the error message “20087 One or more of the specified command-line arguments are not valid. Syntax: import catalog.schema.table -I input-file [-C number-of-rows] [-E error-file] [-F rows-to-skip] [-L max-errors] [-R multiple of trans-size] [-S] [-T trans-size] [-U format-file] [-W file-type] [-FD field-delimiter] [-QL field-qualifier] [-RD row-delimiter] [-Z character-set]” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20087 One or more of the specified command-line arguments are not valid. Syntax: import catalog.schema.table -I input-file [-C number-of-rows] [-E error-file] [-F rows-to-skip] [-L max-errors] [-R multiple of trans-size] [-S] [-T trans-size] [-U format-file] [-W file-type] [-FD field-delimiter] [-QL field-qualifier] [-RD row-delimiter] [-Z character-set]

Reason for the Error

One or more of the command line arguments that you specified were invalid.

Solution

See the SQL/MX Reference Manual for the correct parameters for the IMPORT command