Re: RCS and Oracle?

In article <2226_at_uswnvg.UUCP> cjackso_at_nv6.uswnvg.com (Clay Jackson) writes:
>j9z_at_ornl.gov (John Martellaro) writes:
>:
>: 1. Does Oracle work the same way?
>I'm not 100% sure what you mean by 4GL, but Oracle has the OPTION of
>generating 'text' out of all of it's tools. Of course, SQL is no problem.
>SQL*FORMS will generate a file (at least in Unix) with an extension of
>'.inp' which is pure (printable) ascii, and that can be put into a
>code management system. I'm not sure about SQL*REPORTWRITER (it's
>been a while) but as I recall it can generate straight ascii, which could
>then be put into a CMS.
>

SQL*ReportWriter can generate an ASCII file with the dumprep command (.rex), but we encountered a problem with storing the .rex file in SCCS. The SQL text of a query in a query block is stored on a single line. If you have long query statements, these long lines extend beyond the line lenght limit of SCCS (1024 characters on our system). I do not know if RCS has the same limitation. To date, we have not resolved how we are going to do change control for our reports development - it may be necessary to preserve historical copies (versions) of the .rex file as separate text files. If anyone has found another work around to this problem, I would sure appreciate hearing about it. Thanks...

                                        ...jeff Received on Thu May 14 1992 - 18:52:51 CEST