1# $Id: sqltool.properties 4809 2011-11-20 21:12:35Z unsaved $ 2 3# Default Locale String resources for SqlTool. 4 5# IMPORTANT: Make sure to use ISO-8859-1 encoding for any extended characters, 6# both in this file (actually any .properties file) and all referenced text 7# files. 8 9# GENERAL .properties SYNTAX: 10# White space AT END OF LINES IS SIGNIFICANT 11# White space at beginning of lines is not 12# \ at very end of line makes the following line a continuation line (with 13# no implied newline in the value. 14# (Combined with the previous 2 rules, this means that white space before 15# this \ is significant, and whitespace at beginning of continutation lines 16# is not). 17# \n does not work as an escape. Use unicode \u000a for line breaks instead. 18 19# This file is loaded by RefCapablePropertyResourceBundle, so if any 20# property here has no value set, the value MUST be set in a file 21# located at sqltool/PROPERTYNAME.text 22# Property keys MAY NOT CONTAIN UNDERSCORE. Underscores in Enum constants 23# will automatically be transated to dots. 24 25# These empty-vals tell RefCapablePropertyResourceBundle to look for text files: 26SqlTool.syntax= 27SqlFile.banner= 28buffer.help= 29special.help= 30pl.help= 31pl.control= 32pl.assign= 33dsv.options= 34d.options= 35raw.leadin= 36errorat= 37rejectreport.top= 38rejectreport.row= 39rejectreport.bottom= 40macro.help= 41 42# Traditional inline .properties values: 43rawmode.prompt=raw 44SqlTool.varset.badformat=Variable settings not of format "name=value[,...]". 45SqlTool.abort.continue.mutuallyexclusive=Switches '--abortOnErr' and \ 46 '--continueOnErr' are mutually exclusive. 47SqlTool.params.redundant=Redundant command-line switch(es) specified. \u000a\ 48 Use '--help' switch for syntax help. 49sqltempfile.fail=Failed to write given sql to temp file.\u000aCause: %{1} 50rcdata.inlineurl.missing='url' element is required for inline RC arg. 51rcdata.inline.extravars=Unsupported inline element(s) supplied: %{1}. 52rcdata.inlineusername.missing='user' element is required for inline RC arg. 53rcdata.password.visible='password' element must have empty value. \ 54 For non-empty password, give no\u000a\ 55 password element and you will be prompted for the value. 56password.readfail=Failed to read in password.\u000aCause: %{1} 57rcdata.genfromvalues.fail=Failed to generate RCData from given values.\u000aCause: %{1} 58conndata.retrieval.fail=Failed to retrieve connection info for urlid "%{1}".\u000aCause: %{2} 59jdbc.established=JDBC Connection established to a %{1} v. %{2} database\u000a\ 60 as "%{3}" with %{4} Isolation. 61connection.fail=Failed to get a connection to '%{1}' as user "%{2}".\u000aCause: %{3} 62# Value for following line has trailing whitespace on purpose. 63passwordFor.prompt=Enter password for %{1}: 64raw.movedtobuffer=Raw SQL chunk moved into edit buffer. Run ":;" to execute the chunk. 65input.movedtobuffer=Current input moved into edit buffer. 66sqlstatement.empty=Empty SQL Statement. 67causereport=Cause: %{1} 68break.unsatisfied=Unsatisfied 'break' statement (type %{1}). 69continue.unsatisfied=Unsatisfied 'continue' statement%{1:+ (type '%1')}. 70input.unterminated=Unterminated input: "%{1}" 71primaryinput.accessfail=Error accessing primary input. 72aborting=Aborting SqlTool: %{1} 73plvar.set.incomplete=Did not finish setting variable '%{1}' before a code block exited. 74rollingback=Rolling back SQL transaction. 75bufhist.unspecified=No command specified. Run ":?" to list Edit-Buffer/History Commands. 76special.unspecified=No command specified. Run "\\?" to list Special Commands. 77buffer.executing=Executing command from edit buffer:\u000a"%{1}"\u000a 78nobuffer.yet=No edit buffer contents yet. 79commandnum.malformat=Malformatted command number "%{1}". 80buffer.restored=Restored following command to buffer. Enter ":?" to list buffer commands.\u000a%{1} 81substitution.malformat=Malformatted substitution command. 82substitution.nomatch=Edit buffer unchanged due to no pattern match. 83substitution.syntax=Substitution syntax: ":s/from regex/to string/igm;". \ 84 Optional modes i, g, m, ;. 85buffer.unknown=Unknown Edit-Buffer/History command ":%{1}". 86dsv.x.syntax=Export syntax: "\\x table_or_view_name " OR "\\x SELECT statement".\u000a\ 87 OR for CSV-style double-quoting: "\\xq tbl_view_name " OR "\\xq SELECT stmt".\u000a\ 88 (Do not end with ';', since the \\x command itself is not SQL). 89dsv.m.syntax=Import syntax: \\m file/path.dsv [*]\u000a\ 90 OR \\mq file/path.csv [*] (for CSV-style double-quoting)\u000a\ 91* means no comments in DSV file. 92special.extrachars=Extra characters after "\\%{1}" command: %{2} 93buffer.extrachars=Extra characters after ":%{1}" command: %{2} 94special.malformat=Malformatted special command. 95html.mode=HTML Mode is now set to %{1}. 96dsv.targetfile.demand=You must set PL variable '*DSV_TARGET_FILE' in order to use the query variant of \\x. 97file.wrotechars=Wrote %{1} characters to file '%{2}'. 98file.writefail=Failed to write to file '%{1}'. 99file.appendfail=Failed to append to file '%{1}'. 100destfile.demand=You must supply a destination file name. 101special.d.like=Describe commands must be like '\\dX' or like '\\d OBJECTNAME'. '\\d?' to list. 102outputfile.nonetoclose=There is no query output file to close. 103outputfile.reopening=Closing current query output file and opening new one. 104outputfile.header=Query output from %{1}. 105buffer.empty=No command in edit buffer. 106sqlfile.name.demand=You must supply an SQL file name. 107sqlfile.execute.fail=Failed to execute contents of SQL file '%{1}'. 108a.setting=Auto-commit is set to %{1}. 109committed=Session committed. 110special.b.malformat=Malformatted binary command. 111binary.loadedbytesinto=Loaded %{1} bytes into Binary buffer. 112binary.filefail=Failed to load/dump binary data to file '%{1}'. 113c.setting=Continue-on-error is set to %{1}. 114bang.incomplete=You must follow ! with the external command to run. 115bang.command.fail=External command failed:\u000a"%{1}" 116special.unknown=Unknown Special command "\\%{1}". 117raw.empty=Raw statement aborted (no input given). 118dsv.nocolsleft=No remaining columns after omitting %{1:+"%1" and }"-" columns. 119dsv.skipcols.missing=The following skip column(s) not present: %{1}. 120plalias.malformat=Malformed PL alias usage. 121plvar.undefined=Undefined PL variable "%{1}". 122var.infinite=Possible infinite variable regress involving '%{1}'. 123sysprop.empty=Empty System Property variable name. 124sysprop.unterminated=Unterminated System Property variable name. 125sysprop.undefined=Undefined System Property "%{1}". 126plvar.nameempty=Empty PL variable name. 127plvar.unterminated=Unterminated PL variable name. 128pl.malformat=Malformatted PL command. 129deprecated.noop=Deprecated command has no effect. Please remove: %{1}. 130end.noblock=Unmatched 'end' command. 131continue.syntax=PL 'continue' statement requires no argument or one of \ 132 'foreach', 'while'. 133break.syntax=PL 'break' statement requires no argument or one of \ 134 'foreach', 'if', 'while', 'file'. 135pl.list.parens=Listing all 'set' variables (any var not seen is unset and equal to null).\u000a\ 136 The outermost parentheses are not part of the values. 137pl.list.lengths=Listing all 'set' variables (any var not seen is unset and equal to null).\u000a\ 138 Showing variable names and length of values (use 'listvalues' to see values). 139dumpload.malformat=Malformatted PL 'dump' or 'load' command. 140plvar.nocolon=PL variable names may not contain ':'. 141plvar.tildedash.nomoreargs=PL ~/_ set commands take no other args ("%{1}"). 142dumpload.fail=Failed to dump/load variable '%{1}' to/from file '%{2}'. 143pl.malformat.specific=Malformatted PL '%{1}' command. 144pl.block.fail=Failed to execute instructions from PL block. 145ifwhile.malformat=Malformatted PL 'if'/'while' command. 146pl.unknown=Unknown PL command "%{1}". 147pl.block.unterminated=Unterminated PL '%{1}' block 148vendor.oracle.dS=*** WARNING:\u000a\ 149 *** Listing tables in system-supplied schemas since\u000a\ 150 *** Oracle (TM) doesn't return a JDBC system table list. 151vendor.derby.dr=Derby has not implemented SQL Roles. 152vendor.nosup.d=SqlFile does not yet support \\d%{1} for your database vendor. 153vendor.derby.du=It's impossible to get a reliable user list from Derby. 154special.d.unknown=Unknown describe option: '%{1}'. 155metadata.fetch.fail=Failed to get metadata from database. 156metadata.fetch.failfor=Failed to get metadata from database for '%{1}'. 157prepare.demandqm=Prepared statements must contain one '?'. 158binbuffer.empty=Binary SqlFile buffer is empty. 159vendor.nosup.sysschemas=*** WARNING:\u000a\ 160 *** Omitting tables from system-supplied schemas\u000a\ 161 *** (because DB vendor doesn't differentiate them to JDBC). 162noresult=No result. 163dsv.bincol=Table has a binary column. DSV files are text, not binary, files. 164binbuf.write=Read %{1} bytes from field '%{2}' (type %{3}) into binary buffer. 165rows.fetched=Fetched %{1} rows. 166rows.fetched.dsv=%{1} row(s) fetched from database. 167row.update.multiple=%{1} rows updated. 168row.update.singular=1 row updated. 169history.unavailable=Command history not available. 170history.none=No history yet. 171editbuffer.contents=Edit buffer contents:\u000a"%{1}" 172buffer.instructions=Copy a command to edit buffer like ":27" or ":-3". \ 173 Re-execute buffer like ":;". 174history.number.req=You must specify a positive absolute command number, or \ 175 a negative number\u000ameaning X commands "back". 176history.backto=History only goes back to #%{1}. 177history.upto=History only goes up to #%{1}. 178history.back=History only goes back %{1} command(s). 179describe.table.name=NAME 180describe.table.datatype=DATATYPE 181describe.table.width=WIDTH 182describe.table.nonulls=NO-NULLS 183describe.table.precision=PRECISION 184describe.table.scale=SCALE 185logical.unrecognized=Unrecognized logical operation. 186read.toobig=Resource is too big to read in one gulp.\u000a\ 187 Please run the program with more RAM (try Java -Xm* switches). 188read.partial=Didn't read all bytes. Read in %{1} bytes out of %{2}. 189read.convertfail=Value too big to convert to String. \ 190 Please run the program with more RAM (try Java -Xm* switches). 191dsv.coldelim.present=Table data contains our column delimiter '%{1}'. 192dsv.rowdelim.present=Table data contains our row delimiter '%{1}'. 193dsv.nullrep.present=Table data contains our null-representation token '%{1}'. 194dsv.constcols.nullcol=*DSV_CONST_COLS element has null column name. 195file.readfail=Can't read file '%{1}'. 196inputfile.closefail=Failed to close input file. 197dsv.header.none=No header record in input file. 198dsv.header.noswitchtarg=Headerswitch at DSV file line %{1}, but no target table specified yet. 199dsv.header.noswitchmatch=Reached close of headerswitch at DSV file line %{1} without matching a header. 200dsv.header.nonswitched=Header line inside switch without table matcher at DSV file line %{1}. 201dsv.nocolheader=No column header for column #%{1} at DSV file line %{2}. 202dsv.metadata.mismatch=Metadata mismatch for columns. 203query.metadatafail=Failed to get metadata for query by using:\u000a"%{1}" 204dsv.rejectfile.setupfail=Failed to set up reject file '%{1}'. 205dsv.rejectreport.setupfail=Failed to set up reject report file '%{1}'. 206none=None 207insertion.preparefail=Failed to prepare insertion setup string:\u000a"%{1}" 208dsv.header.matchernonhead=Non-Header line within table matcher block at DSV file line %{1}. 209dsv.colcount.mismatch=Header has %{1} columns, but input record has %{2} column values. 210dsv.insertcol.mismatch=Expected total of %{1} insert values, but gathered %{2}. 211dsv.nonskip.mismatch=Header has %{1} non-skip columns, but input record has %{2} insertion values. 212time.bad=Bad date/time value '%{1}'. 213boolean.bad=Bad boolean value '%{1}'. 214inputrec.modified=%{1} rows modified by this input record. 215dsv.recin.fail=Parse or insert of input line %{1} %{2:+, column '%2' }failed. 216dsv.import.summary=Import summary (%{1}skips / rejects / inserts): \ 217 %{2} / %{3} / %{4}%{5:+ before aborting}. 218insertions.notcommitted=Insertions will be lost if you don't commit. 219autocommit.fetchfail=Failed to obtain connection autocommit value. 220dsv.rejectfile.purgefail=Failed to purge unnecessary reject file '%{1}'. 221dsv.rejectreport.purgefail=Failed to purge unnecessary reject report '%{1}'. 222edit.malformat=Edit/History command malformatted. 223input.malformat=Syntax error in input. 224append.empty=Use ':;' to repeat a command without appending 225transiso.report=Transaction Isolation Level is now %{1} %{2} 226exectime.reporting=Execution-time reporting is set to %{1} 227exectime.report=Took %{1} ms. 228regex.malformat=Malformed regex pattern: %{1} 229encode.fail=Unsupported encoding: %{1} 230macro.tip=Run /? for Macro help 231macrodef.malformat=Malformatted macro def. command 232macrodef.empty=No content specified for macro 233macrodef.semi=Macro values may not end with ';' 234macro.malformat=Malformatted macro command 235macro.undefined=No macro defined with name "%{1}". 236log.syntax=SYNTAX: \\l LEVEL Message\u000a\ 237 Where LEVEL is one of: FINEST, FINER, INFO, WARNING, SEVERE 238log.syntax.error=Logging syntax error. Run '\\l?' for help 239reject.rpc=Clearing *DSV_RECORDS_PER_COMMIT, since non-integer specified: %{1} 240rpc.autocommit.failure=Failed to set up autocommit for *DSV_RECORDS_PER_COMMIT option 241rpc.commit.failure=Failed to finalize commit status for *DSV_RECORDS_PER_COMMIT option 242disconnect.success=Disconnected from JDBC Data Source 243disconnect.failure=Failed to disconnect from JDBC Data Source 244no.required.conn=We are not connected to a Data Source, but one is required for this action 245disconnected.msg=<UNCONNECTED> 246connected.fallbackmsg=<CONNECTED> 247no.vendor.schemaspt=Database does not support SQL-standard SCHEMA operations 248schemaname.retrieval.fail=Failed to retrieve current SCHEMA name from database 249remove.empty.vars.suggestset=Unsetting variable.\u000a\ 250 You are advised to NOT set Java system property 'sqltool.REMOVE_EMPTY_VARS',\u000a\ 251 and simply use the command '* - VARNAME' to explicitly unset/remove variables. 252auto.unset.warning=Unsetting variable '%{1}'. You should not have this set to an empty string. 253pl.unset.nomoreargs=PL ! unset command takes no arg other than the var name 254dsv.q.nodblquote=\\xq and \\xm prohibit delimiters containing '"' 255connect.failure=Failed to connect 256streamread.failure=Failed to read value using stream 257illegal.at=Leading @ in file paths has special meaning, and may only be used if input is a file. 258suggest.j=To connect to a data source, use '\\j urlid' or '\\j account password jdbc:url...' 259pipeclose.failure=Failed to close pipes: %{1} 260arrayimp.jvmreq=SqlTool requires >= Java 1.6 at run time in order to import Array values 261arrayval.malformat=Malformatted ARRAY value: (%{1}) 262sqlarray.badjvm=SqlTool binary is not Array-compatible with your runtime JRE. Array imports not possible. 263csv.coldelim.present=CSV-style quoting is only suitable for text files, but your file contains\u000a\ 264 character '%{1}'. 265csv.quote.unterminated=Unterminated CSV-style "-quoted field at data file line #%{1} 266math.expr.fail=Math expression failure: %{1} 267varname.warning=Variables not beginning with a letter or containing a character other\u000a\ 268 than letters, digits, and _, are deprecated.\u000a\ 269 (Excepting reserved PL variables, which begin with *).:\u000a\ 270 %{1} 271null.assignment=You may never assign a value to variable 'NULL' or '*NULL'.\u000a\ 272 These variables always have the value of null, which is different from\u000a\ 273 the empty string. 274bad.time.format=Malformatted date/time format string.\u000a\ 275 %{2}: %{1}\u000a\ 276 An useful example is: yyyy-MM-dd'T'HH:mm:ss.SSSZ\u000a\ 277 Reference for formatting available at\u000a\ 278 http://download.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html 279no.timestamp.format=You can't expand *TIMESTAMP unless *TIMESTAMP_FORMAT has been set 280else.without.if='else' statement not at top level of an if block 281import.col.dup=Multiple input columns for single output database column: %{1} 282