How to remove stage data through Sequential file stage

Krazykoolrohit · Post by **Krazykoolrohit** » Wed Jun 21, 2006 8:35 am

Hi,

I am extracting a table and then loading it into another with a sequential stage in between.

i want to use the filter option in the sequential stage to delete this file once my load in over. Any suggestions?

Any other way i can delete the file? other than a after job routine?

kumar_s · Post by **kumar_s** » Wed Jun 21, 2006 8:41 am

Filter option is to facilitate the read operation. I belive its not possible to delete the read file using the filter option.
But what stops you to use after job subroutine?

kris007 · Post by **kris007** » Wed Jun 21, 2006 8:41 am

You can use an IPC stage instead of a Sequential File stage, if you are doing the whole process of extracting and staging in sequential file and then loading into another table in a single Job. Else, another way I could think of would be to use a Execute Command stage in Job sequence after the Job, but using an after job subroutine would be much simpler and easier. May I ask why you would want to avoid using an after Job subroutine?

Krazykoolrohit · Post by **Krazykoolrohit** » Wed Jun 21, 2006 8:44 am

I want to avoid it because i already have a routine running for each job and i would have to modify them.

Can you guide me how to remove the sequential file in a routine? I would also like to know if i can run two after job subroutines

kris007 · Post by **kris007** » Wed Jun 21, 2006 9:23 am

How about other suggestion I have mentioned.? Do they serve as other options?

DSguru2B · Post by **DSguru2B** » Wed Jun 21, 2006 9:24 am

In the next job, you can do it in the before job subroutine.
Also, i would advise not to delete the file untill the end of the entire process. You might be needing to look at the file if something goes wrong. Basically for debugging purposes. If that is not an issue, then i would go with Kris's suggestion. Use an ipc stage.

Krazykoolrohit · Post by **Krazykoolrohit** » Wed Jun 21, 2006 9:34 am

thanx a lot . will try this

DeepakCorning · Post by **DeepakCorning** » Wed Jun 21, 2006 11:39 am

Topic Hijack -- Can I write to a sequential File which is present in some other share drive (LAN) and is not actually present in a physical drive on the ASCL server.

OS : Windows.

kris007 · Post by **kris007** » Wed Jun 21, 2006 1:12 pm

Yes, you can write to sequential file which is present on another shared drive which is mapped to your ascential server. You will have to use UNC(Universal Naming Convention) path as the path for the sequential file.

why would you want to hijack a thread? It is not adviced.
HTH

DSguru2B · Post by **DSguru2B** » Wed Jun 21, 2006 1:15 pm

Hijacking is not permitted

Ops, that was a little harsh, just pulling your leg

Try browsing for the file server from within the sequential file stage. If the server is visible, then you can.

kris007 · Post by **kris007** » Wed Jun 21, 2006 1:32 pm

DSguru2B wrote: Try browsing for the file server from within the sequential file stage. If the server is visible, then you can.

It doesn't have to be visible to be able to write to or read from. If the shared drive you wanted to write data to is mapped to the Ascential drive then that should be enough. You can just specify the UNC path of the mapped drive and sequential file stage is going to write to or read from that drive.

DeepakCorning · Post by **DeepakCorning** » Thu Jun 22, 2006 9:46 am

When we say UNC path do we mean like if I create the share like H:\ , then I shoud say like h:\file.csv even if I am not able to see it in the browse button??

Sorry guys for hijacking the topic I was little Lazy to create a new one....

kris007 · Post by **kris007** » Thu Jun 22, 2006 9:58 am

You should give the filepath as

Code: Select all

\\servername\foldername\filename.csv