PowerBuilder 6.5 & DB2 OS/390 V6

Steve Grimes

PowerBuilder 6.5 & DB2 OS/390 V6
Hi.

We used DB2 Connect on an NT 4.0 workstation, to successfully configure an
ODBC connection for Powerbuilder 6.5. It's very cool, and opens up the
data base in the PB Database Painter. Here's what's wierd though. On some
of the tables, PB brings up the table definitions (columns, etc.) without a
problem. On others, it pops up a window which says:

Table "blah_blah" has no columns, possible invalid table format.

We've tried the Bind button in DB2 Connect several times. No change in our
results.
We can access the tables via SPUFI from TSO on OS/390. The DB2 DIS command
looks fine for these also.
Here's the last wierd clue. We can select data from the "bad" tables with
"SELECT" statements in PB's database administrator window. It's just the
PB DB painter and DataWindow painter that seem to have the problem.

(Our results under PB 7.0 are the same.)

Any thoughts?

Thanks!

P.S. Thanks Richard Yevich for your help on my trigger question a while
back. (I'm still stuck on that so I'll probably send a follow up note
later.)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Steve Grimes
Washington University Information Systems
W: 314-935-4376 H: 314-928-5005 Isa.64:6
[login to unmask email]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



Terry McCombs take me off this list

Re: PowerBuilder 6.5 & DB2 OS/390 V6
(in response to Steve Grimes)
There is a wildcard option that must be unchecked in order to see columns of
tables with names containing an underscore. I learned about this a few
months ago from a post on this list, and it solved our problem. Hope this
helps.


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
Steve Grimes
Sent: Monday, January 03, 2000 4:00 PM
To: [login to unmask email]
Subject: PowerBuilder 6.5 & DB2 OS/390 V6


Hi.

We used DB2 Connect on an NT 4.0 workstation, to successfully configure an
ODBC connection for Powerbuilder 6.5. It's very cool, and opens up the
data base in the PB Database Painter. Here's what's wierd though. On some
of the tables, PB brings up the table definitions (columns, etc.) without a
problem. On others, it pops up a window which says:

Table "blah_blah" has no columns, possible invalid table format.

We've tried the Bind button in DB2 Connect several times. No change in our
results.
We can access the tables via SPUFI from TSO on OS/390. The DB2 DIS command
looks fine for these also.
Here's the last wierd clue. We can select data from the "bad" tables with
"SELECT" statements in PB's database administrator window. It's just the
PB DB painter and DataWindow painter that seem to have the problem.

(Our results under PB 7.0 are the same.)

Any thoughts?

Thanks!

P.S. Thanks Richard Yevich for your help on my trigger question a while
back. (I'm still stuck on that so I'll probably send a follow up note
later.)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Steve Grimes
Washington University Information Systems
W: 314-935-4376 H: 314-928-5005 Isa.64:6
[login to unmask email]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~








Steve Grimes

Re: PowerBuilder 6.5 & DB2 OS/390 V6
(in response to Terry McCombs take me off this list)
Thank you Terry. It was the wildcard option. It's working great now.

Thanks again!

Sg
---------------------- Forwarded by Steve Grimes/Systems/ais on 01/04/2000
02:52 PM ---------------------------


"McCombs, Terry" <[login to unmask email]> on 01/04/2000 08:04:17 AM

Please respond to [login to unmask email]



To: [login to unmask email]

cc: (bcc: Steve Grimes/Systems/ais)



Subject: Re: PowerBuilder 6.5 & DB2 OS/390 V6









There is a wildcard option that must be unchecked in order to see columns
of
tables with names containing an underscore. I learned about this a few
months ago from a post on this list, and it solved our problem. Hope this
helps.


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of
Steve Grimes
Sent: Monday, January 03, 2000 4:00 PM
To: [login to unmask email]
Subject: PowerBuilder 6.5 & DB2 OS/390 V6


Hi.

We used DB2 Connect on an NT 4.0 workstation, to successfully configure an
ODBC connection for Powerbuilder 6.5. It's very cool, and opens up the
data base in the PB Database Painter. Here's what's wierd though. On some
of the tables, PB brings up the table definitions (columns, etc.) without a
problem. On others, it pops up a window which says:

Table "blah_blah" has no columns, possible invalid table format.

We've tried the Bind button in DB2 Connect several times. No change in our
results.
We can access the tables via SPUFI from TSO on OS/390. The DB2 DIS command
looks fine for these also.
Here's the last wierd clue. We can select data from the "bad" tables with
"SELECT" statements in PB's database administrator window. It's just the
PB DB painter and DataWindow painter that seem to have the problem.

(Our results under PB 7.0 are the same.)

Any thoughts?

Thanks!

P.S. Thanks Richard Yevich for your help on my trigger question a while
back. (I'm still stuck on that so I'll probably send a follow up note
later.)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Steve Grimes
Washington University Information Systems
W: 314-935-4376 H: 314-928-5005 Isa.64:6
[login to unmask email]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



the