Blog directory

BSFN to Get Install Path (for Import/Export)

Most File based transactions or JDE Applications, need to have access to the Import and Export directory of the Install Path. For most Live installations, the workstations will be on Windows OS, and the servers may be either AS/400 or Linux/UNIX environments. The path’s to the environment install directory will be entirely different in each case.

Typically for an JDE EnterpriseOne Windows based Local installation will have path – “C:\Exxx\DVxxx\” or “C:\Bxxxx\PDxxxx\”,
For UNIX/Linux it may be – “/usg/filespace/exxx/dvxxx/” etc.

If you notice the above, not only the file path is different, but also the directory separator. The following C BSFN helps get the Install Path, the Separator, if its Client/Server.

I’m not sure if a similar BSFN exists in the latest versions of JDE, one thing I’m sure Oneworld XE does not have it, and that’s why the Business Function was created.

The “BuildPathFromEnvDataX” API is used to retrieve the complete install path. You can get the Continue reading BSFN to Get Install Path (for Import/Export)

Using BSFN to Delete All Records from a Table

BSFN – B8000002 (Delete All Rows From Table) does a delete * from tablename. The B8000007 and the B8000002 business functions must be used together to delete all the rows in a table. They will not delete the table specifications or the physical table in the database. B8000007 must be called first to get the environment handle, with the handle only then B8000002 is able to delete all records from the specified table. B8000007 must be called again to free the handle. . . . → Read More: Using BSFN to Delete All Records from a Table