Search Results

Thanks, the script has to scan thousand of DDLs, and we cannot warranty they are defined with same format. That is why I stay away from searching for , or some key word :-(
I did change the code a...

Hi- I have issue with the code to get the input file reformat
--Goal is reformat and print out only column name one per line, leading space or trailing space will be removed...

--TABLE1.DDL as...

What is the best way to check for return-code for each CallWorkFLow routine and abort the main job if error returns from any of the call?

It works now by move the & after the backtick. it needs it bcuz the command has more than 1 parm. the sleep ### is only the sample.
`CallWorkFlow wf_one > logs 2>&1` &
`CallWorkFlow wf_two > logs...

echo "=========>> EDW_Daily_Sch_DS_step7 Group-1 Job Started at `date` "
`sleep 10 &`
`sleep 30 &`
wait
echo "=========>> EDW_Daily_Sch_DS_step7 Group-1 Has Completed at `date` "
echo...

I have the shell script to call a Perl routine and pass the Informatica WorkFlow name to it. Jobs in each group executes in background do not seem to wait at all. How do I make it to WAIT for the...

thanks, eliminate sub-string with matching pattern will only work when the number of characters are not change. I end up using multiple sed to remove know keyword after the classes since there are...

Thanks, It works well with scenarios in the sample. Now, some files have name without trailing numbers. that throw the matching partern off.

ex: DEPT_MUSICLAB_D_20110327.DAT

so i have to do it...

I have these files in a directory. It may have more class than the sample below:
DEPT_CHEM101LEC_D_20110301.DAT
DEPT_CHEM101LAB_D_20110301.DAT
DEPT_BIO105LEC_D_20110325.DAT...

ex: I have list of files in a folder.
abc_def_geh_.txt
abc_.txt
abc_def_geh_12345_.txt
ab134c_d345345ef_444geh_12345_.txt

i need to rename all files to get rid of the _ before .txt

result...

IT's SunOS. Today i found out the nawk also gave bad result. many records with correct counts of 291. and the rejected file showed that they had only 198 semi-colon in them. those rejected records...

I tried this command below since the record is 4000 byte and has 290 ; as delimiters. i need to filter out bad records where the delimiter counts do not match.

awk -F \;...

I’m new to Linux script and not sure how to filter out bad records from huge flat files (over 1.3GB each). The delimiter is a semi colon “;”

Here is the sample of 5 lines in the file:
...