Using df -g command with awk to get SQL statement

UNIX for Beginners Q & A
1

Hi Gurus... good day;

currently I trying to run the df -g command with awk to get to convert in SQL statement, but I have some errors;

df -g | awk '{print "This is the FileSystem: " $NF, " This is LV: "$1, "This is SIZE: "$2, "This is FREE: " $3, "This is the USED% "$4}'

This on AIX operative system;

But I need replace the words This is the... , but I dont know how to...��

Some can help me..

best regards;

Wilmer

2

Once again - open your own thread AND don't double-post!

3

I fail to understand your problem. If you wrote the code:

df -g | awk '{print "This is the FileSystem: " $NF, " This is LV: "$1, "This is SIZE: "$2, "This is FREE: " $3, "This is the USED% "$4}'

surely you should be able to figure out that you could instead write the code:

df -g | awk '{print "Some Other Text FileSystem: " $NF, " This is LV: "$1, "This is SIZE: "$2, "This is FREE: " $3, "Some Other Text USED% "$4}'

to replace the words This is the with whatever other text you prefer. And, I fail to see what any text you might put in those two places in your awk script has to do with SQL.

Please clearly explain what you are really trying to do.

4

I think it would help us to help you if:

1. you told us what you want to accomplish, the goal you want to achieve.
2. you do not tell us how you want to do it.  Forget that part completely. It is really confusing and possibly wrong.