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: 6966
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: 1278
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 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 4 Thu Oct 27, 2016 10:20 am
No new posts Is possible to call subprogram from c... cmsmoon COBOL Programming 3 Fri Aug 05, 2016 6:46 pm
This topic is locked: you cannot edit posts or make replies. Stored procedure on Federated thru DB2 arif677 DB2 6 Tue May 31, 2016 11:48 pm


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