Gilly400 Dec 30, 2008   3:14 PM GMT

Hi, If it's in the IFS you can use RMVLNK. Regards, Martin Gilbert.

23,730 pointsBadges:

Anderson123 Dec 30, 2008   3:48 PM GMT

hey thanks it works....but i need to create a code which deletes the old txt files based on date...I have created a prog to purge flat file members by reding from outfile of dspfd but wat can be done to purge members from a folder or directory.

0 pointsBadges:

philpl1jb Dec 30, 2008   10:42 PM GMT

This might do it -- display folder DSPFLR FLR(yourdir) TYPE(*DOC) OUTPUT(*OUTFILE) OUTFILE(yourlib/yourlist) Phil

54,090 pointsBadges:

Anderson123 Dec 31, 2008   9:32 AM GMT

Dspflr is throwing errors saying folder not found....I believe it work only for folders(FLR) and not directories(DIR) in which my text file is.So how do i go about deleting my txt files based on date?

0 pointsBadges:

Gilly400 Dec 31, 2008   11:01 AM GMT

Hi, You can probably use WRKLNK - but this will only output to a spooled file, then you'll have to convert the spooled file to a readable format for your programs. Regards, Martin Gilbert.

23,730 pointsBadges:

Anderson123 Dec 31, 2008   11:39 AM GMT

converting spool file to a readable format...is that a long process?

0 pointsBadges:

Gilly400 Dec 31, 2008   12:26 AM GMT

Hi, Converting to a readable format basically means creating a physical file and copying the spooled file data to the physical file using the following commands :- CRTPF CPYSPLF Then you can read your physical file in CL or RPG. Regards, Martin Gilbert.

23,730 pointsBadges:

Anderson123 Dec 31, 2008   1:17 PM GMT

I created a flat file and copied a spool file output of dsplnk to this flat file.But am not sure how to extract the name of the text file from this file.

0 pointsBadges:

Gilly400 Dec 31, 2008   1:42 PM GMT

Hi, You'll need to read the file into a CL or RPG then pick the data out using %SST (CL) or subfields on an input spec (RPG). Read until you get a record with position 26-29 = 'STMF', then use position 2-25 as the file name. If position 26-29 is not STMF ignore the record. Regards, Martin Gilbert,

23,730 pointsBadges:

Anderson123 Dec 31, 2008   2:42 PM GMT

hey gilly thanks a lot I was able to read the file in a cl and get the name of the txtfile. i have another query.As you suggested i have created a flat file and then copied the spool file content to this file. Now i have created a txt file as you know in a cl.Can the same cl be used to dsplnk to a splfile and then copy from qsysprt to a flat file.Each time the cl runs a new set of records will get added to the flat file(that is details of new txt file).Purging can be done in a seperate program i believe.Can you assist?

0 pointsBadges:

Gilly400 Dec 31, 2008   2:56 PM GMT

Hi, That should work OK - you'll need to specify *LAST for the spoolfile number on the CPYSPLF command. Regards, Martin Gilbert.

23,730 pointsBadges: