SJohnson
asked on
Exporting to an SDF File
Hi,
I'm just wondering if anyone knows how I can export a table to an SDF file? SDF = System Data Format.
One of our clients requires an application which can convert their AS/400 data to an SDF file (not sure why, mine is not to know but to do).
Any info at all would be appreciated!
Thanks,
Stuart.
I'm just wondering if anyone knows how I can export a table to an SDF file? SDF = System Data Format.
One of our clients requires an application which can convert their AS/400 data to an SDF file (not sure why, mine is not to know but to do).
Any info at all would be appreciated!
Thanks,
Stuart.
ASKER
Hi again, Hamlet!
Well, you've stumped me on this. I'm pretty sure all we are doing is creating a file containing all the data from one library on the AS/400. I dont think it's going to be a differential file.
I've been hunting around on the net since I posted this question and found a couple of components which claim they can make SDF's, but neither of the do. I've actually started writing my own, and so far it seems to be working OK. I just dont know if I'm going to have time to finish it.
So, if you know of any components or code I could use, please let me know!
All the best,
Stuart.
Well, you've stumped me on this. I'm pretty sure all we are doing is creating a file containing all the data from one library on the AS/400. I dont think it's going to be a differential file.
I've been hunting around on the net since I posted this question and found a couple of components which claim they can make SDF's, but neither of the do. I've actually started writing my own, and so far it seems to be working OK. I just dont know if I'm going to have time to finish it.
So, if you know of any components or code I could use, please let me know!
All the best,
Stuart.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
oops, after the
end; {while}
add:
FileClose(fOut);
HTH
Chris
end; {while}
add:
FileClose(fOut);
HTH
Chris
oops again, meant CloseFile(fOut);
ASKER
Hi Chris,
Sorry it's taken so long to get back to you on this. EE hasn't been working all that well of late.
Your solution is perfect! Thanks very much.
Stu.
Sorry it's taken so long to get back to you on this. EE hasn't been working all that well of late.
Your solution is perfect! Thanks very much.
Stu.
I think SDF could be a couple of things, so it depends which one you mean?
One type of SDF file is simply an ascii text file with fixed width fields. Each record is followed by a CrLf sequence. This format is commonly used by dBase.
This is pretty easy to produce, but you do of course need to know how long to make each field.
Another SDF file is ascii text file which represents CHANGES to data. It can be used to add, edit and delete records. This format is much more complex, so I hope this is not what you are after.