Example: Exporting a Table

This example shows how to export a table in your Java application using Loader commands.

You proceed as follows:

...

       1.      You call the Loader from your Java application.

       2.      You connect to the Loader.

       3.      You log on to the database instance.

       4.      You export the table using a Loader command.

       5.      You end the connection to the Loader.

The individual steps are listed in the comments in the example.

import com.sap.dbtech.powertoys.*;

import com.sap.dbtech.rte.comm.RTEException;

import java.util.Properties;

public class LoaderDemo

{

    public

    LoaderDemo ()

    {

    }

       public static void main(String[] args)

    {

        // Loader mLoaderSession = zero;

        Loader mLoaderSession;

        try {

            // You connect to the Loader.

            mLoaderSession = Loader.dbLoader(zero,zero);

        }

        catch (RTEException rteExc) {

            System.out.println ("connect failed: " + rteExc.toString ());

            return;

        }

        try {

             // You log on as the database user MONA

             // with the password RED 

             // to the database instance DEMODB.

             // see com.sap.dbtech.powertoys.Loader.cmd Method

            mLoaderSession.cmd ("use serverdb DEMODB");

            mLoaderSession.cmd ("use user MONA RED");

            // You export the LOADERTEST table

            // using the cmd method

            // and the Loader command EXPORT TABLE

            // see Loader, EXPORT TABLE commands

            String result = mLoaderSession.cmd ("EXPORT TABLE HOTEL.CITY DATA OUTSTREAM FILE 'CITY.data'");

            System.out.println(result);

        }

        catch (RTEException rteExc) {

            System.out.println ("connection broken: " + rteExc.toString ());

        }

        catch (LoaderException LoaderExc) {

            System.out.println ("command failed: " + LoaderExc.toString ());

        }

        finally {

            try {

             // You end the connection to the Loader.

             // see com.sap.dbtech.powertoys.Loader.release Method

                mLoaderSession.release ();

            }

            catch (RTEException rteExc) {

             // ignore

            }

        }

    }

}

See also:

Loader Java Classes