Reading the BR*Tools responses from a file

[Former Member]

Hi,

Can we keep all the responses for BRTools in a file & ask BRTools to read from it? We need this to perform the repetitive tasks.

I have tried this. BR*Tools reads first few responses but give error u201CBR0255E Cannot read from standard inputu201D

Can anybody suggest how this can be done?

Regards,

Vivdha

[lbreddemann]

Hi there,

just to add my two pence:

BRTOOLS is just the menu interface program!

It does no do anything itself.

All it does is to create the appropriate command line calls for the subprograms (brspace, brconnect, brarchive etc).

All these programs are called programmatically (also by the CCMS) without having the need to read anything from standard input.

If you want to schedule some commands - just read the documentation on the command parameters. That's all you need.

Anyhow, I've to agreed with Markus: where is the advantage in trying to use a script where a single command does the job?

regards,

Lars

[former_member204746]

in most cases, you can build a br*tools command with proper options that will not ask you for a prompt.

without any prompts, I can do backups, move tables to other tablespaces, re-index tables etc...

trick is to use option "-c force" without quotes within your BR commands.

[markus_doehr2]

I'm not sure I get your question...

Before you actually execute any function using brtool, it will list the full command including the given parameters in one command line.

Markus

[Former Member]

Hi Markus,

Instead of using commands we want to save all the responses (like continue, back etc. using the standard keys) in a file & execute it through BR*Tools using file redirection technique.

I am reading the file by executing at the command prompt brtools < <file>

It worked fine in SAPDBA. This is working partially in the BR*Tools, but its giving the error as mentioned in my previous post.

Regards,

Vivdha

[markus_doehr2]

> Instead of using commands we want to save all the responses (like continue, back etc. using the standard keys) in a file & execute it through BR*Tools using file redirection technique.

The question is: why? What is your issue with using "one" command instead of a command + a file?

> I am reading the file by executing at the command prompt brtools < <file>

I understand the issue and what you want to do - but again, why do you want to that if there is a much easier way of doing it?

Markuks

[former_member204746]

example:

to move all tables form tablespace PSAPFACT2D to PSAPFACTD/PSAPFACTI, I could use this command:

brspace.exe -u / -c force -f tbreorg -t "*" -s PSAPFACT2D -n PSAPFACTD -i PSAPFACTI -p 1 -e 4

This command is fully automatic and no prompts are shown.