topic Re: JSL: close data table not responding in Discussions

JSL: close data table not responding

Aziza — Wed, 18 Apr 2018 13:18:50 GMT

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!

Re: JSL: close data table not responding

uday_guntupalli — Wed, 18 Apr 2018 14:54:43 GMT

@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");

Re: JSL: close data table not responding

gzmorgan0 — Wed, 18 Apr 2018 17:45:27 GMT

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.

Re: JSL: close data table not responding

Aziza — Mon, 23 Apr 2018 06:38:14 GMT

Thank you!