BrandonC Posted February 10, 2020 Report Share Posted February 10, 2020 I threw some code in the tool yesterday morning, and had a huge chunk of comments go missing. It might have something to do with a collect statement or the fact that the comments were a create table that was not necessary at the time, but left in the code in case it might be needed in the future. I don’t think that’s too uncommon. Here’s the original (simplified): SEL * FROM VOL_TABLE COLLECT STATISTICS COLUMN (DATE) ON VOL_TABLE; 30 lines of commented out code DELETE TABLE2 INSERT INTO TABLE2… The output has: SELECT * FROM PUBLIC.VOL_TABLE A single new line DELETE FROM ; INSERT INTO PUBLIC.TABLE2 Is that Collect statement throwing things off? Or just too many comments? I think the output is still functionally the same. Just curious as to why that would happen during the transformation. Thanks. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.