Guys

we all know what command 'COLUMNS=2047 /usr/bin/ps –eo pid,ppid,uid,user,args' does.It prints 5-column output for the running processes on a AIX box.

Here is simple thing i need:
I need to insert this tabular data in a db2 table.

How do i need?

I have created table with these five options of 'ps -eo' as five colmuns.I have a tool which generates CSV files based on my command/script logic and i use this CSV to load data into table.

Where am i stuck?

I am not sure of how to get this o/p into CSV.
I have created five namespaces to capture each of these five columns and i need to write a piece of code to capture data row by row.

e.g

PID PPID UID USER COMMAND
139412 118932 0 root /usr/sbin/inetd

Complexities:
1.I can not throw this o/p into CSV using a static file.Everything has to be in shell variables.I need to echo values using whatever filters/pattern searches.

2.Every row needs to be captured uniquely.

In above example,i first need to capture '139412' uniquely and get the corresponding row for it and then using 'awk' i can get rest 4 columns.

I have tried to explain as much as possible.Let me know if its inconsistent.

I need advice/help on this.

Regards
Abhi