Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
 |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| result of ftp | MeeraNair | UNIX for Dummies Questions & Answers | 6 | 05-29-2008 09:27 AM |
| display the result of wc -l with words before and after the result | melanie_pfefer | UNIX for Dummies Questions & Answers | 3 | 04-30-2008 07:33 AM |
| Outputting formatted Result log file from old 30000 lines result log<help required> | vikas.iet | Shell Programming and Scripting | 5 | 12-02-2007 10:43 PM |
| select() and read() | jnuno | High Level Programming | 2 | 11-19-2002 02:03 PM |
| Multiple fds in select() | amatsaka | High Level Programming | 1 | 11-13-2002 10:10 AM |
 |
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
08-28-2007
|
||||
|
||||
|
formatting the sql select result
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 |
|
08-28-2007
|
||||
|
||||
|
Please post the output you are getting
|
|
08-28-2007
|
||||
|
||||
|
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 |
| Sponsored Links | ||
|
|
Linear Mode
