DSXchange

How many nodes are in your APT_CONFIG file? Also, if you aren't changing the number of nodes between the transform and output dataset, no collection will take place so the data will, of necessity, be in the same order each run.

My post meant that the next prompt would have been the project, so any attach will be to the $DSHOME or master directory. Is this a mounted drive and do you have any sort of security installed in addition to the normal Windows mechanism?

After you created the file, do a "VLIST DSG_BP DSR_LOADSTRING.B" and you'll get the pcode dump which will give you a correct line number as well. The codes can be consfusing, so just post 10 lines before and after.

Then get the list of files into your sequence, for instance through "ls -m", loop through all names, use a user-variables stage to extract the date portion from the file name, peform an ICONV() on it and get the delta to today's date. If more then 180 days then branch to an execute delete,...

Can you just switch to the CFF stage? If you don't need the header then another option is to set "first line is column names" and DS will ignore it.

I assume you mean through the Director interface. The answer is "yes", but you need to enter it 3 different times, once daily for 07:00, 13:00 and 18:00.

If I recall correctly, the next question is for the project; so my guess is that it encounters that problem when it attaches to the DataStage home directory to try to read the UV.ACCOUNT file.

Can you login to DOS and do a "CD" there?

I'm not aware of a specific published IBM work on that topic.

The DSParams file is a text file.

I'm not sure if the syntax is correct, but "find /yourpath -name AREA-*.CSV -ctime +180" will give you a list of files. You can even expand that to "find /yourpath -name AREA-*.CSV -ctime +180 -exec rm {} \;"

"Quite Close" means that you might get a problem if a job is open and being edited, or a job is running and writing hundreds of log messages a second. In both cases you might need to recompile or re-initialize the job upon restoring since the state at backup time was in flux. The restartab...

The question was more which date - the date in the name or the actual date-time-stamp of the file on disk?

I should amend my first note to say that variables starting with $ aren't allowed in BASIC. But looking at my generated code it seems that you can use "($OracleUser)"

From the Admin or from a TCL shell what output do you get for "LIST DS_STAGETYPES WITH @ID = 'CallUTFStripC'"

Add a stage to call DSLogInfo() or DSLogWarn() and output your variable to see which value you are getting, there is probably a small logical error somewhere, the overall approach is correct.

p.s. You posted in "ProfileStage", not quite the appropriate forum.