String sql;



            sql="select ckod.fkode_ac as CustID, ckod.fproduk as Product, ckod.fsls as Sales, ifnull(targtoko.qty,0) as Qty, ifnull(targtoko.amt,0) as Amt from \"cpu-sls/cpu-mf/cuskod.cpu\" as ckod LEFT JOIN \"cpu-sls/targ_02.cpu\" as targtoko on targtoko.fkode_prd = ckod.fproduk and targtoko.fkode_sls = ckod.fsls and targtoko.fkode_ac = ckod.fkode_ac where ckod.fsls =? and ckod.fproduk =? ";



            pstmt = con.prepareStatement(sql);



            ParameterMetaData pmd=pstmt.getParameterMetaData();

            for (int j = 1; j <= pmd.getParameterCount(); j++){

                System.out.println(pmd.getParameterTypeName(j)

                                   + "  "

                                   +pmd.getParameterClassName(j)

                                   );

            }



            resultSetMetaData = pstmt.getMetaData();

            iNumCols = resultSetMetaData.getColumnCount();

            for (int j = 1; j <= iNumCols; j++)

                System.out.print(resultSetMetaData.getColumnLabel(j) + "  ");



            System.out.println();



            pstmt.setObject(1,"DK1");

            pstmt.setObject(2,"01-OS");

//            pstmt.setString(1,"DK1");

//            pstmt.setString(2,"01-OS");



            rs = pstmt.executeQuery();



            int count=0;

            while (rs.next()) {

                for (int j = 1; j <= iNumCols; j++) {

                    colval = rs.getObject(j) + "";

                    System.out.print(colval + "  ");

                }

                System.out.println();

                count++;

            }

            System.out.print("count: "+count);



            rs.close();



            pstmt.close();