dbimport fails due to excessively long lines

Hi Everyone dbimport fails due to excessively long lines, caused by PowerBuilder stripping format chars from the code. How can i reformat the stored procedures? Is there a code-beautifier, or another way to move stored procs from IO5.1 to IO9.14? (p.s. we don't have PowerBuilder) Thanks in advance! edward

edward wrote: > > Hi Everyone > > dbimport fails due to excessively long lines, caused by PowerBuilder > stripping format chars from the code. > How can i reformat the stored procedures? Is there a code-beautifier, or > another way to move stored procs from IO5.1 to IO9.14? > (p.s. we don't have PowerBuilder) You could write a fairly simple awk or perl script to wrap long lines. Art S. Kagel

Edit the SQL file in your DB Export directlry. Move anything after (and including) the first Create Procedure statement to another file. Run DB Import. Run DBAccess with the database name and the new file name on the command line. Bashar Chalabi CTL, London edward wrote in message <374D0DF4.C372DB4E@energetic.uct.ac.za>... >Hi Everyone > >dbimport fails due to excessively long lines, caused by PowerBuilder >stripping format chars from the code. >How can i reformat the stored procedures? Is there a code-beautifier, or >another way to move stored procs from IO5.1 to IO9.14? >(p.s. we don't have PowerBuilder) > >Thanks in advance! > >edward > >