Some future directions

I've received a few requests for some future directions of Jisql and wanted to post them here so there there are no duplicates. These are in no particular order.

addition of a batch mode (no pretty output)
a column separator can be choosen in batch mode
addition of the JConnect6 shortcut
HTML/XML output
CSV output
Any character that cannot be printed with the current charcter set should print with the unicode code

If anyone has anything else let me know.

Taking my cue from text handling products like MS ODBC Text, J-Stels, HXTT:

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

David,
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!

Hi Scott,
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.

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

Thanks,
Scott Leavitt
VMware

Uh... so maybe I should read the home page more closely

I got it working by inserting the argument in my batch file (carriage returns added to wrap this long command line).

Thanks Scott for including this feature!

Scott