2326023 - SQL0601

Case 1) During a table conversion, the ALTER TABLE statement fails with SQL0601 while creating the Primary key.

    In the activation log, you find the following error

    | sql: |
    | | ALTER TABLE R3<SID>DATA/'<table_name>' |
    | | ADD CONSTRAINT '<table name>+0' primary key |
    | | ('MANDT', |
    | | 'DOCID', |
    | | 'ITEMID') |
    | | SQL0601 - "<table_name>+0" in R3<SID>DATA type *N already exists
    | | ts. (582346/<SID>ADM/WPXX) |
    | | DDL Time(___2): ........70 milliseconds |
    | | The SQL statement was not executed |
    | | Statements for Table <table_name> could not be executed |
    | | Request for <table_name> could not be executed |

    Where <SID> is the System ID of the SAP system and <table_name> is the SQL table name

================================================================================

Case 2) During an update with SUM, you may encounter the problem in the DBCLONE phase. The logs show a number of tables are affected.

ALTER TABLE R3<SID>DATA/"/OSP/T_RAUI_CTGT?" ADD CONSTRAINT "/OSP/T_RAUI_CTGT+0" primary key ("MANDT", "LANG", "CAT_ID") 
1EETGCLN 
SQL0601 - "/OSP/T_RAUI_CTGT+0" in R3<SID>DATA type *N already exists. (543551/<SID>ADM/WP14) 
1EETGCLN /OSP/T_RAUI_CTGT 
1EETGCLN 
Error when cloning table structure

  Where <SID> is the System ID of the SAP system and <table_name> is the SQL table name

                                        
================================================================================

Case 3) During an update with SUM, in rare conditions an SQL0601 can be observed for SAP tables or views

SQL-error "-601-SQL0601 - "/UIF/LREPVC" in R3<SID>DATA type *FILE already exists.

In some cases, querying the catalog view SYSTABLES or SYSVIEWS does not find the system name of the object.

================================================================================

Case 4) During an SP update with SPAM, the creation of database views ends with SQL0601 (File already exists) and SQL0204 (File not found)

================================================================================

AS/400, OS/400, system i, i5/OS, IBM i, Import_Proper, RC 08, return code 8 , KBA , BC-DB-DB4 , DB2 for AS/400 , BC-OP-AS4 , IBM AS/400 , Problem