DSXchange

I've taken a bit of both suggestions, but made a quick and dirty controller job that looks like this: DONE = @FALSE LOOP OPENSEQ "KillLoop.Txt" TO KillFile THEN CLOSESEQ KillFile DONE = @TRUE END UNTIL DONE DO SLEEP 300 OPENSEQ "FilesExist.Txt" TO ExistFile THEN CLOSESEQ ExistFil...

Hello, I have a job that waits for a specific type of file to be FTP'd into a directory. I have the DSWaitForFile setup as a before subroutine. The file is FTP'd into the folder and the job works like charm. My problem is that the job then finishes. I want it to reset and start looking for the file ...

Hello, I have a job that waits for a specific type of file to be FTP'd into a directory. I have the DSWaitForFile setup as a before subroutine. The file is FTP'd into the folder and the job works like charm. My problem is that the job then finishes. I want it to reset and start looking for the file ...

Thanks for all of the help. You are correct in that I can probably get away with a sequential file. I am definately in a learning state with this tool and all of your help is greatly appreciated. Can you suggest any documentation which give tips and tricks like you have provided? I use the BASIC man...

Awesome!!! I was so close....

Thanks alot.

Thanks. I understand what you are saying. Please forgive me as this is my first time working with reading data/hash files through the code. This now only goes through one iteration of the loop. If I dont run the hJob2 then the correct iterations occur. Why would the execution of job 2 effect my posi...

I have a HashTable with 2 fields in it: FILENAME and CFG_FILENAME. I have setup a loop to read through all records in this hash table and I want to pass the CFG_FILENAME as a parameter to another job. I cannot figure out how to extract the value from the CFG_FILENAME field. Here is my code: OPEN &qu...

I have a HashTable with 2 fields in it: FILENAME and CFG_FILENAME. I have setup a loop to read through all records in this hash table and I want to pass the CFG_FILENAME as a parameter to another job. I cannot figure out how to extract the value from the CFG_FILENAME field. Here is my code: OPEN &qu...

I have a HashTable with 2 fields in it: FILENAME and CFG_FILENAME. I have setup a loop to read through all records in this hash table and I want to pass the CFG_FILENAME as a parameter to another job. I cannot figure out how to extract the value from the CFG_FILENAME field. Here is my code: OPEN &qu...

Thanks......THis is my first DS job and the help files led me to believe that every field would need to be the same length. It also made reference to a completely different stage to use.

I've got it working.

Thanks again.
Frank.

I have a flat text file that I want to use as input and output. This is not a delimited file, nor is each column the same fixed length. Each column is in its own positions(ie: Emp#=Pos1..6 SSN=Pos 7-17 Salary=Pos18..30). From what I can see a sequential stage cannot handle this type of file definiti...