Page 1 of 1
Preserve DB2 SQL comment lines
Posted: Mon Sep 06, 2004 5:54 am
by mleroux
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.
Posted: Mon Sep 06, 2004 6:19 am
by kduke
We leave comment lines in Oracle and it works fine. I am not sure about DB2 or other databases.
Posted: Mon Sep 06, 2004 6:19 am
by denzilsyb
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.
Posted: Mon Sep 06, 2004 8:06 am
by mleroux
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.