>>>>Hi everybody,
>>>>
>>>>I have this problem, which I'm seeking the best solution. I want to extract ~2mln. records from database into SDF file. I can do it in one SQL, but it produces first line with Field names. I don't want them. What's the best way to get rid on field names? Do I need to go SQL into table then copy to file?
>>>
>>>What's wrong with copy to .. SDF ?
>>>Cetin
>>
>>Oops again, would not work. In our database we have address field and we don't have busres field. Customer wants StNum, Street fields and BusRes field.
>>So, I have to create SQL like this:
>>
>>select lastname, firstname, padr(substr(Address,1,at(' ',Address)),6) as StNum, ;
>>padr(ltrim(substr(Address,at(' ',Address))),25) as Street, State, ;
>>Zip, Phone, 'R' as BusRes
>>
>>So I think I have to use two steps here. It would be easier, though job would run quite long... It's one in year job, so that's not a big deal.
>>
>>Thanks again.
>
>Then 'set heading off'
>Cetin
I guess I never remember this one. Great, this would work.
If it's not broken, fix it until it is.
My Blog