UNIX for Dummies Questions & Answers

Hi All,

Need an urgent solution to an issue . We have created a ksh file or shell script which generates 1 DAT file. the DAT file contains extract of a select statement .

Now the issue is , when we are executing the ksh file , the output is coimng with page breaks and line breaks .

We have tried modified the pagesize and linesize . but the issue is still there .

Please Help !!

It is probably the SELECT statement that is generating the page breaks and line feeds - not the shell script.

However, without seeing your shell script, we really cannot tell.

Thanks for the quick reply Sir . will post the script shortly .

Dare I suggest that this might be an SQL select statement and not a shell select statement? They are very different beasts.

We're still awaiting your code or a minimal script that can replicate your problem.



Robin

Hi All,

Thanks all for your interest in this post .

The issue was after a certain line of output we used to get a blank space .

like

Code:

1234^8976^8979
34327^4545^7676

4587^4589^4578^
656^676^8963^6354^3258


5455^8756^5698^5214^

i tried using pagesize 0 (for incraesing the page size to infinite )
and newpage none

and it resolved the issue .

Thanks