Recent content by markmulligansr

If anyone has the time to read this problem statement and can tell me how to use Perl to read the input records, write them as is and then read those to then format the output as shown below, I would really appreciate it. We have a lot of business users spending a lot of time trying to solve...

Thank you. This is exactly what I needed.

This is a Perl how do I do this question. 10622 2014-04-18 04:14:18.924064 EDT 10622 DEBUG: QUERY: insert into "EDWP06".ETL_STG.RQ_DRVR_UPDT next_data... here is my input data. It is fixed positions up to the "EDWP06".ETL_STG.RQ_DRVR_UPDT how do I extract the EDWP06, ETL_STG and RQ_DRVR_UPDT...

The other database is DB2 LUW so the ORACLE information is not relevant at this time but we do have ORACLE databases and at some point in the future may need to load information from these sources so this is very helpful information that I may well need in the future. Thank you so much. Yes...

Netezza does not support access to remote databases like ORACLE and other databases do. It is not as sophisticated as a lot of the other relational databases in this respect. I am trying to find a way to migrate data to it without having to land the data in files. We do not have the storage...

For example, is there a way I push the results from a script run on a local server into a script on a remote server that does something with the results without having to land the results on disk? Or is there a way I can pull the results from a script/command run on a remote server into a...

How do I write a KSH script to run programs in parallel? I'd like to pass the script a variable with the number of programs I'd like to run in parallel. If for example, I have an input file with 100 table names and if I want to run a runstats program for 10 tables at a time in parallel with no...

I am working with ksh

I remember that I can spawn another script is back ground by using the . backgroundscript & option and then the wait statement. Is there a way I can spawn multiple background scripts and then wait for all of them to finish and be able to check the return code from each? If so, I would...

Thanks. I found this code and it works for the end of year and leap year scenarios. function pn_month { typeset ym=$1 pn=$2 (( m = ym % 100 )) (( y = ym / 100 )) while (( pn != 0 )); do if (( pn > 0 )); then if (( m == 12 )) then (( m = 1 )); (( y = y + 1 )) else (( m = m + 1 ))...

How do I get the end of next month's date and deal with end of year and February during leap years? Is there a UNIX command that returns this or do I have to develop some sort of script logic using the date command. The requirements I have are, given today's date, what is the end of next...

I have this statement that uses sed echo $tabname | sed 's/\_NEW/\_"${Month}"\_${Day}\_${Year}\_OLD/g' | read oldtabnamesuffix The value of oldtabnamesuffix is tablename_${Month}_${Day}_${Year}_OLD after this statement executes. Hoe do I get sed to use the variable values? For example, I'd...

Sam's code worked great. Someone also told me about changing ksh to ksh93 and the simple divide I had in my code came up with the correct answer too. Thanks Sam

How do I put the first two numbers in numeric variables and divide the first by the second to get the third number displayed below in a KORN shell script? 2.322359 5.864941 0.395973 ( 2.322359 / 5.864941 ) = 0.395973 Thanks, Mark

Thank you very much. This got me on track. I am using KORN shell scripts and the information is on one line. It was in a file that I had read into a variable called $line and so I was able to use this statement to accomplish what was needed. set -A diskarray $(echo ${line} | sed 's/.*Busy...