Batch File Output Header Removal

Discussion forum for all Windows batch related topics.

Moderator: DosItHelp

Post Reply
Message
Author
vigneshwaranb
Posts: 2
Joined: 05 Apr 2009 06:19

Batch File Output Header Removal

#1 Post by vigneshwaranb » 13 Apr 2009 07:45

Dear All,
Greetings..
I converted the sql input as text file output ....

my output shows header also ... but i need to remove header ...

can anyone help me out in this issue?

my batch file is databse is : Sybase-- views :

echo select * from crystal..1_LOANS > ..\SQL\1_LOANS.SQL
echo GO >> ..\SQL\1_LOANS.SQL

isql -Usa -Psybase -SPHXTEST -i..\SQL\1_LOANS.SQL -o..\OUT\1_out_Loans.txt
DEL ..\SQL\1_LOANS.SQL
REM ************new code to generate SQL file************

for /f "usebackq tokens=3 delims==~) " %%i in (`findstr "return
status" ..\OUT\1_out_Loans.txt`) do @if %%i LSS 0 exit

findstr /C:"return status" /I ..\OUT\1_out_Loans.txt
if %errorlevel% NEQ 0 exit

and also i need to store the output filename with date/timestamp....


Thanks in Advance....

Post Reply