Re: iSeries Acces File Transfer

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

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.