Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pantherv

    FTP - again.

    Thanks for the replies. Still no joy, even with single quotes. Will ensure FTP server is active at the target IP address and then respond. Thanks again.
  2. pantherv

    FTP - again.

    I have a program that outputs to a single file from a series of files (orders, items, invoice etc). Then I do CPYTOIMPF to set up a stream file as /filename.csv. With FTP from a PC I can grab this file and download direct to Excel (albeit without column headings, but as the plan is to extract...
  3. pantherv

    OPNQRYF

    ladeecroft - after changing the CL to use a variable ISDB showed that &ROUTEF was the problem as it can be blank and %RANGE had problems with that. Using *GE and *LE as above is able to cope with the blank. Thanks for that pointer.
  4. pantherv

    OPNQRYF

    Thanks for the replies. Now have: CHGVAR VAR(&QRYSLT) VALUE('(LRDTE = %RANGE(' || + &DATE1 *BCAT &DATE2 || ')) *AND (LROUT + *GE "' *TCAT &ROUTEF *TCAT '") *AND (LROUT + *LE "' *TCAT &ROUTET *TCAT '")') OPNQRYF FILE((ECLL33))...
  5. pantherv

    OPNQRYF

    I want to code an OPNQRYF statement in a CL program, not sure this is the right forum but here goes. It should have a QRYSLT statement along the lines of LRDTE = %RANGE(&DATE1 &DATE2) *AND LROUT = %RANGE(&ROUTEF &ROUTET) I have tried all sorts of combinations using ''' ( ) || *CAT *BCAT etc but...
  6. pantherv

    CL command for FTP download.

    Greetings all. We have several routines to build files that are then downloaded to shared drives using FTP. Want to build the download commands into CL. Not exactly a CL specialist yet - can anyone point me in the right direction or to another thread already on this site. All help appreciated.

Part and Inventory Search

Back
Top