Use this procedure/function to streamline the use of DAL with ODBC or JDBC and memory tables by creating DFD files and using only memory tables. You can use the DALRUN program to create the DFD files based on a DAL script since it is a one-time operation. You only need to run the script again after table layout changes.
DBUnloadDFD (TableName, DFDName)
|
Parameter |
Description |
|
TableName |
Enter the name of the table opened with DBOpen procedure. |
|
DFDName |
Enter the name of the output file. The system overwrite this file if it exists. |
Keep in mind...
The file name you pass to this procedure as the output name of the DFD file must be appropriate for the platform. For instance, AAA.DFD will not work for z/OS.
Here is an example of how you could use this procedure in a DAL script:
#rc = DBOpen("MYTABLE","ODBC"); or #rc = DBOpen("MYTABLE","JDBC");
if #rc = 0
* display error
end
#rc = DBUnloadDFD("MYTABLE","aaa.dfd");
if #rc = 0
* display error
end
This script unloads a DFD file named AAA.DFD which describes the table named MYTABLE in the current directory.
© Copyright 2017, Oracle and/or its affiliates. All rights reserved. Legal Notices