Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 10
Server version: 10.0.17-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use test
Database changed
MariaDB [test]> show create table test\G
*************************** 1. row ***************************
       Table: test
Create Table: CREATE TABLE `test` (
  `col1` int(10) DEFAULT NULL,
  `col2` varchar(255) DEFAULT NULL,
  `col3` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAM
P
) ENGINE=CONNECT DEFAULT CHARSET=latin1 CONNECTION='DSN=CCRDB01-WH_FDB_1;uid=username;pwd=password' `TABLE_TYPE`='ODBC' `BLOCK_SIZE`=10
1 row in set (0.00 sec)

MariaDB [test]> delimiter ;;
MariaDB [test]> CREATE PROCEDURE `connect_if_exists_test`()
    ->  LANGUAGE SQL
    ->  NOT DETERMINISTIC
    ->  CONTAINS SQL
    ->  SQL SECURITY DEFINER
    ->  COMMENT ''
    -> BEGIN
    ->
    -> if (exists(select * from test)) then
    ->  select 1;
    -> else
    ->  select 0;
    -> end if;
    -> END;;
Query OK, 0 rows affected (0.01 sec)

MariaDB [test]>
MariaDB [test]> delimiter ;
MariaDB [test]> call connect_if_exists_test()\G
ERROR 1148 (42000): CONNECT Unsupported command
MariaDB [test]>