RE: GENERATE_SQL problem

See below.

Thanks,
Michael Quigley
Computer Services
www.TheWay.org

-----Original Message-----
message: 3
date: Sun, 25 Jan 2026 20:54:37 +0100
from: Daniel Gross <daniel@xxxxxxxx>
subject: Re: GENERATE_SQL problem

In fact, the docs


https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fww
w.ibm.com%2Fdocs%2Fen%2Fi%2F7.6.0%3Ftopic%3Dservices-generate-sql-
procedure&data=05%7C02%7Cmichaelquigley%40theway.org%7C36a1bb6e6
c094054829c08de5d04bed8%7Cdfc3789155b94fe0bc8b34a0f4b6650f%7C0%7C
0%7C639050472184022479%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hc
GkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIld
UIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=YdFXNM5LCI%2FIEqk%2Fv3jWtQ
hWq7dHOLIGKY%2FGH%2B%2BgKUs%3D&reserved=0

are stating this explicitly - quote:

If values are provided for database-source-file-library-name, database-

source-file-name, and database-source-file-member the object must exist.

[Michael Quigley] @Daniel: I'm sure that's referring to the database object you're getting the source from. Also in the docs under "Authorization:"
To add a member:

- *OBJOPR and *ADD to the source physical file

To replace a member:

- *OBJOPR, *DELETE, *ADD, and either *OBJMGT or *OBJALTER to the source physical file

If it requires that you have *OBJOPR and *ADD authority to add a member, the member wouldn't have to exist.

@David:
Could there be some extraneous characters in the host variables? I would debug the program and monitor the variables in hex to see.