DSXchange

If you are gathering information about a parallel job after it has run, you can invoke a BASIC routine in 7.x as an After Job Routine in a parallel job, because once the job is finished it is no longer running in parallel. That After Job Routine still has access to the job's handle, so it can procee...

Do you mean the File Pattern option of an input sequential stage in Enterprise Edition?

OK, so what should we do if the Julian date comes in as a character string, say, "2007128"?

or you could use wildcards if your file names are amenable) Ray, I recently found that I couldn't use wildcards in the filter command. Craig also found the same issue. Do you know that it can be done? Is there some specific syntax to get it to work? Or is it just not working in our versions of DS. ...

Whoops! When I specify a file pattern for the output source and then enter something like ABC* for the file pattern, the sequential stage reads in the multiple files just fine, but the File Name Column reports the file name as ABC*. I was hoping that it would give it as ABCRestOfFileName. Any sugges...

Thanks, I see it now. "File Name Column" is an option on the sequential file stage.

Ed

If I specify a File Pattern for the source on the output tab of a sequential file stage (and pull in data from multiple files) is there any way to know the name of the file that is coming in as each record is read in?

Hi The "bug" is on your level 01. It's the name of the record and cannot be dimensionned. You had 01 BDIPDATA-RECORD PIC X(97). 05 BDIPDATA-RECORD-ID PIC X(03). 05 BDIPDATA-RECORD-DATA PIC X(93). 05 BDIPDATA-RECORD-DELIMITER-X PIC X(01). You can say 01 My Record 03 BDIPDATA-RECORD PIC X(9...