http://forums.hotjoe.com/posts/list/28.page JForum - http://www.jforum.net
<ul><li>addition of a batch mode (no pretty output)</li><li>a column separator can be choosen in batch mode</li><li>addition of the JConnect6 shortcut</li><li>HTML/XML output</li><li>CSV output</li><li>Any character that cannot be printed with the current charcter set should print with the unicode code</li></ul>

If anyone has anything else let me know.]]> http://forums.hotjoe.com/posts/preList/94/298.page http://forums.hotjoe.com/posts/preList/94/298.page GMT
There should be an option for Header supression: yes/no

The delimiter choice should support escapes allowing any charater or string of characters. You should be able to set it whether you are generating delimited or rectangular output.

When making a delimited file, there should be no underlining or overlining and, optionally, one or no header line of column names. If names are requested, any blank labels should be populated with default values like COL_#.

The leading and trailing row column delimiters never appealed to me, although I guess they form a pretty box. Maybe they could be optional.

Padding the column delimiters with spaces never appealed to me, although I guess they give extra visual separation. Maybe they could be optional.

Headings on longvarchar are currently right justified, should probably be right for integers, centered for scalar and float presentations, left for char types.

Always but especially when generating delimited output, the user should be able to control NULL handling, by optionally supplying a desired string for NULL presentation in lieu of empty, by optionally asking for trimming, by optionally ensuring no char column is trimmed to empty when blank when empty is the NULL presentation.

BTW, columns are being truncated to 15 positions for varchar(-1), even with -w 50. Also with longvarchar(20), even with -w 50, but that's a bit less your problem.

Best regards,

David]]> http://forums.hotjoe.com/posts/preList/94/327.page http://forums.hotjoe.com/posts/preList/94/327.page GMT Thanks for the ideas. I'm working on getting these and some other suggestions implemented and hope to have something pretty soon. If you come up with any other ideas please feel free to post them.

Thanks!]]> http://forums.hotjoe.com/posts/preList/94/329.page http://forums.hotjoe.com/posts/preList/94/329.page GMT I just found your Jisql utility, very nice.
In reference to the jisql future features, is this one available yet?

addition of a batch mode (no pretty output)

I'd like to be able to execute a java command to start Jisql with parameters to:
1) read an input text file (sql script)
2) write an output text file (sql output)
Then automatically quit, setting the DOS errorlevel with nonzero if the SQL returned errors.

What I'm trying to do is repeatedly check for a database table to be emptied by the application under test, then use that condition to tell the application under test to load the table with more data.

i.e.
[code]select count(*) from workflowcontributedocument;[/code]

When this returns zero rows, I'll issue a command to the app under test to load more data.

Thanks,
Scott Leavitt
VMware]]> http://forums.hotjoe.com/posts/preList/94/1453.page http://forums.hotjoe.com/posts/preList/94/1453.page GMT
I got it working by inserting the [code]-input[/code] argument in my batch file (carriage returns added to wrap this long command line).

[code]
java -classpath lib/jisql.jar;../jtds-1.2-dist/jtds-1.2.jar
com.xigole.util.sql.Jisql
-user scott
-password mypasswd
-driver net.sourceforge.jtds.jdbc.Driver
-cstring jdbc:jtds:sqlserver://myserver:1433/my_database
-input wfcd.sql
-c ;
[/code]

Thanks Scott for including this feature!

Scott]]> http://forums.hotjoe.com/posts/preList/94/1454.page http://forums.hotjoe.com/posts/preList/94/1454.page GMT