Query for file names like SC*

dmeiser

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

Jul 20 '06 #1

Subscribe Reply

1592

Rhino

"dmeiser" <dm*****@gmail. comwrote in message
news:11******** *************@h 48g2000cwc.goog legroups.com...

>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.

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. :-)

Thanks for any help,
Dave

--
Rhino

Jul 20 '06 #2

Similar topics

3913

Write custom column names to query result file

by: Joe Gazda | last post by:

I'm a relative newbie to PHP, but have been able to put together some PHP code to generate a CSV/XLS file from a Query result. Now, I would like to include custom column names instead of the MySQL column table names. I know that there are codes to generate tabs and carriage returns, but can't find anything about including "commas" in a string to output to the file to separate the custom field names. I'd appreciate some help with a line of...

PHP

2356

group by clause Query help

by: aj70000 | last post by:

This is my query select ano,max(date),a_subject from MY_TAB where table_name='xyz' and ano=877 group by a_subject,ano order by a_subject ANO max(Date) A_Subject 877 2005-01-20 00:00:00.000 Subject_1 877 1900-01-01 00:00:00.000 Subject_2 877 2004-12-20 00:00:00.000 Subject_3

Microsoft SQL Server

611

Query problem

by: signaturefactory | last post by:

I am trying the following query in and oleDbCommand: SELECT PartLocations.LocationName, Sum(PartsJournal.Quantity) AS SumOfQuantity, PartsJournal.PartsLotNumber FROM PartLocations INNER JOIN PartsJournal ON PartLocations.LocationID = PartsJournal.LocationID GROUP BY PartLocations.LocationName, PartsJournal.PartsLotNumber, PartsJournal.PartNumber, PartsJournal.LocationID HAVING (((Sum(PartsJournal.Quantity))>0) AND...

Microsoft SQL Server

3394

Query Problem.. udating base file and unable to update it

by: John Baker | last post by:

Hi: I have two tables, a setup table (TblSetup) and a purchase order table (tblPO). When i construct a query with ONLY the tblPO shown, and a type in parameter for the PO number, I an update the original tblPO. However, when I introduce the setup file into the query I cannot update the result. THis is true if I make a link to Setup or not. In fact, setup contains the client ID, which i wish to test against the client ID in the PO...

Microsoft Access / VBA

3513

query by field heading

by: John young | last post by:

I have been looking for an answer to a problem and have found this group and hope you can assist . I have been re doing a data base I have made for a car club I am with and have been trying to make a query that selects from a table as desribed below .. I have a table (Volunteer) that has a member field (memnumber) and a number of fields that are headed in various categories and are yes/no formated

Microsoft Access / VBA

4839

Use Select Query variable against a table and return value to same select query

by: jjturon | last post by:

Can anyone help me?? I am trying to pass a Select Query variable to a table using Dlookup and return the value to same select query but to another field. Ex. SalesManID SalesManName AT Alan Time

Microsoft Access / VBA

3039

How to use OutputTo with named query?

by: deko | last post by:

When using OutputTo with a query, the 'File name' window in the 'Output To' dialog gets populated with the name of the query by default. This makes the exported file self-describing if the query is named on the fly. The benefit is consistent file naming, and users don't have to enter a file name when exporting. The problem is the query has to be renamed every time, and I don't know how to find it in the QueryDefs collection other than...

Microsoft Access / VBA

3026

Query to Initial Email?

by: Liam.M | last post by:

hey guys, I have one last problem to fix, and then my database is essentially done...I would therefore very much appreciate any assistance anyone would be able to provide me with. Currently I have set up a Query to show only records that meet a certain criteria...therefore excluding all of the records that do not meet this criteria (just for the record the criteria is any record within my database that falls within two months of its "Due...

Microsoft Access / VBA

2661

SELECT Query Help - Multiple Records

by: Jordan M. | last post by:

Hi, Hoping to get some help modifying the following query that I have... TABLE: NAMES ID, FirstName, LastName TABLE: EMAILS ID,LinkID,Email,LastUpdateDate

Microsoft Access / VBA

3626

QUERY (vlookup fashioned)

by: Sinner | last post by:

Hi, I have a field name 'USER' in tableMAIN. How do I replace the user names with corresponding user names. I can do that in xl using vlookup but now I'm trying to find a way to do that in access. For a user mismatch, it should give NA Thx.

Microsoft Access / VBA

8394

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8306

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8825

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8732

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8605

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6164

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4152

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

2726

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1955

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP