Re: QBE support

Mike Bruzdzinski

Re: QBE support
(in response to Leonardo Kenji Shikida)
Did you look at QMF?

-----Original Message-----
From: Leonardo Kenji Shikida [mailto:[login to unmask email]
Sent: Wednesday, October 06, 1999 11:45 AM
To: [login to unmask email]
Subject: QBE support


IBM invented QBE (query-by-example) queries.
Do DB2 has any QBE built-in support ?

thanks in advance

K

Sunit C. Patke

Re: QBE support
(in response to Venkat (PCA) Pillay)
QMF supports QBE.

Start QMF
Press PF11 to goto profile
Change Language to QBE

HTH
Sunit

>>> Leonardo Kenji Shikida <[login to unmask email]> 10/06 11:44 AM >>>
IBM invented QBE (query-by-example) queries.
Do DB2 has any QBE built-in support ?

thanks in advance

K

Venkat (PCA) Pillay

Re: QBE support
(in response to Mike Bruzdzinski)
Happen to attend presentation by Rocket Software at TRIDEX yesterday. They
have QBE kind of software on various platform accessing DB2-390. This is
marketed by IBM.

> -----Original Message-----
> From: Leonardo Kenji Shikida [SMTP:[login to unmask email]
> Sent: Wednesday, October 06, 1999 11:45 AM
> To: [login to unmask email]
> Subject: QBE support
>
> IBM invented QBE (query-by-example) queries.
> Do DB2 has any QBE built-in support ?
>
> thanks in advance
>
> K

Leonardo Kenji Shikida

QBE support
IBM invented QBE (query-by-example) queries.
Do DB2 has any QBE built-in support ?

thanks in advance

K

Tim Lowe

Re: QBE support
(in response to Sunit C. Patke)
During the DB2 technical conference, Jim Ruddy from IBM gave an excellent
presentation on DB2 UDB OS/390 REXX support, during which he shared an example
REXX routine that could DRAW select, insert, update or load statements for a
table. I am not sure if this satisfies your needs, but at least it is included
free with DB2.

Thanks,
Tim Lowe
Lead DBA
St. Paul Companies







Leonardo Kenji Shikida <[login to unmask email]> on 10/06/99 10:44:39 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>








To: [login to unmask email]

cc: (bcc: Tim Lowe/sfm/spc)



Subject: QBE support








IBM invented QBE (query-by-example) queries.
Do DB2 has any QBE built-in support ?

thanks in advance

K

Pat Mehrhoff

Re: QBE support
(in response to Tim Lowe)
Tim,
Where is this DRAW routine located (you mentioned it was free)?
Thanks, patrk






[login to unmask email]@RYCI.COM> on 10/06/99 11:00:09 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:

Subject: Re: QBE support


During the DB2 technical conference, Jim Ruddy from IBM gave an excellent
presentation on DB2 UDB OS/390 REXX support, during which he shared an
example
REXX routine that could DRAW select, insert, update or load statements for
a
table. I am not sure if this satisfies your needs, but at least it is
included
free with DB2.

Thanks,
Tim Lowe
Lead DBA
St. Paul Companies







Leonardo Kenji Shikida <[login to unmask email]> on 10/06/99 10:44:39 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>








To: [login to unmask email]

cc: (bcc: Tim Lowe/sfm/spc)



Subject: QBE support








IBM invented QBE (query-by-example) queries.
Do DB2 has any QBE built-in support ?

thanks in advance

K

Tim Lowe

Re: QBE support
(in response to Pat Mehrhoff)
Pat,
I have not tried this yet.
We were told that the REXX support in DB2 is "was a no-price feature of DB2".
(rather than "free") See your DB2 systems programmer.

The DB2 implementation APAR numbers for DB2 REXX support from my notes were
V5=PQ29706, V6=PQ30219
My notes from the presentation also indicate "BETA testing only" currently for
DB2 V6.
Also, DB2 V5 is limited to only character data types, DB2 V6 does not have this
restriction . (use the DIGITS function?)

The DB2 REXX examples are in a book available on the web at
ftp://ftp.software.ibm.com/software/os390/db2server/books/REXXV5.PDF

I hope this helps.

Thanks,
Tim Lowe
Lead DBA
St. Paul Companies







Pat Mehrhoff <"Pat_Mehrhoff/MSI-CORP/MSI-INC"@MSI-INSURANCE.COM> on 10/06/99
02:24:30 PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>








To: [login to unmask email]

cc: (bcc: Tim Lowe/sfm/spc)



Subject: Re: QBE support








Tim,
Where is this DRAW routine located (you mentioned it was free)?
Thanks, patrk






[login to unmask email]@RYCI.COM> on 10/06/99 11:00:09 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:

Subject: Re: QBE support


During the DB2 technical conference, Jim Ruddy from IBM gave an excellent
presentation on DB2 UDB OS/390 REXX support, during which he shared an
example
REXX routine that could DRAW select, insert, update or load statements for
a
table. I am not sure if this satisfies your needs, but at least it is
included
free with DB2.

Thanks,
Tim Lowe
Lead DBA
St. Paul Companies







Leonardo Kenji Shikida <[login to unmask email]> on 10/06/99 10:44:39 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>








To: [login to unmask email]

cc: (bcc: Tim Lowe/sfm/spc)



Subject: QBE support








IBM invented QBE (query-by-example) queries.
Do DB2 has any QBE built-in support ?

thanks in advance

K

Leonardo Kenji Shikida

Re: QBE support
(in response to Tim Lowe)
"Bruzdzinski, Mike" wrote:

> Did you look at QMF?

No. What is this ? I haven't found anything in the DB2 information
center