Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Stored Procedure is not accepting

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
chrakesh

New User


Joined: 03 May 2010
Posts: 16
Location: india

PostPosted: Tue Jun 08, 2010 6:05 pm    Post subject: Stored Procedure is not accepting
Reply with quote

Hi Guys,

Can anyone please clarify this , Stored Procedure is not accepting '+' or '-' plus or minus symbols, for the following query.

Can anyone please provide me any alternative solution for this?

SELECT
TIMESTAMP (CURRENT_DATE + (7 - DAYOFWEEK_ISO
(CURRENT_DATE)) DAYS, '00:00:00'),
TIMESTAMP (CURRENT_DATE + (13 - DAYOFWEEK_ISO
(CURRENT_DATE)) DAYS, ‘23:59:59’) + 999999 MICROSECONDS
FROM SYSIBM.SYSDUMMY1)
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Tue Jun 08, 2010 6:09 pm    Post subject: Re: Stored Procedure is not accepting
Reply with quote

have you tried this select in spufi?
Back to top
View user's profile Send private message
chrakesh

New User


Joined: 03 May 2010
Posts: 16
Location: india

PostPosted: Tue Jun 08, 2010 6:29 pm    Post subject:
Reply with quote

Yes it executed successfully but it is saying

ILLEGAL SYMBOL "=". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: + -
Back to top
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Tue Jun 08, 2010 6:44 pm    Post subject:
Reply with quote

Quote:
FROM SYSIBM.SYSDUMMY1)


I wonder how the SQL executed successfully in SPUFI?
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Tue Jun 08, 2010 7:46 pm    Post subject:
Reply with quote

1) quotes round : ‘23:59:59’ are the wrong kind
2) like murmohk1 says : one ) too many
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Query on DB2 WLM stored procedures ashek15 DB2 8 Sun Feb 12, 2017 11:13 pm
No new posts Calling procedure with multiple entri... steve-myers PL/I & Assembler 5 Fri Jan 27, 2017 3:33 pm
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm
No new posts Access SQLCA fields inside a stored p... gangapd DB2 6 Thu Oct 27, 2016 10:20 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us