# #Fri Aug 16 18:13:40 IST 2013 aa.text=false ads.chart.jogl.antialias=true ads.chart.jogl.background=true ads.chart.jogl.buffer_size= ads.chart.jogl.debug.performance=false ads.chart.jogl.numsamples= ads.chart.jogl.offscreen= appearance.editorfont=Monospaced appearance.editorfontsize=12 appearance.editorfontstyle= appearance.gridresultsfont=Courier New appearance.gridresultsfontsize=12 appearance.gridresultsfontstyle= appearance.interface.language= appearance.textresultsfont=Monospaced appearance.textresultsfontsize=12 appearance.textresultsfontstyle= appearance2.alt-tab.navigation=true appearance2.ctrltabdocumentcycling=false appearance2.displaysplash=true appearance2.LAF=Aqua Data Studio AppFrame.confirmExit=true aquascript.maxConsole=3000 azure.autocommit=true azure.autocomplete=true azure.autoonallschemas2=true azure.bbssc=true azure.case=Default azure.columncompletionquoteidentifier=None azure.ddssc=true azure.driverParameter= azure.format.null=(null) azure.maxresults= azure.paramquery=false azure.qualifyobject=true azure.quoteidentifier=[object name] azure.ssssc=false azure.statementSeparator= azure.tablecompletionquoteidentifier=None azure.visualeditquoteident=true beautify.alignment.join=false beautify.alignment.operator=true beautify.indent.spaces=4 beautify.indent.useTab=true beautify.lineBreak.afterComma=true beautify.lineBreak.afterKeyword=true beautify.lineBreak.afterLogical=true beautify.lineBreak.beforeComma=false beautify.lineBreak.beforeLogical=false beautify.lineBreak.forBracket=true beautify.lineBreak.forCase=true beautify.lineBreak.lineLength=80 beautify.lineBreak.wrapLine=true beautify.show.options.dialog=true beautify.uppercase.fullSQL=false beautify.uppercase.keyword=true cassandra.autocommit=true cassandra.autocomplete=true cassandra.autoonallschemas2=true cassandra.bbssc=false cassandra.case=Default cassandra.columncompletionquoteidentifier=None cassandra.ddssc=false cassandra.driverParameter= cassandra.format.datatype.bigint=[Default] cassandra.format.null=(null) cassandra.maxresults= cassandra.paramquery=false cassandra.qualifyobject=false cassandra.quoteidentifier=None cassandra.ssssc=false cassandra.statementSeparator= cassandra.tablecompletionquoteidentifier=None cassandra.visualeditquoteident=true chart.enabled=true completion.aquascript=true completion.aquascript.autopopup=true completion.aquascript.autopopupdelay=500 completion.aquascript.instantsubstitution=false completion.aquascript.panemaxheight=300 completion.aquascript.panemaxwidth=800 completion.aquascript.paneminheight=34 completion.aquascript.paneminwidth=60 completion.autopopup=true completion.autopopupdelay=500 completion.globalcache=false completion.instantsubstitution=false completion.panemaxheight=300 completion.panemaxwidth=800 completion.paneminheight=34 completion.paneminwidth=60 completion.public_schema=true completion.synonyms=true CSystem.dateFormat= CSystem.dateTimeFormat= CSystem.timeFormat= db2_72.autocommit=true db2_72.autocomplete=true db2_72.autoonallschemas2=false db2_72.bbssc=false db2_72.case=Default db2_72.columncompletionquoteidentifier=None db2_72.ddssc=true db2_72.driverParameter= db2_72.format.datatype.bigint=[Default] db2_72.format.datatype.double=[None] db2_72.format.datatype.real=[None] db2_72.format.null=(null) db2_72.maxresults= db2_72.paramquery=false db2_72.qualifyobject=true db2_72.quoteidentifier=None db2_72.ssssc=false db2_72.statementSeparator= db2_72.tablecompletionquoteidentifier=None db2_72.visualeditquoteident=true db2_81.autocommit=true db2_81.autocomplete=true db2_81.autoonallschemas2=false db2_81.bbssc=false db2_81.case=Default db2_81.columncompletionquoteidentifier=None db2_81.ddssc=true db2_81.driverParameter= db2_81.format.datatype.bigint=[Default] db2_81.format.datatype.double=[None] db2_81.format.datatype.real=[None] db2_81.format.null=(null) db2_81.maxresults= db2_81.paramquery=false db2_81.qualifyobject=true db2_81.quoteidentifier=None db2_81.ssssc=false db2_81.statementSeparator= db2_81.tablecompletionquoteidentifier=None db2_81.visualeditquoteident=true db2_iseries.driverParameter= db2i.autocommit=true db2i.autocomplete=true db2i.autoonallschemas2=false db2i.bbssc=false db2i.case=Default db2i.columncompletionquoteidentifier=None db2i.ddssc=true db2i.format.datatype.bigint=[Default] db2i.format.datatype.double=[None] db2i.format.datatype.float=[None] db2i.format.datatype.real=[None] db2i.format.null=(null) db2i.maxresults= db2i.paramquery=false db2i.qualifyobject=true db2i.quoteidentifier=None db2i.ssssc=false db2i.statementSeparator= db2i.tablecompletionquoteidentifier=None db2i.visualeditquoteident=true db2zos.autocommit=true db2zos.autocomplete=true db2zos.autoonallschemas2=false db2zos.bbssc=false db2zos.case=Default db2zos.columncompletionquoteidentifier=None db2zos.ddssc=true db2zos.driverParameter= db2zos.format.datatype.bigint=[Default] db2zos.format.datatype.double=[None] db2zos.format.datatype.float=[None] db2zos.format.datatype.real=[None] db2zos.format.null=(null) db2zos.maxresults= db2zos.paramquery=false db2zos.qualifyobject=true db2zos.quoteidentifier=None db2zos.ssssc=false db2zos.statementSeparator= db2zos.tablecompletionquoteidentifier=None db2zos.visualeditquoteident=true debug.oracleJDIDebugger.profiling=false derby.autocommit=true derby.autocomplete=true derby.autoonallschemas2=false derby.bbssc=false derby.case=Default derby.columncompletionquoteidentifier=None derby.ddssc=true derby.driverParameter= derby.format.datatype.double=[None] derby.format.datatype.float=[None] derby.format.datatype.real=[None] derby.format.datatype.smallint=[Default] derby.format.null=(null) derby.maxresults= derby.paramquery=false derby.qualifyobject=true derby.quoteidentifier=None derby.ssssc=false derby.statementSeparator= derby.tablecompletionquoteidentifier=None derby.visualeditquoteident=true describe.indexes=true describe.permissions=true diff.color.added=\#ccffcc diff.color.changed=\#ccccff diff.color.deleted=\#ffcccc diff.dirdiff.file.contents.enabled=true diff.ignore.blanklines.enabled=false diff.ignorecase.enabled=false diff.trimleftspaces.enabled=false diff.trimmiddlespaces.enabled=false diff.trimrightspaces.enabled=false divider.size=3 editor.background=\#ffffff editor.bracesMatchColor=\#f3ff0f editor.caretInsertColor=\#000000 editor.caretOverwriteColor=\#000000 editor.expandtabs=true editor.forcewriteeol=Default editor.foreground=\#000000 editor.highlightbrace=true editor.highlightcaretrow=true editor.highlightcaretrowcolor=\#ffffdc editor.highlightedtextbackground=\#b4b4b4 editor.highlightedtextforeground=\#ffffff editor.inlineDiff=true editor.insertionpoint=Vertical Bar editor.insertionpointblinkrate=300 editor.linenumbers=true editor.overwritecaret=Solid Block Editor.recentFiles=D\:\\User\\Ashu\\Query_Builder\\scott.xqb\u0000D\:\\User\\Ashu\\Query_Builder\\scott_query.xqb editor.searchMatchColor=\#ffc800 editor.spacepertab=4 editor.statusbarvisible=true editor.tabsize=4 editor.textlimitline=true editor.textlimitlinecount=80 EditTableData.max=1000 EditTableData.prompt=false email.default.bcc= email.default.cc= email.default.from= email.queue.archived=false email.queue.enabled=false email.queue.paused=false email.smtpPassword= email.smtpPort=465 email.smtpServer=smtp.gmail.com email.smtpUseAuthentication=true email.smtpUsername= email.smtpUseSSL=true er.mouse.wheel.invert=false er.mouse.wheel.zoom=true er.rel.line.zoomedin.color=\#333333 er.rel.line.zoomedout.color=\#dcdcdc excel.format=excel2007 execmonitor.enablefortableeditor=false execmonitor.killtime=-1 execmonitor.snoozetime=180 execmonitor.warningtime=-1 execute.trimmed=true explain.criticalnode.1st.bgcolor=\#ff5938 explain.criticalnode.1st.fgcolor=\#000000 explain.criticalnode.2nd.bgcolor=\#00aeff explain.criticalnode.2nd.fgcolor=\#000000 explain.criticalnode.3rd.bgcolor=\#00ff00 explain.criticalnode.3rd.fgcolor=\#000000 explain.criticalnode.db2=true explain.criticalnode.mssql=true explain.criticalnode.oracle=true explain.criticaloper.1st.bgcolor=\#ff9c1b explain.criticaloper.1st.fgcolor=\#000000 explain.criticaloper.2nd.bgcolor=\#00d2ff explain.criticaloper.2nd.fgcolor=\#000000 explain.criticaloper.3rd.bgcolor=\#a6f092 explain.criticaloper.3rd.fgcolor=\#000000 explain.criticaloper.db2=false explain.criticaloper.mssql=false explain.criticaloper.oracle=false explain.criticalpath.bgcolor=\#c0c0c0 explain.criticalpath.db2=false explain.criticalpath.fgcolor=\#000000 explain.criticalpath.mssql=false explain.db2.createexplaintable=true explain.db2.dropexplaintable=false explain.oracle.commitwarning=true explain.oracle.createexplaintable=true explain.oracle.dropexplaintable=true explain.oracle.tablename=plan_table explain.oracle.tablenamedynamic=true explain.oracle.tableschema= explain.syb.ase..plantype=XML general.connection.threshold=10 general.disabledropineditor=false general.expendtop=true general.promptonreconnect=true genericjdbc.autocommit=true genericjdbc.autocomplete=true genericjdbc.autoonallschemas2=false genericjdbc.bbssc=false genericjdbc.case=Default genericjdbc.columncompletionquoteidentifier=None genericjdbc.ddssc=false genericjdbc.driverParameter= genericjdbc.format.datatype.double=[None] genericjdbc.format.datatype.float=[None] genericjdbc.format.datatype.integer=[Default] genericjdbc.format.null=(null) genericjdbc.maxresults= genericjdbc.paramquery=false genericjdbc.qualifyobject=true genericjdbc.quoteidentifier=None genericjdbc.ssssc=false genericjdbc.statementSeparator= genericjdbc.tablecompletionquoteidentifier=None genericjdbc.visualeditquoteident=true greenplum.autocommit=true greenplum.autocomplete=true greenplum.autoonallschemas2=true greenplum.bbssc=false greenplum.case=Default greenplum.columncompletionquoteidentifier=None greenplum.ddssc=false greenplum.driverParameter= greenplum.format.datatype.bigint=[Default] greenplum.format.datatype.double\ precision=[None] greenplum.format.datatype.float=[None] greenplum.format.datatype.float4=[None] greenplum.format.datatype.float8=[None] greenplum.format.null=(null) greenplum.maxresults= greenplum.paramquery=false greenplum.qualifyobject=true greenplum.quoteidentifier=None greenplum.ssssc=false greenplum.statementSeparator= greenplum.tablecompletionquoteidentifier=None greenplum.visualeditquoteident=true gridresults.alternatebackground=\#f8f8f8 gridresults.alternateforeground=\#000000 gridresults.alternaterowcolor=false gridresults.copyasdefault=false highlight.development.tab=null highlight.production.tab=null highlight.test.tab=null history.messagelines=3000 history.textlines=3000 hive.autocomplete=true hive.autoonallschemas2=true hive.bbssc=false hive.case=Default hive.columncompletionquoteidentifier=None hive.ddssc=false hive.driverParameter= hive.maxresults= hive.paramquery=false hive.qualifyobject=false hive.quoteidentifier=None hive.ssssc=false hive.statementSeparator= hive.tablecompletionquoteidentifier=None hive.visualeditquoteident=true htmleditor.background=\#ffffff htmleditor.bracesMatchColor=\#f3ff0f htmleditor.caretInsertColor=\#000000 htmleditor.caretOverwriteColor=\#000000 htmleditor.expandtabs=true htmleditor.forcewriteeol=Default htmleditor.foreground=\#000000 htmleditor.highlightbrace=true htmleditor.highlightcaretrow=true htmleditor.highlightcaretrowcolor=\#ffffdc htmleditor.highlightedtextbackground=\#b4b4b4 htmleditor.highlightedtextforeground=\#ffffff htmleditor.inlineDiff=true htmleditor.insertionpoint=Vertical Bar htmleditor.insertionpointblinkrate=300 htmleditor.linenumbers=true htmleditor.overwritecaret=Solid Block htmleditor.searchMatchColor=\#ffc800 htmleditor.spacepertab=4 htmleditor.statusbarvisible=true htmleditor.tabnavigationbar=true htmleditor.tabsize=4 htmleditor.textlimitline=true htmleditor.textlimitlinecount=80 ids93.autocommit=true ids93.autocomplete=true ids93.autoonallschemas2=true ids93.bbssc=true ids93.case=Default ids93.columncompletionquoteidentifier=None ids93.ddssc=true ids93.driverParameter= ids93.format.datatype.bigint=[Default] ids93.format.datatype.float=[None] ids93.format.datatype.smallfloat=[None] ids93.format.null=(null) ids93.maxresults= ids93.paramquery=false ids93.qualifyobject=true ids93.quoteidentifier=None ids93.ssssc=false ids93.statementSeparator= ids93.tablecompletionquoteidentifier=None ids93.visualeditquoteident=true javaeditor.background=\#ffffff javaeditor.bracesMatchColor=\#f3ff0f javaeditor.caretInsertColor=\#000000 javaeditor.caretOverwriteColor=\#000000 javaeditor.expandtabs=true javaeditor.forcewriteeol=Default javaeditor.foreground=\#000000 javaeditor.highlightbrace=true javaeditor.highlightcaretrow=true javaeditor.highlightcaretrowcolor=\#ffffdc javaeditor.highlightedtextbackground=\#b4b4b4 javaeditor.highlightedtextforeground=\#ffffff javaeditor.inlineDiff=true javaeditor.insertionpoint=Vertical Bar javaeditor.insertionpointblinkrate=300 javaeditor.linenumbers=true javaeditor.overwritecaret=Solid Block javaeditor.searchMatchColor=\#ffc800 javaeditor.spacepertab=4 javaeditor.statusbarvisible=true javaeditor.tabsize=4 javaeditor.textlimitline=true javaeditor.textlimitlinecount=80 javascripteditor.background=\#ffffff javascripteditor.bracesMatchColor=\#f3ff0f javascripteditor.caretInsertColor=\#000000 javascripteditor.caretOverwriteColor=\#000000 javascripteditor.expandtabs=true javascripteditor.forcewriteeol=Default javascripteditor.foreground=\#000000 javascripteditor.highlightbrace=true javascripteditor.highlightcaretrow=true javascripteditor.highlightcaretrowcolor=\#ffffdc javascripteditor.highlightedtextbackground=\#b4b4b4 javascripteditor.highlightedtextforeground=\#ffffff javascripteditor.inlineDiff=true javascripteditor.insertionpoint=Vertical Bar javascripteditor.insertionpointblinkrate=300 javascripteditor.linenumbers=true javascripteditor.overwritecaret=Solid Block javascripteditor.searchMatchColor=\#ffc800 javascripteditor.spacepertab=4 javascripteditor.statusbarvisible=true javascripteditor.tabsize=4 javascripteditor.textlimitline=true javascripteditor.textlimitlinecount=80 mongodb.autocomplete=true mongodb.autoonallschemas2=true mongodb.bbssc=false mongodb.case=Default mongodb.columncompletionquoteidentifier=None mongodb.ddssc=false mongodb.driverParameter= mongodb.format.datatype.date=[Default] mongodb.format.null=(null) mongodb.maxresults= mongodb.paramquery=false mongodb.qualifyobject=false mongodb.quoteidentifier=None mongodb.ssssc=false mongodb.statementSeparator= mongodb.tablecompletionquoteidentifier=None mongodb.visualeditquoteident=true mysql.autocommit=true mysql.autocomplete=true mysql.autoonallschemas2=true mysql.bbssc=false mysql.case=Default mysql.columncompletionquoteidentifier=None mysql.ddssc=false mysql.driverParameter= mysql.format.datatype.double=[None] mysql.format.datatype.float=[None] mysql.format.datatype.int=[Default] mysql.format.datatype.real=[None] mysql.format.null=(null) mysql.maxresults= mysql.paramquery=false mysql.qualifyobject=false mysql.quoteidentifier=None mysql.ssssc=false mysql.statementSeparator= mysql.tablecompletionquoteidentifier=None mysql.visualeditquoteident=true ncluster.autocommit=true ncluster.autocomplete=true ncluster.autoonallschemas2=true ncluster.bbssc=true ncluster.case=Default ncluster.columncompletionquoteidentifier="object name" ncluster.ddssc=false ncluster.driverParameter= ncluster.format.datatype.bigint=[Default] ncluster.format.datatype.double\ precision=[None] ncluster.format.datatype.float=[None] ncluster.format.datatype.float4=[None] ncluster.format.datatype.float8=[None] ncluster.format.datatype.real=[None] ncluster.format.null=(null) ncluster.maxresults= ncluster.paramquery=true ncluster.qualifyobject=true ncluster.quoteidentifier="object name" ncluster.ssssc=false ncluster.statementSeparator= ncluster.tablecompletionquoteidentifier="object name" ncluster.visualeditquoteident=true netezza.autocommit=true netezza.autocomplete=true netezza.autoonallschemas2=true netezza.bbssc=false netezza.case=Default netezza.columncompletionquoteidentifier=None netezza.ddssc=false netezza.driverParameter= netezza.format.datatype.date=[Default] netezza.format.datatype.float4=[None] netezza.format.datatype.float8=[None] netezza.format.null=(null) netezza.maxresults= netezza.paramquery=false netezza.qualifyobject=true netezza.quoteidentifier=None netezza.ssssc=false netezza.statementSeparator= netezza.tablecompletionquoteidentifier=None netezza.visualeditquoteident=true OnFrameCloseButton=close oracle8i.autocommit=true oracle8i.autocomplete=true oracle8i.autoonallschemas2=false oracle8i.bbssc=true oracle8i.case=Default oracle8i.columncompletionquoteidentifier=None oracle8i.ddssc=true oracle8i.driverParameter= oracle8i.format.datatype.binary_double=[None] oracle8i.format.datatype.binary_float=[None] oracle8i.format.datatype.float=[None] oracle8i.format.null=(null) oracle8i.maxresults= oracle8i.paramquery=false oracle8i.qualifyobject=true oracle8i.quoteidentifier=None oracle8i.ssssc=false oracle8i.statementSeparator= oracle8i.tablecompletionquoteidentifier=None oracle8i.visualeditquoteident=true oracle9i.autocommit=true oracle9i.autocomplete=true oracle9i.autoonallschemas2=false oracle9i.bbssc=true oracle9i.case=Default oracle9i.columncompletionquoteidentifier=None oracle9i.ddssc=true oracle9i.driverParameter= oracle9i.format.datatype.binary_double=[None] oracle9i.format.datatype.binary_float=[None] oracle9i.format.datatype.float=[None] oracle9i.format.null=(null) oracle9i.maxresults= oracle9i.paramquery=false oracle9i.qualifyobject=true oracle9i.quoteidentifier=None oracle9i.ssssc=false oracle9i.statementSeparator= oracle9i.tablecompletionquoteidentifier=None oracle9i.visualeditquoteident=true paraccel.autocommit=true paraccel.autocomplete=true paraccel.autoonallschemas2=false paraccel.bbssc=false paraccel.case=Default paraccel.columncompletionquoteidentifier=None paraccel.ddssc=false paraccel.driverParameter= paraccel.format.datatype.bigint=[Default] paraccel.format.datatype.double\ precision=[None] paraccel.format.datatype.float=[None] paraccel.format.datatype.float4=[None] paraccel.format.datatype.float8=[None] paraccel.format.null=(null) paraccel.maxresults= paraccel.paramquery=false paraccel.qualifyobject=true paraccel.quoteidentifier=None paraccel.ssssc=false paraccel.statementSeparator= paraccel.tablecompletionquoteidentifier=None paraccel.visualeditquoteident=true param.macro.tag.date=d param.macro.tag.datetime=dt param.macro.tag.datetimeAtMidnight=dm param.macro.tag.time=t param.prompt.allDefaultSet=true parser.atSeparator=false parser.semicolonseparator=false parser.semicolonseparator.azure= parser.semicolonseparator.cassandra=true parser.semicolonseparator.db2_7= parser.semicolonseparator.db2_8= parser.semicolonseparator.db2i= parser.semicolonseparator.db2zos= parser.semicolonseparator.derby= parser.semicolonseparator.generic= parser.semicolonseparator.greenplum= parser.semicolonseparator.hive= parser.semicolonseparator.informix= parser.semicolonseparator.mongodb= parser.semicolonseparator.mysql= parser.semicolonseparator.ncluster= parser.semicolonseparator.netezza= parser.semicolonseparator.oracle8= parser.semicolonseparator.oracle9= parser.semicolonseparator.paraccel= parser.semicolonseparator.postgres= parser.semicolonseparator.sql2000= parser.semicolonseparator.sql7= parser.semicolonseparator.sqlite= parser.semicolonseparator.syany= parser.semicolonseparator.syase= parser.semicolonseparator.syiq= parser.semicolonseparator.teradata= parser.semicolonseparator.vertica= parser.slashseparator=false permission.dev.allowpkmod=true permission.dev.queryanalyzerallothersql=true permission.dev.queryanalyzerddl=true permission.dev.queryanalyzerdelete=true permission.dev.queryanalyzerinsert=true permission.dev.queryanalyzerselect=true permission.dev.queryanalyzertruncate=true permission.dev.queryanalyzerupdate=true permission.dev.sqlDebugger=true permission.dev.tabledataeditordelete=true permission.dev.tabledataeditorinsert=true permission.dev.tabledataeditorupdate=true permission.dev.tabledataeditorwindow=true permission.dev.visualeditingalter=true permission.dev.visualeditingcreate=true permission.dev.visualeditingdrop=true permission.dev.visualeditingprops=true permission.prod.allowpkmod=true permission.prod.queryanalyzerallothersql=true permission.prod.queryanalyzerddl=true permission.prod.queryanalyzerdelete=true permission.prod.queryanalyzerinsert=true permission.prod.queryanalyzerselect=true permission.prod.queryanalyzertruncate=true permission.prod.queryanalyzerupdate=true permission.prod.sqlDebugger=true permission.prod.tabledataeditordelete=true permission.prod.tabledataeditorinsert=true permission.prod.tabledataeditorupdate=true permission.prod.tabledataeditorwindow=true permission.prod.visualeditingalter=true permission.prod.visualeditingcreate=true permission.prod.visualeditingdrop=true permission.prod.visualeditingprops=true permission.test.allowpkmod=true permission.test.queryanalyzerallothersql=true permission.test.queryanalyzerddl=true permission.test.queryanalyzerdelete=true permission.test.queryanalyzerinsert=true permission.test.queryanalyzerselect=true permission.test.queryanalyzertruncate=true permission.test.queryanalyzerupdate=true permission.test.sqlDebugger=true permission.test.tabledataeditordelete=true permission.test.tabledataeditorinsert=true permission.test.tabledataeditorupdate=true permission.test.tabledataeditorwindow=true permission.test.visualeditingalter=true permission.test.visualeditingcreate=true permission.test.visualeditingdrop=true permission.test.visualeditingprops=true postgres.autocommit=true postgres.autocomplete=true postgres.autoonallschemas2=true postgres.bbssc=false postgres.case=Default postgres.columncompletionquoteidentifier=None postgres.ddssc=false postgres.driverParameter= postgres.format.datatype.bigserial=[Default] postgres.format.datatype.double\ precision=[None] postgres.format.datatype.float=[None] postgres.format.datatype.float4=[None] postgres.format.datatype.float8=[None] postgres.format.null=(null) postgres.maxresults= postgres.paramquery=false postgres.qualifyobject=true postgres.quoteidentifier=None postgres.ssssc=false postgres.statementSeparator= postgres.tablecompletionquoteidentifier=None postgres.visualeditquoteident=true procedure.editor.package.compileboth=true property.shell.echocommands=true property.shell.executescriptforallservers=false property.shell.stoponcommanderror=false property.shell.stoponsqlerror=true query.sound= query.sound.threshold=0 querybuilder.columnselection=0 querybuilder.dialog=D\:\\User\\Ashu\\Query_Builder querybuilder.dialog.op=L, querybuilder.pane.column=true querybuilder.pane.sql=true querybuilder.shortcutpersistmode=Application querybuilder.show.datatype=true querybuilder.showadddialogatstartup=true QueryBuilderFrame.recentFiles=D\:\\User\\Ashu\\Query_Builder\\scott.xqb\u0000D\:\\User\\Ashu\\Query_Builder\\scott_query.xqb querywindow.db2_changeable_schema=true querywindow.db2i_changeable_schema=true querywindow.db2z_changeable_schema=true querywindow.derby_changeable_schema=true querywindow.donotpromptsavefornewfile=false querywindow.hideResultsOnOpen=false querywindow.includeFilename=true querywindow.inital_context_schema=true querywindow.multitabquerywindow=false querywindow.oracle_changeable_schema=true querywindow.permissionFailureMessage=Change in Server Registration->Permissions querywindow.promptforcommit=false querywindow.results.tab.bottom=true querywindow.reuseeditor=false quick.search.autohide=true register.savepassword=true register.sqlserver.quotedidentifier=true register.sybase.quotedidentifier=false results.display.alwaysdisplaysuccess=false results.display.columnheaders=true results.display.margincharlength=1 results.display.maxcellvalue=2147483647 results.display.querystats=true results.display.sql=false results.display.sum=false results.display.warningheaders=true results.display.warnings=true results.excel.max.length=1024 results.messagecoloring.enabled=false results.messagecoloring.errorbgr=\#f0f0f0 results.messagecoloring.errorfgr=\#000000 results.messagecoloring.warningbgr=\#f0f0f0 results.messagecoloring.warningfgr=\#000000 results.messages.clearonexecute=true results.messages.type=auto results.retrieve.binarytohex=true results.retrieve.maxblobblocks=2147483647 results.retrieve.maxcloblines=2147483647 results.retrieve.truncateright=false results.scriptexec.stoponerror=false results.syntaxcoloring.enabled=true results.syntaxcoloring.sqlerror=\#ff0000 results.syntaxcoloring.sqlstmt=\#0000ff ResultSetTablePaneView.persistQuickFilter=false ResultSetTablePaneView.persistSort=true schemabrowser.displayservertype=false scripts.autoformat=false scripts.createincludesperms=false scripts.dropncreate=false scripts.filter2=.SQL,.PROC,.TQL,.PLSQL,.PKS,.PKB,.XQB,.TXT,.XML,.HTML scripts.spaceindent=4 scripts.statementseparator=GO scripts.useconditionaldrop=false shell.bg=\#ffffff shell.fg=\#000000 shell.fg.shellexception=\#ff0000 shell.fg.stderr=\#9d1c2a shell.fg.stdout=\#008000 shell.font=Monospaced-plain-12 shell.initscript= shell.max.results=-1 shell.prompt=\#0000ff shell.selection=\#d0d0d0 shell.sql.history.size=10 shell.text.buffer.size=1000 sql2000.autocommit=true sql2000.autocomplete=true sql2000.autoonallschemas2=true sql2000.bbssc=true sql2000.case=Default sql2000.columncompletionquoteidentifier=None sql2000.convertlf=false sql2000.ddssc=true sql2000.driverParameter= sql2000.format.datatype.bigint=[Default] sql2000.format.datatype.float=[None] sql2000.format.datatype.real=[None] sql2000.format.null=(null) sql2000.maxresults= sql2000.paramquery=false sql2000.qualifyobject=true sql2000.quoteidentifier=[object name] sql2000.ssssc=false sql2000.statementSeparator= sql2000.tablecompletionquoteidentifier=None sql2000.visualeditquoteident=true sql7.autocommit=true sql7.autocomplete=true sql7.autoonallschemas2=true sql7.bbssc=true sql7.case=Default sql7.columncompletionquoteidentifier=None sql7.convertlf=false sql7.ddssc=true sql7.driverParameter= sql7.format.datatype.bigint=[Default] sql7.format.datatype.float=[None] sql7.format.datatype.real=[None] sql7.format.null=(null) sql7.maxresults= sql7.paramquery=false sql7.qualifyobject=true sql7.quoteidentifier="object name" sql7.ssssc=false sql7.statementSeparator= sql7.tablecompletionquoteidentifier=None sql7.visualeditquoteident=true sqlhistory.archive.max.size=-1 sqlhistory.archive.trim.period=-1 sqlhistory.archivedirectory=C\:\\Users\\Ashu\\.datastudio\\history\\archive sqlhistory.archiveenable=false sqlhistory.directory=C\:\\Users\\Ashu\\.datastudio\\history sqlhistory.maxEntries=20 sqlhistory.maxStatementsPerEntry=100 sqlhistory.visualEditing=false sqlite.autocommit=true sqlite.autocomplete=true sqlite.autoonallschemas2=true sqlite.bbssc=true sqlite.case=Default sqlite.columncompletionquoteidentifier=None sqlite.ddssc=true sqlite.driverParameter= sqlite.format.datatype.float=[None] sqlite.format.datatype.integer=[Default] sqlite.format.datatype.real=[None] sqlite.format.null=(null) sqlite.maxresults= sqlite.paramquery=false sqlite.qualifyobject=false sqlite.quoteidentifier=None sqlite.ssssc=false sqlite.statementSeparator= sqlite.tablecompletionquoteidentifier=None sqlite.visualeditquoteident=true ssh.term.bg=\#ffffff ssh.term.fg=\#000000 ssh.term.font=Monospaced-plain-12 ssh.term.history=1000 ssh.term.key.agent=true ssh.term.selection=\#d0d0d0 ssh.term.tab=4 sybase12_5.autocommit=true sybase12_5.autocomplete=true sybase12_5.autoonallschemas2=true sybase12_5.bbssc=true sybase12_5.case=Default sybase12_5.columncompletionquoteidentifier=None sybase12_5.ddssc=true sybase12_5.driverParameter= sybase12_5.format.datatype.date=[Default] sybase12_5.format.datatype.double\ precision=[None] sybase12_5.format.datatype.float=[None] sybase12_5.format.datatype.real=[None] sybase12_5.format.null=(null) sybase12_5.maxresults= sybase12_5.paramquery=false sybase12_5.qualifyobject=true sybase12_5.quoteidentifier=None sybase12_5.ssssc=false sybase12_5.statementSeparator= sybase12_5.tablecompletionquoteidentifier=None sybase12_5.visualeditquoteident=true sybaseanywhere8.autocommit=true sybaseanywhere8.autocomplete=true sybaseanywhere8.autoonallschemas2=false sybaseanywhere8.bbssc=true sybaseanywhere8.case=Default sybaseanywhere8.columncompletionquoteidentifier=None sybaseanywhere8.ddssc=true sybaseanywhere8.driverParameter= sybaseanywhere8.format.datatype.double=[None] sybaseanywhere8.format.datatype.float=[None] sybaseanywhere8.format.datatype.numeric=[Default] sybaseanywhere8.format.datatype.real=[None] sybaseanywhere8.format.null=(null) sybaseanywhere8.maxresults= sybaseanywhere8.paramquery=false sybaseanywhere8.qualifyobject=true sybaseanywhere8.quoteidentifier=None sybaseanywhere8.ssssc=true sybaseanywhere8.statementSeparator= sybaseanywhere8.tablecompletionquoteidentifier=None sybaseanywhere8.visualeditquoteident=true sybaseiq.autocommit=true sybaseiq.autocomplete=true sybaseiq.autoonallschemas2=false sybaseiq.bbssc=true sybaseiq.case=Default sybaseiq.columncompletionquoteidentifier=None sybaseiq.ddssc=true sybaseiq.driverParameter= sybaseiq.format.datatype.double=[None] sybaseiq.format.datatype.float=[None] sybaseiq.format.datatype.numeric=[Default] sybaseiq.format.datatype.real=[None] sybaseiq.format.null=(null) sybaseiq.maxresults= sybaseiq.paramquery=false sybaseiq.qualifyobject=true sybaseiq.quoteidentifier=None sybaseiq.ssssc=true sybaseiq.statementSeparator= sybaseiq.tablecompletionquoteidentifier=None sybaseiq.visualeditquoteident=true syntaxcoloring.commands=\#0066cc syntaxcoloring.comments=\#808080 syntaxcoloring.datatypes=\#8000ff syntaxcoloring.enablebold=true syntaxcoloring.enabled=true syntaxcoloring.functions=\#009b37 syntaxcoloring.keywords=\#0000ff syntaxcoloring.keywordsvendor=\#0000ff syntaxcoloring.numeric=\#ff00ff syntaxcoloring.quotedstrings=\#ff0000 syntaxcoloring.systables=\#009b37 tabledataeditor.batchsize=10 tabledataeditor.emptyToNull=false tabledataeditor.enablenullstring=true tabledataeditor.logused=-1 tabledataeditor.logwaittime=1000 tabledataeditor.modificationLogsEnabled=false tabledataeditor.modificationLogsMaxNumber=100 tabledataeditor.modificationLogsPath=C\:\\Users\\Ashu\\.datastudio\\modification-s tabledataeditor.promptambcolumns=true tabledataeditor.savesqlhistory=false tabledataeditor.threshold=5000 tabledataeditor.transactionrequired=true tabledataeditor.transactiontype=Full tabledataeditor.waittime=-1 tableeditor.dialog=C\:\\Users\\Ashu tableeditor.dialog.op=L, teradata.autocommit=true teradata.autocomplete=true teradata.autoonallschemas2=false teradata.bbssc=false teradata.case=Default teradata.columncompletionquoteidentifier=None teradata.ddssc=false teradata.driverParameter= teradata.format.datatype.bigint=[Default] teradata.format.datatype.double\ precision=[None] teradata.format.datatype.float=[None] teradata.format.datatype.real=[None] teradata.format.null=(null) teradata.maxresults= teradata.paramquery=false teradata.qualifyobject=true teradata.quoteidentifier=None teradata.ssssc=false teradata.statementSeparator= teradata.tablecompletionquoteidentifier=None teradata.visualeditquoteident=true texteditor.background=\#ffffff texteditor.bracesMatchColor=\#f3ff0f texteditor.caretInsertColor=\#000000 texteditor.caretOverwriteColor=\#000000 texteditor.expandtabs=true texteditor.forcewriteeol=Default texteditor.foreground=\#000000 texteditor.highlightbrace=true texteditor.highlightcaretrow=true texteditor.highlightcaretrowcolor=\#ffffdc texteditor.highlightedtextbackground=\#b4b4b4 texteditor.highlightedtextforeground=\#ffffff texteditor.inlineDiff=true texteditor.insertionpoint=Vertical Bar texteditor.insertionpointblinkrate=300 texteditor.linenumbers=true texteditor.overwritecaret=Solid Block texteditor.searchMatchColor=\#ffc800 texteditor.spacepertab=4 texteditor.statusbarvisible=true texteditor.tabsize=4 texteditor.textlimitline=true texteditor.textlimitlinecount=80 ui.AppFrame0.focusedTree=0 ui.AppFrame0.hideFileTree=false ui.AppFrame0.hideProjectTree=false ui.AppFrame0.hideTrees=false ui.AppFrame0.layout=0014fffffff8fffffff8000006500000036c00000006000000000000046a00000003000000000000046a00000005000000000000046a00000007000000000000046a0000000100000000000000000014fffffff8fffffff8000006500000036c00000006000000040000000800500072006f006a0065006300740073000082af0000000800000000000000000000000d00000004000000040000000800000143000001560000000000000000000000f20000007900000137000001d8000000000000000100000004000082af00000002000000000000000000000626000002ff00000008000000000000303a00000003000080680000ee76000082af00000001000022180000303a00000001000000020000303affffffff00000001000000040000276400000002000000000000000000000626000002ff000000080000000000007ef70000000300004dc5000019a000002764000000010000fd3e00007ef7000000010000000200007ef700002ac1000000010000000100002764000000020000001f000000700000013f000001f6000000080000000000007ef70000000300007204000019a000002764000000010000467600007ef7000000010000000100007ef7000000000000000600440065007400610069006c00001ee20000000200000001000000010000000d000000000000000000000002000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000001ee2000000000000003c0000003c000000c8000000c80000000000000000000000000000000000000000000000000000000000000000000000070053006500720076006500720073000080680000000800000000000000000000000d00000004000000040000000800000143000001560000000000000000000000230000007400000137000001d80000000000000001000000040000806800000002000000000000000000000626000002ff00000008000000000000303a00000003000080680000ee76000082af00000001000022180000303a00000001000000020000303affffffff000000010000000400004dc500000002000000000000000000000626000002ff000000080000000000007ef70000000300004dc5000019a000002764000000010000fd3e00007ef7000000010000000200007ef700002ac1000000010000000100007204000000020000001f000000700000013f000001f6000000080000000000007ef70000000300007204000019a000002764000000010000467600007ef7000000010000000100007ef7000000000000000700530063007200690070007400730000ee760000000800000000000000000000000d00000004000000040000000800000143000001560000000000000000000000f20000007900000137000001d80000000000000001000000040000ee7600000002000000000000000000000626000002ff00000008000000000000303a00000003000080680000ee76000082af00000001000022180000303a00000001000000020000303affffffff0000000100000004000019a000000002000000000000000000000626000002ff000000080000000000007ef70000000300004dc5000019a000002764000000010000fd3e00007ef7000000010000000200007ef700002ac10000000100000001000019a0000000020000001f000000700000013f000001f6000000080000000000007ef70000000300007204000019a000002764000000010000467600007ef7000000010000000100007ef70000000000000463000000010000fd3e0000000001000004630000000000002ac10000000001000004630000000100009d0a000000000100000463000000000000b33700000000010000046300000001000022180000000002000004640000303a000000030000046500000007005300650072007600650072007300000465000000070053006300720069007000740073000004650000000800500072006f006a006500630074007300000143000001ee0000000000000466ffffffffffffffff00000000ffffffffffffffffffffffffffffffffffffffffffffffff000004eb00000028ffffffffffffffff000000030000000000000007000000000000000100000000000000050000000000000000000000010000000600440065007400610069006c00000000 ui.AppFrame0.location=-8,-8,1616,876,1 ui.AppFrame0.user.title= ui.EditorFrame0.location=67,67,1513,726,0 ui.EditorFrame1.location=67,67,1466,726,0 ui.QueryFrame0.layout=00140000002300000028000005fa0000030c00000000000000000000046a00000003000000000000046a00000005000000000000046a00000007000000000000046a00000001000000000000000000140000002300000028000005fa0000030c00000000000000000000046300000000000063bb000000000100000463000000010000508a000000000100000466ffffffffffffffff00000000ffffffffffffffffffffffffffffffff0000000300000000000000070000000000000001000000000000000500000000000000000000000000000000 ui.QueryFrame0.location=35,40,1530,780,0 vc.svn.format=1700 vertica.autocommit=true vertica.autocomplete=true vertica.autoonallschemas2=false vertica.bbssc=false vertica.case=Default vertica.columncompletionquoteidentifier=None vertica.ddssc=false vertica.driverParameter= vertica.format.datatype.date=[Default] vertica.format.null=(null) vertica.maxresults= vertica.paramquery=false vertica.qualifyobject=true vertica.quoteidentifier=None vertica.ssssc=false vertica.statementSeparator= vertica.tablecompletionquoteidentifier=None vertica.visualeditquoteident=true visualedit.floating.windows=false visualedit.prompt.on.cancel=true win.0=00000013052E76657274FB04322E6462046F72636C06302E7479706502514104302E736302485206302E636F6E6E35433A5C55736572735C417368755C2E6461746173747564696F5C636F6E6E656374696F6E735C6F7261636C65203131672E636F6E6E06312E7479706502514104312E64620762656568697665047479706502414607312E67726F7570FE0000000007322E67726F7570FE0000000006322E636F6E6E34433A5C55736572735C417368755C2E6461746173747564696F5C636F6E6E656374696F6E735C6F7261636C653132632E636F6E6E04312E7363076265656869766509616374697665546162FE0000000206312E636F6E6E38433A5C55736572735C417368755C2E6461746173747564696F5C636F6E6E656374696F6E735C41737465726E436C75737465722E636F6E6E04302E6462046F72636C04322E73630653595354454D0474616273FE0000000307302E67726F7570FE0000000006322E74797065025141 win.1=000000020466696C6524443A5C557365725C417368755C51756572795F4275696C6465725C73636F74742E7871620474797065024546 win.count=1 win.save=true xmleditor.background=\#ffffff xmleditor.bracesMatchColor=\#f3ff0f xmleditor.caretInsertColor=\#000000 xmleditor.caretOverwriteColor=\#000000 xmleditor.expandtabs=true xmleditor.forcewriteeol=Default xmleditor.foreground=\#000000 xmleditor.highlightbrace=true xmleditor.highlightcaretrow=true xmleditor.highlightcaretrowcolor=\#ffffdc xmleditor.highlightedtextbackground=\#b4b4b4 xmleditor.highlightedtextforeground=\#ffffff xmleditor.inlineDiff=true xmleditor.insertionpoint=Vertical Bar xmleditor.insertionpointblinkrate=300 xmleditor.linenumbers=true xmleditor.overwritecaret=Solid Block xmleditor.searchMatchColor=\#ffc800 xmleditor.spacepertab=4 xmleditor.statusbarvisible=true xmleditor.tabsize=4 xmleditor.textlimitline=true xmleditor.textlimitlinecount=80