Trying to write a DB2 grant statement. Trouble with double-quotes

[Alhowarth]

Hello,

I'm trying to write a grant statement for a few hundred tables in DB2. I love doing this in Excel as it's so easy once you get the formula. Although I am having trouble with the double quotes that DB2 uses since Excel uses that to break out of a Concatenate.

Here is a sample statement: GRANT SELECT, INSERT, UPDATE, ALTER, DELETE ON TABLE "schemaname"."tablename" TO USER "JohnDoe" WITH GRANT OPTION;

schema name will be A1 and tablename will be A2. JohnDoe will be hard-coded/constant.

Any help would be greatly appreciated.

[daffodil11]

="GRANT SELECT, INSERT, UPDATE, ALTER, DELETE ON TABLE """&A1&"""."""&A2&""" TO USER ""JohnDoe"" WITH GRANT OPTION;"

I write similar formulas often when trying to use brute force to manage all possible outcomes of a complicated IF statement.

[Alhowarth]

That did it! Thanks so much!

[daffodil11]

No problem. Concatenation in conjunction with standardizing formula writing is such a timesaver.

I can't even imagine what it would have been like to write the formula in S60 of this spreadsheet. -sweat-

holy concatenation batman.xlsx


Good times.