MQSeries.net :: View topic - SOLVED: Syntax error on MB Help section example for CAST

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » SOLVED: Syntax error on MB Help section example for CAST

SOLVED: Syntax error on MB Help section example for CAST

« View previous topic :: View next topic »

Author

Message

Rodeo

Posted: Mon Jun 25, 2007 6:18 am Post subject: SOLVED: Syntax error on MB Help section example for CAST

Apprentice

Joined: 11 Apr 2007
Posts: 30

I was trying to use the following ESQL declaration with variable initialization in my code and I got a syntax error. This is an example
given in CAST function section in Message broker help.

DECLARE now CHARACTER = CAST(CURRENT_TIMESTAMP AS CHARACTER FORMAT 'yyyyMMdd-HHmmss');

Any suggestions why this could be happening?

Last edited by Rodeo on Mon Jun 25, 2007 11:31 am; edited 1 time in total

Bill.Matthews

Posted: Mon Jun 25, 2007 6:57 am Post subject:

Master

Joined: 23 Sep 2003
Posts: 232
Location: IBM (Retired)

Start by removing the equal sigh between CHARACTER and CAST
and try again.

The Declare verb does not use an assignment.
_________________
Bill Matthews

Rodeo

Posted: Mon Jun 25, 2007 11:31 am Post subject:

Apprentice

Joined: 11 Apr 2007
Posts: 30

Thanks. That worked

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » SOLVED: Syntax error on MB Help section example for CAST

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP