Preserve DB2 SQL comment lines

mleroux · Post by **mleroux** » Mon Sep 06, 2004 5:54 am

Is there a way to preserve the comments from a DB2 SQL script when copying the SQL to DB2 stages in DataStage? DataStage complains about the standard double-hash (--) comment lines when trying to view the data.

It works fine when the comment lines are removed, however.

kduke · Post by **kduke** » Mon Sep 06, 2004 6:19 am

We leave comment lines in Oracle and it works fine. I am not sure about DB2 or other databases.

denzilsyb · Post by **denzilsyb** » Mon Sep 06, 2004 6:19 am

Hi morney

I fear that there is no way. (have you tried /* comments ?*/)

If that does not work, then you could do what we are currently doing to aid documentation and that is to paste the SQL into the description of the stage. this would mean you could save all the comments you could possibly need.

mleroux · Post by **mleroux** » Mon Sep 06, 2004 8:06 am

Hey Denzil

I believe you're just down the road. Hope all's going well over there!

Tried //, /*, *, !, #, etc. No joy, but it's not the end of the world. Maybe it is still possible, let's wait and see.