Posted by Grant Foraker on April 28, 2011 at 12:26:32:
At some point, I'll have to convert a number of $ files that look like ...
!--------------- DONT CHANGE THE SEQUENCE OF THE FOLLOWING LINES ---------------
INPUT JAHR.AUDIT (JAHR-P01)
PRINTER JAHR0088.TXT,TMP,H
!-------------------------------------------------------------------------------
DEFINE DATE.DD = SUB(REGISTER.DATE,7,2);2
DEFINE DATE.MM = SUB(REGISTER.DATE,5,2);2
DEFINE DATE.YY = SUB(REGISTER.DATE,1,4);4
DEFINE DATE10 = (DATE.MM+'/'+DATE.DD+'/'+DATE.YY);10;DATE
SORT ON EMPLOYEE.NO;JOB.NO;REGISTER.DATE
REPORT
PRINT EMPLOYEE.NO;EMPLOYEE.NAME;JOB.NO;ITEM.NO;DATE10;
REG.HOURS;OT.HOURS;DT.HOURS
!--------------- DONT CHANGE THE SEQUENCE OF THE FOLLOWING LINES ---------------
LAUNCH EXCEL.EXE C:\USERS\JOEYF\APPDATA\LOCAL\TEMP\CATEMP\JAHR0088.TXT
!-------------------------------------------------------------------------------
Currently, the user runs a selection program with lots of options and after the data set is the selected $ files is opened and the INPUT, PRINTER and LAUNCH lines are UPDATED and the $ is then run.
None of the new PROMPT options seem to do what I want. What I'd like to do is write my substitutions into the #CPROMPT file instead of updating the $ file.
So the new IBR file would look like ...
!--------------- DONT CHANGE THE SEQUENCE OF THE FOLLOWING LINES ---------------
INPUT JAHR.AUDIT (%Input.File%)
PRINTER %Output.File%,TMP,H
!-------------------------------------------------------------------------------
DEFINE DATE.DD = SUB(REGISTER.DATE,7,2);2
DEFINE DATE.MM = SUB(REGISTER.DATE,5,2);2
DEFINE DATE.YY = SUB(REGISTER.DATE,1,4);4
DEFINE DATE10 = (DATE.MM+'/'+DATE.DD+'/'+DATE.YY);10;DATE
SORT ON EMPLOYEE.NO;JOB.NO;REGISTER.DATE
REPORT
PRINT EMPLOYEE.NO;EMPLOYEE.NAME;JOB.NO;ITEM.NO;DATE10;
REG.HOURS;OT.HOURS;DT.HOURS
!--------------- DONT CHANGE THE SEQUENCE OF THE FOLLOWING LINES ---------------
LAUNCH EXCEL.EXE C:\USERS\JOEYF\APPDATA\LOCAL\TEMP\CATEMP\%Output.File%
!-------------------------------------------------------------------------------
The PROMPT doecumentaion does't give much info on #CPROMPT other than it's Keyed.
1) What it's specifications? Is the key repeated in the data?
2) Does it have to be on TMP?
3) Could it be a permanent file on COS?
4) If it's on COS and there are more PARTITION$ + PROMPT keys, say leftovers from a prior report, than the current report needs, would the current report care about the extra keys?
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.