I am currently using the ProIV Report Viewer to view the spooled output of an sql query on a client-side screen and am trying to find out if there are any other p4 controls / mechanisms available (P4 v5.5) to view files on the client. I'm hitting the report width limit of 240, and while I can set the line width to 240 in the spooled sql output, for files with a large number of columns it look quite difficult to read - ideally I would like to be able to set the line to 9999 for the spooled sql output, and then use something that throws the output up on screen without hitting limits for report width, p4 file variable size limits, etc. I'd rather not send the file from the server to the client and run a system command to bring up notepad etc. Would be grateful for any suggestions.
File Viewer for files with long record lengths
1 reply to this topic
Posted 15 October 2009 - 11:36 AM
I found a solution for this that works for me - using Oracle's dbms_xmlgen.getxml to format the query results produces nice pretty printed xml that under most circumstances will work under the 240 char lenght restriction and also has the benefit of printing the full column names for the table, rather than truncating them to the length of the relevant column, as the standard output does.
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users