I have requirement to create an excel file header and then append table data to that excel file. However, I get an error even trying to create the header excel file. I will appreciate any help identifying the problem. Here is the stored procedure:
|
Note, you cannot use the DBISQL OUTPUT command within a stored procedure, as is discussed in this forum in several FAQs (say, here) and also in the online help. You can use the UNLOAD statement but that does not directly support the Excel format. Some hints are available here: Or you might use xp_cmdshell to start DBISQL with an OUTPUT TO command from within your procedure. 1
Thank you. I changed the code to use the UNLOAD command as given in examples and it is working. Thank you.
(27 Jun '18, 15:12)
musicsw
|