IBM Asset & Facilities Management Your destination for peer and expert insights to help unlock the power of data with AI and Asset & Facilities Management to advance your digital reinvention. Join / Log in
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 ?