Search results for query: *

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.

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

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.

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

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

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.