formatting the sql select result

Shell Programming and Scripting
1

Hi,
I have about 12 columns and 15 rows to be retrived from sybase isql command through unix. But when i output the sql into a file and see it, the formatting is going for a toss. can someone please suggest how can i get the result correctly in the output file ?

Thanks,
Sateesh

2

Please post the output you are getting

3

here is the result.

CheckId Description Frequency AU SG AP BEI BKK HK KUL JKT MnB SeB TpB
----------- -------------------------------------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------
1 Check whether the batch has finished or not Daily 9:30 AM (AUST) OK OK OK NA NA NA NA NA NA NA NA
2 Check the status of the jobs completed and estimat Daily 9:30 AM (AUST) NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
3 Check in the report folder of each location to see Daily 9:30 AM (AUST) OK OK NA OK OK OK OK Not Completed Yet Holiday OK OK
4 Check whether the reports job has completed and re Daily 9:30 AM (AUST) NA Errors Found OK NA NA NA NA NA NA NA NA
5 Check the Marks feed - whether there are obvious e Daily 9:30 AM (AUST) NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
6 Check the cat* files for SG and AP Daily 9:30 AM (AUST) NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
7 Check the batchDates table to ensure correct dates Daily 9:30 AM (AUST) OK OK NA OK OK OK OK OK OK OK OK
8 Check for PNL detail table Daily 9:30 AM (AUST) OK OK NA OK OK OK OK OK Holiday OK OK
9 Batch click off time Daily 9:30 AM (AUST) 17:38 20:28 20:36 NA NA NA NA NA NA NA NA
10 Marks to RiskMaster Timing Daily 9:30 AM (AUST) NULL NULL NA 21:55 21:05 22:13 22:15 20:45 23:22 22:35
11 Check Transactor feed Timing Daily 9:30 AM (AUST) OK OK OK NA NA NA NA NA NA NA NA
12 Batch completion time Daily 9:30 AM (AUST) 02:37 06:06 06:06 NA NA NA NA NA NA NA NA
13 Report sftp to ROD Daily 9:30 AM (AUST) NULL NULL NA 06:43 05:52 06:44 06:44 05:52 06:45 07:37 06:46