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....
Batch File Output Header Removal
Moderator: DosItHelp