|
midrange.com
>> Alan,
>> Why not create procedures instead of functions for the OPENIFS, CLOSEIFS, &
>> WRITEIFS headers?. Then you could use:
>> CALL OPENIFSFORNEW('/home/yourdirectory/transmit.txt')
>> CALL WRITEIFSHEADER('File info')
<< CALL WRITEIFSHEADER('field header record')
.>>..dummy update statement here to convert the detail data
>> CALL CLOSEIFS()
>> Paul
Not clear to me how this would help. Where would the data come from? A stored
procedure is just a program. If you had 1.5 million records, you would have to
run the call statement 1.5 million times! You would have to have something like
he currently does to get the data. Using the UDF and SQL statements means you
can retrieve the data and write it all in one statement. To write that 1.5
million records would take exactly one SQL statement!
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
