Maximo

 View Only

db2look in DB2 11.5 LUW for procedures

  • 1.  db2look in DB2 11.5 LUW for procedures

    Posted 22 days ago

    Hello- 

    I'm new to DB2. I'm using db2look to generate DDL for schema and then excute the output sql file onto a different database server. I'm using the following code:

    db2look -d <DB_NAME> -cor -e -l -x -z <schema_name> -o output.sql

    The sql file is breaking the create procedure <PROC_NAME> into multiple lines and when this file is used to execute the procedures are failing to create. If I manually making the 'create procedure <PRO_NAME> into a single line with the help of file editors the execute working fine. 

    Question: Is there a setting or flag that I'm not using ? 



    ------------------------------
    Vinay S
    ------------------------------