Search Results

I believe IBM connect direct uses a proprietary protocol which is separate to and incompatible with SFTP.


SFTP runs over SSH and is used on thousands of systems around the world that don't have...

awk has automatic type conversion.
The ! operator is a boolean that is rather a number (being 1 or 0) than a string, so there is a decent hint to treat the variable as a number.
In border cases...

As I said - usage alone, be it for assignment or reference in an index, takes the value as is. Only evaluation, e.g. for a boolean expression or a numerical computation, converts the string to a...

Comparing with a string should work as well.
echo "abc|0e123456789|xyz|1234|kdkd|dfs" | awk -F "|" '{ if ($2=="") { print $2 " is empty or NULL " } else { print $2 " is not empty "}}'

Try a string conversion:
echo "abc|0e123456789|xyz|1234|kdkd|dfs" | awk -F "|" '{ if ( ! ($2 "")) { print $2 " is empty or NULL " } else { print $2 " is not empty "}}'
0e123456789 is not empty
...

Why are you using
echo `cat output.html`
rather than
cat output.html
The first leaves all kinds of characters open to interpretation by the shell ..

How does that work with sendmail? What do...

I think i got it, but i ask thread-o/p to confirm. The presentation of his problem was perhaps a bit off from optimal:

There is ONE file with some database statements:

CREATE OR REPLACE VIEW...

I agree wholeheartedly with the idea of using a single invocation of awk instead of one invocation of sed for each line in a file. But, we don't have enough data to properly process the needed...

Why don't you read file1 and spool_file just once each instead of file1 once per line in spool_file?
awk 'NR==FNR {T[$1]; next} {for (t in T) if ($0 ~ t) $0 = "--" $0} 1' file2 file1
CREATE OR...

Hello chill3chee,

I am still not clear about your requirements, let's say variable line=TAB1_COL1, then following may help you in same.
Similarly you could use this following in your whileloop.
...

Try running without silent mode:-
sqlplus -s username/password@servername <<EOF

to
sqlplus username/password@servername <<EOF

{
sqlplus -s username/password@servername <<EOF
...
EOF
} > ${drctry}/${v_timestamp}_unix_sql_log.txt

That was a hell of a specification to understand - not sure I did to its entirety. Anyway, try
awk -F "@" '
BEGIN {FMT1 = "%s%s\tSUM(CASE WHEN T1.%s=T2.%s THEN 1 ELSE 0 END) %s_%s"
FMT2...

An alternative in Perl:
perl -ple 'BEGIN{$\=$/=";\n"} s/\n/ /g' chill3chee.file

You might - especially as a beginner - want to make life easier for you and write real sed programs instead of one-liners only experts can decipher. It is like starting to learn the double toe-loop...

Your sed needs to substitute all \n where the preceding characters is not a ;
sed -e ':a' -e 'N' -e '$!ba' -e 's/\([^;]\)\n/\1/g' fileThe file must fit into memory.
The following does an early...

It's appending N ext lines and branching back to label L until it finds the ; , then branches to X , replaces \n with spaces and prints the resulting line.

Why do you insist on sed and aren't happy with the awk solution?

Try
sed ':L; /;$/bX; N; bL; :X; s/\n/ /g' file
Table1@Table2@SELECT COL1, COL2,COL3, COL4,COL5 FROM TABLE1 INNER JOIN TABLE2 ON...

There shouldn't be any NR == FNR nor NR != FNR; I simply put in FNR == 1 to exclude the header line(s). The scriptlet should work on any number of files supplied to it as one single stream of data...

Make (and test) the combination of $1, $2, and $3 unique:
awk '
FNR == 1 {next
}
!T[$1,$2,$3]++ {v_array[$1 OFS $2]=v_array[$1 OFS $2] ? v_array[$1 OFS $2] "," $3 : $3
...

Interesting. I had a look at this and it appears this behavior is with any character, not just "@", but also for "*", "a" or "b".

I only saw this with AIX and HPUX awk..

A possible explanation...

You are right, some nawk derivates require
awk 'BEGIN {FS="[@]"; RS=";"} {print $3}' join_conditions.txtThe RS=";" works multi-line, but the FS="@" treats line feeds as a field delimiter.
You see...

Interesting, nawk variants treat an FS="@" in a way that line feeds are counted aw well.
Work-around:
awk -F"[@]" 'BEGIN {RS=";"} {print $3}' < join_conditions.txt
or
awk 'BEGIN {FS="\@"; RS=";"}...

This may point you in a direction:awk '
$4 == "DIRECT" {IX = $1 OFS $5
if ($3 $7 ~ /DATE.*CHAR\(6/)
str="SUM(CASE WHEN...

Try:
awk '
NR == FNR {
A[$1]
next
}
{
for ( k in A )
print "create or replace view vw_tbl_" k "...