Hello Group,
I've to get data from some tables with similar structure. So I decided
to write an
Unix shellscript to mask SQL staments (like: SELECT G.$
{DealClass}_Id... which will expanded to SELECT G.CarDeals_Id )
and then pass them to isql via
isql -w5000 -s";" <<EOF | grep -iv "\-\-\-" | grep -iv "row" | grep -v
"^$" | sed 's/^;//g' >> ${RptSQLResult_Deals}
Now the problem is that fields with Comments exist. This fields can
have a ";" in the field content.
Sample outputfile generated via isql:
1234;FORD;Mustang D12A;120000;USD;Cool car; call Mr. Jon Doe;<other
fields...>
This would result into an error while im****ting by external app which
interpretes ";" in the comment line as delimiter.
By contrast Re****tBatch would generate this above as:
Sample outputfile generated via Re****tBatch:
1234;"FORD";"Mustang D12A";120000;"USD";"Cool car; call Mr. Jon
Doe";<other fields...>
which is correct / requested.
So the question is, exists command line parameters to isql to say that
String/Varchar fields have to be quoted with "" or is Re****tBatch my
only possibility (which causes into fully change my application).
Thanks in Advance
Celal Dikici
