[Ronald R DiFrango]

I am using DB2, and I execute the following query:

SELECT * FROM PLAN_TABLE
ORDER BY PROGNAME, QUERYNO, QBLOCKNO, PLANNO, MIXOPSEQ;

And when I do a “Copy to Clipboard” it only copies 1 row. The table looks like the following:

CREATE TABLE PLAN_TABLE
( QUERYNO INTEGER NOT NULL,
QBLOCKNO SMALLINT NOT NULL,
APPLNAME CHAR(8) NOT NULL,
PROGNAME CHAR(8) NOT NULL,
PLANNO SMALLINT NOT NULL,
METHOD SMALLINT NOT NULL,
CREATOR CHAR(8) NOT NULL,
TNAME CHAR(18) NOT NULL,
TABNO SMALLINT NOT NULL,
ACCESSTYPE CHAR(2) NOT NULL,
MATCHCOLS SMALLINT NOT NULL,
ACCESSCREATOR CHAR(8) NOT NULL,
ACCESSNAME CHAR(18) NOT NULL,
INDEXONLY CHAR(1) NOT NULL,
SORTN_UNIQ CHAR(1) NOT NULL,
SORTN_JOIN CHAR(1) NOT NULL,
SORTN_ORDERBY CHAR(1) NOT NULL,
SORTN_GROUPBY CHAR(1) NOT NULL,
SORTC_UNIQ CHAR(1) NOT NULL,
SORTC_JOIN CHAR(1) NOT NULL,
SORTC_ORDERBY CHAR(1) NOT NULL,
SORTC_GROUPBY CHAR(1) NOT NULL,
TSLOCKMODE CHAR(3) NOT NULL,
TIMESTAMP CHAR(16) NOT NULL,
REMARKS VARCHAR(254) NOT NULL,
PREFETCH CHAR(1) NOT NULL,
COLUMN_FN_EVAL CHAR(1) NOT NULL,
MIXOPSEQ SMALLINT NOT NULL,
VERSION VARCHAR(64) NOT NULL,
COLLID CHAR(18) NOT NULL,
ACCESS_DEGREE SMALLINT,
ACCESS_PGROUP_ID SMALLINT,
JOIN_DEGREE SMALLINT,
JOIN_PGROUP_ID SMALLINT,
SORTC_PGROUP_ID SMALLINT,
SORTN_PGROUP_ID SMALLINT,
PARALLELISM_MODE CHAR(1),
MERGE_JOIN_COLS SMALLINT,
CORRELATION_NAME CHAR(18),
PAGE_RANGE CHAR(1) NOT NULL,
JOIN_TYPE CHAR(1) NOT NULL,
GROUP_MEMBER CHAR(8) NOT NULL,
IBM_SERVICE_DATA VARCHAR(254) NOT NULL,
WHEN_OPTIMIZE CHAR(1) NOT NULL WITH DEFAULT,
QBLOCK_TYPE CHAR(6) NOT NULL,
BIND_TIME TIMESTAMP NOT NULL
);

It is weird thoguh I select different table and perform the same functions, the copy to clipboard works fine.

It appears to be just this table.

[Riyad Kalla]

Can you please post all the information we request in the [URL=http://www.myeclipseide.com/PNphpBB2+file-viewtopic-t-393.html]Posting Guidelines[/URL] thread at the top of this forum? That will give us some context so that we can determine if this is an installation issue, a configuration problem, or a bug. Thanks.

[Ronald R DiFrango]

Not sure, why the sudden enforcement of this, but here goes:

OS: Windows XP
Eclipse Version: 3.0
No Eclispe was not freshly installed
External Plugins: ADJT 1.1.12, Sofia 2.1, DBEdit 1.0
1.4.2_02-b03
1.4.2_02-b03
Open a connection to by DB2 database and executed the above query.
No errors in the logs

[Riyad Kalla]

Not sure, why the sudden enforcement of this, but here goes:

Because we get questions like the above, and after 20 posts or so someone will mention that they are using version 2.6.4 of MyEclipse on an old Eclipse 2.0 install that they downloaded from a friend, and after we ask them to do a fresh install, everything ends up working and we all want to rip out our hair 😛

What is the Build ID of Eclipse (Help > About) and Build ID of MyEclipse (Window > Prefs > MyEclipse) that you are using?

[Ronald R DiFrango]

200406251208

[Riyad Kalla]

I’m checking with Jeff on this, thank you for providing the table schema.

[Ronald R DiFrango]

By the way, I just upgrade to 3.8.2 and it still has the same issue.

[support-jeff]

There is no reason it should only copy one row. In fact, you can only copy entire result sets. Looking at the code, I cannot see why it would have a problem. I tried your table DDL under postgresql and Cloudscape (open source DB2), without problems. We are working on setting up a test DB2 database, but it is still a ways away.

Are you absolutely certain that there is nothing in the error logs? Look for anything with a message of “Error exporting to clipboard”. Please try the following:
(1) Open the Error Log view (Window -> Show View -> Other -> PDE Runtime -> Error Log)
(2) Clear out all errors currently in the log (click the red X)
(3) Retry copy action and see if any new errors manifest in the view.

jeff

[Ronald R DiFrango]

Unfo9rtunately there is not error log on this one. I upgrade to Eclipse 3.0.1 and 3.8.2 of MyEclipse and no changei n behavior

[support-jeff]

Makes no sense, and without error logs I cannot do much. Genuitec is still working on a DB2 setup, so I cannot test that end either at this time. What version of DB2 are we talking about? What version of the JDBC libs too?

[Ronald R DiFrango]

I agree, that it does not make any sense either. We are using DB2 [7.1] on a mainframe [OS/390] so we are going through DB2 Connect [8.1]. I am using the DB2 8.1 JDBC drivers on my desktop.

[Riyad Kalla]

You better send us the main frame to test with 😀

[Author]

Posts