× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. March 2007

Re: iSeries Acces File Transfer

There IS help in the download screen, but here goes.
You are building an SQL SELECT statement using this wizard. 'Select' is the columns you want to see, and 'Where' is the conditions or filters. To get a nice query builder, click on details, where you see 3 tabs. In each of them, assuming you have put an existing file name in at first, you will get a list of fields and operators and functions - perhaps the nicest query builder IBM has for the iSeries!
For the 'Where' you can either type in an appropriate WHERE clause or click on 'Details'. In your case you want a not equals thing 

(FIELD1 <> 'A99')
That's it - now, once you are in the Details window, there is extensive help by clicking on the Help button. 

Enjoy - it's a great tool.
Vern

At 02:49 AM 3/22/2007, you wrote:



I'm using iSeries Access Data Transfer to download a file from our i5.
The first thing I do with this file is open it in Excel and remove all
rows where the first field has a value of A99.

It seems to me that I must be able to get Data Transfer to not download
anything where the first field = A99, probably by using the 'Select' or
'Where' options under 'Data Options'. Only I can't figure out how to do
it. Can anyone help?




--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.