|
|
|
|
|
|
| Author |
Message |
dmeiser
*nix forums beginner
Joined: 20 May 2006
Posts: 7
|
 Posted: Thu Jul 20, 2006 12:04 pm Post subject:
Query for file names like SC*
|
|
|
I need to write a query that returns the names of all queries in a
library that start with the letters SC. I have not a clue how to even
start something like this. If possible, the boss would like this done
is QRY/400.
Also, if anyone knows how to build a time machine so that I can have
this done by when the boss called 15 minutes ago wanting to have it
done by now, that would be great.
Thanks for any help,
Dave |
|
| Back to top |
|
 |
Rhino
*nix forums Guru
Joined: 08 Feb 2005
Posts: 449
|
| Posted: Thu Jul 20, 2006 7:25 pm Post subject:
Re: Query for file names like SC*
|
|
|
"dmeiser" <dmeiser@gmail.com> wrote in message
news:1153397053.079229.17500@h48g2000cwc.googlegroups.com...
| Quote: | I need to write a query that returns the names of all queries in a
library that start with the letters SC. I have not a clue how to even
start something like this. If possible, the boss would like this done
is QRY/400.
|
My experience with DB2 on AS/400 is VERY limited - a few days 10 years
ago! - so please forgive me if this response makes no sense or is way out of
date!
Am I correct in remembering that QRY/400 is the AS/400 equivalent of QMF in
OS/390? I really don't recall but, if it is, and if it closely mirrors QMF
on OS/390, it's pretty easy to list all of the queries by name. You probably
even have a PF Key that lists all queries or that brings up a search screen
where you can specify the type of object you want - form, table, query,
etc. - and specify a pattern for the names. If such a screen exists in
QRY/400, you'll simply have to choose Query as your object type and specify
SC_ as the pattern for the query name.
You haven't specified with version of DB2 for AS/400 your are using but
there should be an Information Center for it on the IBM site, www.ibm.com,
somewhere. If you search on AS/400 Information Center you should find it
eventually. That Information Center should contain full documentation for
QRY/400. (Or just search on QRY/400 and then make sure you look for only the
version of the manual that reflects your sofware.) The documentation should
take you through the techniques you'll need and even have screen shots of
the screens you'll encounter.
| Quote: | Also, if anyone knows how to build a time machine so that I can have
this done by when the boss called 15 minutes ago wanting to have it
done by now, that would be great.
I saw a documentary once where a scientist at MIT claimed they had a working |
time machine (or maybe it was a Star Trek style transporter) but that it was
down for repairs at the moment that the documentary crew was there. He was
winking though so I think you may need to wait another few decades before
that technology becomes available. :-)
| Quote: | Thanks for any help,
Dave
|
--
Rhino |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Mon Dec 01, 2008 8:23 pm | All times are GMT
|
|
Indoor Flag Pole Sets | Mortgages | Consolidate Student Loans | Online Gift Shopping | Car Finance
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
IBM DB2
