Search Results

I have the following two Korn shell scripts:

SHELL1.ksh
#!/usr/bin/ksh
nohup sas /abc/123/sasprogram1.sas &

SHELL2.ksh
#!/usr/bin/ksh
./SHELL1.ksh
wait
nohup sas /abc/123/sasprogram2.sas...

I have two different cron jobs that run on the same days. The jobs are 7 hours apart. Both jobs are set to send notification emails when they start running.

Both jobs always run successfully,...

I have two different cron jobs that run on the same days. The jobs are 7 hours apart. Both jobs are set to send notification emails when they start running.

Both jobs always run successfully,...

What is the syntax for writing comment code in Korn shell scripts?

When I run the script below I get a message stating that Thu=Mon is not found. Even when I change my if statement to if $day=Thu, I get a message stating Thu=Thu is not found. How can I fix this...

I just tried changing the format of DATE_STAMP to +%m/%d/%Y to match the format of the values of PROCESS_DT (04/22/2008), but still got the same error as listed earlier.

Sorry, I forgot to change the date format before running again. It worked, but returned a zero value for count. I'm trying to figure out why that happened when PROCESS_DT in the db2 table is equal...

Franklin52,

After trying your suggestion, I got the following error:

SQL0183N A datetime arithmetic operation or a datetime scalar function has a result that is not within the valid range of...

I am running the following Korn shell script:

#!/usr/bin/ksh
num_records=`sas "select count(*) from /users/abc/123/sasdata.sas7bdat"`
echo "$num_records"

The script keeps returning an invalid...

I now know how to find yesterdays date, however, I get an error message stating that the operands (PROCESS_DT and DATE_STAMP) are not compatible. PROCESS_DT is a DB2 date time variable with a DATE9...

I am currently running the following Korn shell script which works fine:

#!/usr/bin/ksh
count=`db2 -x "select count(*) from schema.tablename"`
echo "count"

I would like to add a "where"...

I'm declaring a variable within a Korn shell to represent the total number of records in a SAS dataset and could use a little help with the syntax. This is what I have thus far:

#!/usr/bin/ksh...

I may have overlooked, but I could not find any examples in the other forums as to how to email the value of a variable created in a Korn shell via mailx to a specific email account. In my case, I...

Thanks, pupp! Your solution worked!

My script almost works. Now, I'm not getting any errors, but the values for RecCount and RecCount2 are not printing. I tried running the following commands outside of the shell and got results of...

After adding fi at the end, I now get the following error:

0403-21 A ] character is missing.

After all the suggestions, my Korn shell script now looks like the following:

!#/usr/bin/ksh
RecCount=`db2 -x "select count(*) from schema.table"`
RecCount2=`db2 -x "select count(*) from...

Does "==" mean "not equal"?

My two sql statements give me results of:3500000 and 5578000 respectively.

I just ran my script through od -c shell_script, and did not see any control characters.

Making the change you suggested resulted in the following error:

./test.ksh[6]: 0403-057 syntax error at line 6: '-a' is not expected.

My Korn shell script below is giving me the following error: ./test.ksh[6]: 0403-057 syntax error at line 7 : 'then' is not matched.

Can anyone provide a quick solution as to why the error is...