Start a new topic

error while exporting stored procedure

[This topic is migrated from our old forums. The original author name has been removed]
[Attachment has been removed.]

Hello, Im not able to export my stored procedures to clipboard. can you please help. I using DB2 version 9. @export on; 11:39:44 [@EXPORT - 0 row(s), 0.000 secs] Command processed @export set AppendFile="clear" BinaryFileDir="" BinaryFormat="Value" BooleanFalseFormat="false" BooleanTrueFormat="true" CLOBFileDir="" CLOBFormat="Value" ClipboardName="" CsvColumnDelimiter="\t" CsvColumnHeaderIsColumnAlias="true" CsvIncludeColumnHeader="true" CsvIncludeSQLCommand="Don't Include" CsvRemoveNewlines="false" CsvRowCommentIdentifier="" CsvRowDelimiter="\n" DateFormat="yyyy-MM-dd" DecimalNumberFormat="Unformatted" Destination="Clipboard" Encoding="Cp1252" ExcelColumnHeaderIsColumnAlias="true" ExcelFileFormat="Binary Excel (xls)" ExcelIncludeColumnHeader="true" ExcelIncludeSQLCommand="" ExcelIntroText="" ExcelTextOnly="false" ExcelTitle="" Filename="C:\sql.sql" Format="SQL" HtmlIncludeSQLCommand="" HtmlIntroText="" HtmlTitle="" ImageHeight="" ImageWidth="" JSONStyle="Array" NumberFormat="Unformatted" Orientation="Portrait" QuoteDuplicateEmbedded="true" QuoteTextData="Single" RowCount="-1" ShowNullAs="(null)" SqlBlockBeginDelim="--/" SqlBlockEndDelim="#" SqlEditor="New Editor" SqlEditorPosition="Last" SqlIncludeCreateDDL="" SqlIncludeSQLCommand="Don't Include" SqlRowCommentIdentifier="--" SqlSeparator=";" TableName="" TimeFormat="HH:mm:ss" TimeStampFormat="yyyy-MM-dd HH:mm:ss" TxtColumnHeaderIsColumnAlias="true" TxtIncludeColumnHeader="true" TxtIncludeSQLCommand="Don't Include" TxtRemoveNewLines="false" TxtRowDelimiter="\n" TxtSpacesBetweenColumns="1" XmlIncludeSQLCommand="" XmlIntroText="" XmlStyle="DbVisualizer" derby.(JavaDB/Derby_embedded).RunAtDisconnect="DriverManager.getConnection("jdbc:derby:; 11:39:44 [@EXPORT - 0 row(s), 0.000 secs] Command processed shutdown=true")" derby.(JavaDB/Derby_embedded).RunDisconnectHook="true" hsql.(HSQLDB_embedded).RunAtDisconnect="SHUTDOWN" hsql.(HSQLDB_embedded).RunDisconnectHook="true"; 11:39:44 [SHUTDOWN=TRUE")" - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=shutdown=true")" derby.;BEGIN-OF-STATEMENT;, DRIVER=4.15.82 @ddl procedure="DB2INST1.SQL120412114524700" drop="false"; 11:39:44 [@DDL - 1 row(s), 0.009 secs] Export processed @export off; 11:39:44 [@EXPORT - 0 row(s), 0.005 secs] Command processed ... 5 statement(s) executed, 1 row(s) affected, exec/fetch time: 0.014/0.000 sec [4 successful, 0 warnings, 1 errors]

[This reply is migrated from our old forums.]

Re: error while exporting stored procedure
Salim, This will be fixed in next beta planned for release later today. Thanks for reporting it. Regards Roger
[This reply is migrated from our old forums.]

Re: error while exporting stored procedure
Salim, The just released 91.2030 beta version fixes this issue. Download by opening Tools->Check for Update in DbVisualizer and chose Upgrade. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: error while exporting stored procedure
Thanks.
[This reply is migrated from our old forums.]

Re: error while exporting stored procedure
Hi Salim, This is now part of the just released DbVisualizer 9.1. Best Regards, Hans