Run MYSQLDUMP with QP2SHELL

I've never used QP2SHELL. I'm able to successfully backup my MYSQL database
using QP2TERM with this command:



mysqldump -u root SUGARCRM > /usr/local/mysql/bin/backup_SUGARCRM.sql



I'm trying to get this to run with QP2SHELL. I read that I need to
terminate my parms with *Null, I found examples on the IBM website. My
CLP looks like this:



PGM

DCL VAR(&CMD) TYPE(*CHAR) LEN(80) +

VALUE('/usr/local/mysql/bin/mysqldump')

DCL VAR(&PARM1) TYPE(*CHAR) LEN(65) +

VALUE('SUGARCRM')

DCL VAR(&PARM2) TYPE(*CHAR) LEN(65) +

VALUE('-user root')

DCL VAR(&PARM3) TYPE(*CHAR) LEN(65) +

VALUE(' > +

/usr/local/mysql/bin/backup_SUGARCRM.sql')

DCL VAR(&NULL) TYPE(*CHAR) LEN(1) VALUE(X'00')



CHGVAR VAR(&CMD) VALUE(&CMD *TCAT &NULL)

CHGVAR VAR(&PARM1) VALUE(&PARM1 *TCAT &NULL)

CHGVAR VAR(&PARM2) VALUE(&PARM2 *TCAT &NULL)

CHGVAR VAR(&PARM3) VALUE(&PARM2 *TCAT &NULL)

CALL PGM(QP2SHELL) PARM(&CMD &PARM1 &PARM2 &PARM3)



ENDPROGRAM: ENDPGM



My results are as follows. I see that I'm not providing the user parameter
properly. How can I run this? For testing I have no password but I will
need to provide that parm as well.



TIA, Jack





-- Host: localhost Database: SUGARCRM


-- ------------------------------------------------------


-- Server version 5.1.50





/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;


/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;


/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;


/*!40101 SET NAMES utf8 */;


/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;


/*!40103 SET TIME_ZONE='+00:00' */;


/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;


/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
FOREIGN_KEY_CHECKS

=0 */;


/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


mysqldump: Got error: 1044: Access denied for user ''@'localhost' to
database

'sugarcrm' when selecting the database

Press ENTER to end terminal session.