I am trying to send a transmit command that I would like to include a variable, signified by the "xx" in the record. xx will be input as an integer string in the opening of the program to signify the month being processed.
[transmit "WBW.WHERE(CUST_CODE EQ `"ISCME`" AND INV_DATE GE UDATE(xx,01,01) AND INV_DATE LE UDATE(xx,28,01)^M"]
This line of code is part of a data selection query. I don't want to have to edit this query each time it is run, I want to use a variable as input. ANY SUGGESTIONS?
Thanks much, in advance.
[transmit "WBW.WHERE(CUST_CODE EQ `"ISCME`" AND INV_DATE GE UDATE(xx,01,01) AND INV_DATE LE UDATE(xx,28,01)^M"]
This line of code is part of a data selection query. I don't want to have to edit this query each time it is run, I want to use a variable as input. ANY SUGGESTIONS?
Thanks much, in advance.