sql with AWK

[samtg]

Hi
Is there anyway to use SQL ("select&quot on a awk program?
thanks.

 

[vgersh99]

can you be just a little bit more specific,pls?!

thanks

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[samtg]

Hi
i have a file and i want to do some controls on it, for example :

file whith a pipe delimiter :

2002|x|125464|000012356984|1000.00|500.00|500.00|
2002|y|0|125489632158|5000.00|1000.00|4000.00|
2002|z|126589|12548|2000.00|500.00|1500.00|
2002|a|256894|000000215698|1000.00|200.00|800.00|
2002|y|125698|000012349658|200.00|10.00|190.00|

i have a table on an informix database that contains n columns such as
2002|x|125464|000012356984|1000.00|500.00|500.00|
2002|y|125698|000012349658|200.00|10.00|190.00|

i want to verify if column1 & column2 & column3 on file, if they exist on a table of my database, for example :
2002 & x & 125464 exist
2002 & y & 125698 exist
2002 & z & 126589 not exist

thanks a lot.

 

[PHV]

Unload your informix table with dbaccess in, say, table.unl
Then try something like this:

awk -F'|' '
BEGIN{while((getline <&quot;table.unl&quot;)>0)T[$1&quot;,&quot;$2&quot;,&quot;$3]++}
T[$1&quot;,&quot;$2&quot;,&quot;$3]>0{print >&quot;ok.unl&quot;}
{print >&quot;bad.unl&quot;}
' /path/to/file2test.unl

Hope This Help
PH.