JSL: close data table not responding

[#1]

Hi,

I have three opened data tables defined by dt_pp, dt_pp_t, dt_final and I want to close them. My script contains the following lines:

Close( dt_pp, No Save );
Close( dt_pp_t, No Save );
Close(dt_final, No Save);

If I run the whole script, it closes the two first data tables and not the last one. But if I select this particular line and run it, it works and the table closes. 

What am I doing wrong/missing here?

Thank you!

[#2 · Accepted solution]

@Aziza, 
          Maybe you could make the tables current before trying to close them ? 

Current Data Table(dt_pp); 
Close(dt_pp,"No Save"); 
Current Data Table(dt_pp_t); 
Close(dt_pp_t,"No Save");

Current Data Table(dt_final); 
Close(dt_final,"No Save"); 

[#3 · Accepted solution]

From your file names, I wonder, if your second file might be linked or still being used.

For example if the second file (dt_pp_t) was a summary of the first (dt_pp), closing dt_pp will automaticaly close dt_pp_t and the second close statement might cause an error, and the third statement is not run.  

When you run your script, look at the log file (CTRL + Shift + L) to see if there is an error statement; that might help. 

You did not state if you were running your script interactively, or scheduled/batch.  If a JSL statement results in a prompt when running interactively, when running remote/batch, the script will end.

Just a few ideas on where  to look.

[#4]

Thank you!