Search Results

Thanks a lot. That worked.

ITEM67|WFLX|39.99
ITEM68|WGEN|new
ITEM72|WGEN|new
ITEM73|WGEN|new
ITEM75|WGEN|new
ITEM76|WGEN|new
ITEM78|WFLX|39.99
ITEM80|WGEN|new
ITEM83|WGEN|new
ITEM84|WFLX|44.99
ITEM85|WFLX|39.99

so...

###----------------------TEST FOR $ Value------------------------
sort $RTF 2>>$LOG | nawk -F\| '\
{
for( i=1; i<=NF; ) {
if( i == NF )
{
...

I do not have access to crontab. Is there something that can be done besides using cron?

Is there a utility that can be used in a shell script that would run a .sql file for 30 or 31 days in a month at the same time parallely. Please Advice.

Thanks

SD12.

Actually, there is a syntax error, but I figured it out:

echo "$VALUE" | sed '/^[ ]*$/d' | sed 'N;s/\n/ /' >> $LF #LOG_FILE

Thanks a lot. I have what I need as my correct format for the log...

Thanks to you both. I have come this far:

echo "$VALUE" | sed '/^[ ]*$/d' >> $LF #LOG_FILE

Gives:

0 rows created.
Commit complete.
1164988 rows created.
Commit complete.
8320999...

This def. works. Thanks rob. I still need to get rid of the blank lines in between:

0 rows created.


Commit complete.


1164988 rows created.


Commit complete.


8320999 rows...

This is the .sh script:

#!/bin/sh
LFPD=`TZ=CST date +%Y%m%d` #PROCESS_DATE
LFFD=`TZ=CST+24 date +%Y%m%d` #FOR_DATE
LFN="${LFFD}_detain_${LFPD}"
LFP=/:/detain/sd12/logs ...

I'm trying to read the output of a .sql script (simple insert and commit oracle pl/slq script) to a log file using a shell script. My problem is I end up with a log file that looks like this:
...

Also read up on my post "shortcuts". Thanks to some really smart ppl in this forum you'd know how to get the Alias command working for you

That was amazing it works !!!. Thanx to you i can now have shortcuts to the long pathnames where i can run my scripts

[sd12@phenix sd12]$ cat .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs
...

yes, but i think that just gives it an assigns it a name. It does not actually execute the command from one directory and take me to that location as specified by the actual path name

Hi,

I'm new to this forum, but i'm getting to work on some unix and i like it a lot. I'm trying to figure out a way i can create a shortcut command for a long pathname for example, if i needed to...