Search Results

Hi,

I'm trying to set up scp but it isn't as nice as WinSCP. My requirement is to transfer a file from one machine to another with scp. This would run in a .ksh so it would need to avoid prompts...

Hi,

The script was initially on a windows machine with MKS Toolkit. oproc is a command for that which "Corresponds to the Win32 ENABLE_PROCESSED_OUTPUT mode. Allows ASCII control sequences and...

Thanks for the info pludi. There was reference to CAT instead of cat and once it was changed the script worked.

Thanks <3

---------- Post updated at 05:03 AM ---------- Previous update was at...

Hi,

Sorry that was a problem of not referencing correctly in the variables. Instead of currentfolder/deeperfolder like in Windows I had the variable just refer to the deeper folder. I now have a...

Thanks expert...I set it to text transfer & it worked fine. Now I　ｊｕｓｔ　ｈａｖｅ　ｔo go through figuring out why errors appear =]
Any idea why:

export ORCL_SQL="${HKTMP}/orcl.sql"
>$ORCL_SQL
[[ -s...

Hi, a script was used on Windows using MKS Toolkit. I'm trying to move it to a unix machine but it gets all errors. At first I had things like: syntax error: `in^M' unexpected

I still get these...

Hi, looking at my graphs in APEX part of the process has been carried out but I haven't received an email. This is due to where I've located the procedure though so all is good now. Thanks =)

It says "could not start" in the "scheduled task" section. It did the same thing when I commented out (::) the main line meaning that all that was left was the path settings & exit

It also says it...

Hi guys,

I need a *.bat to run a ksh file in the shell on Windows NT...nothing more :) How do I do it? I tried with the following but it failed:
set INFORMIXDIR=D:\user-applications\informix
set...

Hi Scott,




Thanks I had tried it like that & it worked (the procedure call). Guess its a bit OTT wanting it in 1 connection when speed isn't even important with the task. The fail part is not...

Hi Scott,

No the email is sent at the end. The loop goes to 24 databases and collects bits of data from them. The email_procedure then sends an email to various people listing those databases...

Hi scott,

No, I don't have to it's just that I read somewhere about keeping connections open because of the time it takes to repeatedly connect. So are you saying?:
cat << !
set heading off
set...

Hi Scott,

The email_procedure has no parameters.
./hkstats.ksh does some processes which ultimately inserts the current size of various databases (which the loop accesses) into a table. Some of...

Hi Scott,

I wish to call a stored procedure located on the database I connect to through SQLPlus.

Hi Scott,

Thanks so much it works perfectly. I'll try the 2nd idea after this is done running as that would allow for multiple lines in the do while I'm guessing whereas I tried doing 3 lines (2...

Hi,

I'm using korn shell. Where would that info (set heading off) go in my code?

The error is abnormal exit which is based off:
trap "stty sane;echo '\n\n *** Abnormal exit ***';exit" 1 2 3...

Hi I have a script which is coming up with errors when I iterate over a list of database names. When I print out the values it shows a title & underline...if I then attach "hi" to the print out I get...

NP++ sucks :x compressing aint great because the process will be automated where it is moved from one area to the other and then from there it is read into a stored procedured and used as an email...

It successfully sends the file now. It was because I didn't put the full file location in :f (C:\...). :D I had a scare where after emailing it myself the formatting is ruined, but after looking it...

Hi Zaxxon,

Apparently it copies but the file can't be located...It worked when doing unix-unix but no file when doing nt-unix.

Mike

Hi guys,

I wasn't sure which thread to include this one in (unix or shell scripting) but chose here based on search results. I need to automate a process which requires the need to transfer a...

The only one to actually do anything (other than asking for input again was your last suggestion (otherwise:) which had this :) http://i29.tinypic.com/2ug32iq.png

I don't actually have to output...

Well I can't connect to the database at the moment :)

Edit: It's working now, thanks. I had the wrong login/pwd details :f Copied them from a local copy on here but when looking at the live .ksh I...

I don't understand what you mean. Do you mean that is how you would do it? If so why do you have exclamation marks surrounding the column name? I also don't understand grep or the stuff after $line :(

Huh?

Mike