SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Redirect output

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
Redirect output
Author Message
Pierre Dupuis



Joined: 22 Aug 2000
Posts: 85

Post Redirect output Reply with quote

When I try to redirect output into a file it's not work. Why?

This run well into dos session but not work with 24x7.

sqlplus csi_fct/csi_fct@ecm_dev @E:\APPLICAT\CSI\PRD\BIN\RefreshCSIOrd.SQL e:\applicat\csi\prd\data\\ronord >> e:\applicat\csi\prd\log\refresh.log 2>&1

Please help.

Thanks.

Mon Aug 28, 2000 3:41 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Re: Redirect output Reply with quote

Use > instead of >>

: When I try to redirect output into a file it's not work. Why?

: This run well into dos session but not work with 24x7.

: sqlplus csi_fct/csi_fct@ecm_dev @E:\APPLICAT\CSI\PRD\BIN\RefreshCSIOrd.SQL
: e:\applicat\csi\prd\data\\ronord >>
: e:\applicat\csi\prd\log\refresh.log 2>&1

: Please help.

: Thanks.

Mon Aug 28, 2000 5:04 pm View user's profile Send private message
Pierre Dupuis



Joined: 22 Aug 2000
Posts: 85

Post Re: Redirect output Reply with quote

: Use > instead of >>

I did that and it still not work. Any idea?

Tue Aug 29, 2000 6:57 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Re: Redirect output Reply with quote

SQL*Plus is not a Windows console application. It does not write to the standard output. In the SQL*Plus if possible use the "Spool" functionality (see File/Spool menu) or run your sql from 24x7 JAL screept for maximum flexibility and full control.

: I did that and it still not work. Any idea?

Tue Aug 29, 2000 8:06 am View user's profile Send private message
Pierre Dupuis



Joined: 22 Aug 2000
Posts: 85

Post Re: Redirect output Reply with quote

: SQL*Plus is not a Windows console application. It does not write to the
: standard output. In the SQL*Plus if possible use the "Spool"
: functionality (see File/Spool menu) or run your sql from 24x7 JAL screept
: for maximum flexibility and full control.

Why with DOS i can redirect with ">>" and this is not working with your product???

Tue Aug 29, 2000 8:12 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Re: Redirect output Reply with quote

You can try using the Server Manager (SRVMGR) instead of graphical SQL*Plus

: I did that and it still not work. Any idea?

Tue Aug 29, 2000 8:19 am View user's profile Send private message
Pierre Dupuis



Joined: 22 Aug 2000
Posts: 85

Post Re: Redirect output Reply with quote

: Why with DOS i can redirect with ">>" and this is not working
: with your product???

There are two product SQLPLUSW (no interract with window) and SQLPLUS (window console application. So if i used with DOS

sqlplus csi_fct/csi_fct@ecm_dev @E:\APPLICAT\CSI\PRD\BIN\RefreshCSIOrd.SQL e:\applicat\csi\prd\data\\ronord >> e:\applicat\csi\prd\log\refresh.log 2>&1

OR

sqlplus csi_fct/csi_fct@ecm_dev @E:\APPLICAT\CSI\PRD\BIN\RefreshCSIOrd.SQL e:\applicat\csi\prd\data\\ronord > e:\applicat\csi\prd\log\refresh.log 2>&1

THOSE ARE WORKING WERY WELL.
PLEASE HELP.
THANKS.


Tue Aug 29, 2000 8:22 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Re: Redirect output Reply with quote

24x7 sends your command to the Windows shell as it is specified in your script.
If you think that the shell executes it differently than the DOS, create a .BAT file containing this command ant run it instead of SQL*Plus

: Why with DOS i can redirect with ">>" and this is not working
: with your product???

Tue Aug 29, 2000 8:23 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Re: Redirect output Reply with quote

Ok, here it is,
"e:\applicat\csi\prd\log\refresh.log"

change it to "e:\applicat\csi\prd\log\\refresh.log"

You should either use double-backslash everywhere where a a back-slash is needed or turn-off special ASCII symbols in the Tools/Options/Editor menu

: There are two product SQLPLUSW (no interract with window) and SQLPLUS (window
: console application. So if i used with DOS

: sqlplus csi_fct/csi_fct@ecm_dev @E:\APPLICAT\CSI\PRD\BIN\RefreshCSIOrd.SQL
: e:\applicat\csi\prd\data\\ronord >>
: e:\applicat\csi\prd\log\refresh.log 2>&1

: OR

: sqlplus csi_fct/csi_fct@ecm_dev @E:\APPLICAT\CSI\PRD\BIN\RefreshCSIOrd.SQL
: e:\applicat\csi\prd\data\\ronord > e:\applicat\csi\prd\log\refresh.log
: 2>&1

: THOSE ARE WORKING WERY WELL.
: PLEASE HELP.
: THANKS.

Tue Aug 29, 2000 8:28 am View user's profile Send private message
Pierre Dupuis



Joined: 22 Aug 2000
Posts: 85

Post Re: Redirect output Reply with quote

: Ok, here it is,
: "e:\applicat\csi\prd\log\refresh.log"

: change it to "e:\applicat\csi\prd\log\\refresh.log"

: You should either use double-backslash everywhere where a a back-slash is
: needed or turn-off special ASCII symbols in the Tools/Options/Editor menu

STILL NOT WORK!!!!!!!!!!!!

i tried something simple for you (maybee you can test it):

DIM PROCESS,NUMBER
Dim command1, string "sqlplus pdupuis/password@dwh_prd @C:\\TEST.SQL >C:\\test.log"
RunAndWait(command1, "", 0, process)

WHERE TEST.SQL IS:
SELECT * FROM TABLE;
EXIT

SAME THING WITH OR WITHOUT DOUBLE BACKSLASH.

PLEASE HELP.

THANKS.


Tue Aug 29, 2000 9:24 am View user's profile Send private message
Pierre Dupuis



Joined: 22 Aug 2000
Posts: 85

Post Re: Redirect output Reply with quote

: STILL NOT WORK!!!!!!!!!!!!

: i tried something simple for you (maybee you can test it): DIM PROCESS,NUMBER
: Dim command1, string "sqlplus pdupuis/password@dwh_prd @C:\\TEST.SQL
: >C:\\test.log"
: RunAndWait(command1, "", 0, process)

: WHERE TEST.SQL IS: SELECT * FROM TABLE;
: EXIT

: SAME THING WITH OR WITHOUT DOUBLE BACKSLASH.

: PLEASE HELP.

: THANKS.

Please answer.

Tue Aug 29, 2000 11:34 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Re: Redirect output Reply with quote

Try this using Windows Run command (System Start button on taskbar, then click Run, paste the command, click OK). You will see that SQLPLUS will not write to the file but instead it will output to screen (in both cases > and >>).

Therefore, it is SQLPLUS default behavior and it has nothing to do with the 24x7.

Again, try using the SPOOL command in SQLPLUS to send all output to the file.

: STILL NOT WORK!!!!!!!!!!!!

: i tried something simple for you (maybee you can test it): DIM PROCESS,NUMBER
: Dim command1, string "sqlplus pdupuis/password@dwh_prd @C:\\TEST.SQL
: >C:\\test.log"
: RunAndWait(command1, "", 0, process)

: WHERE TEST.SQL IS: SELECT * FROM TABLE;
: EXIT

: SAME THING WITH OR WITHOUT DOUBLE BACKSLASH.

: PLEASE HELP.

: THANKS.

Tue Aug 29, 2000 2:46 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.