|
The problem is that you are confusing the reserved word TODAY with a host variable TODAY. Remove the colon from in front of TODAY. Try it again. Peace. Rob Berendt ================== Remember the Cole! MacWheel99@aol.com Sent by: To: MIDRANGE-L@midrange.com (AS400 & family discussion group) owner-midrange-l@mi cc: drange.com Subject: SQLRPG/400 Day of Week ? 11/28/00 03:17 PM Please respond to MIDRANGE-L Does SQL's SET DayofWeek Scalar Function work in RPG/400? If so, what am I doing wrong? I have been working with RPG/400 but still a bit of a newcomer to SQL. This week I got the December 2000 News/400 & decided to try out some of the tips & those that worked for me were GREAT! I passed on some of the Query/400 tips (like uses for zero width fields) to non-programmer co-workers. On page 67 there is an article by Mike Cravitz on using SQL's Set Statement. Well I have several SQLRPG/400 programs which are 90% RPG, but have embedded SQL SELECT to get at data base stuff, instead of using chain read etc. which I think is real cool - you can get at selected info from many files in one SQL input, and just the info you need, not all the other baggage of a file record fields not being used. I selected a program that has lots of white space in front of printing date 11/27/00 thinking that I would first put Monday in front of that, then in some later program go after what day of week is associated with historical dates like when some shipment was made. C MOVEL *DATE TODAY 8.0 & I also defined WKDAY as 1.0 C/EXEC SQL C+ SET :WKDAY = DayOfWeek(:TODAY) C/END-EXEC Error message from SEU Token : was not valid. Valid Tokens: OPTION RESULT CONNECTION TRANSACTION I put cursor on error message & F1 A syntax error was detected Token : is not a valid token Syntax seems correct up to that point Well I use that exact symbol in my SELECT lines that compile & in fact I got this code by cut & paste from such a program then keyed over top to make the code look like the ILE example in the article, so if colon is invalid it is invalid with SET or I have a spacing problem Assuming this should work in SQLRPG/400, I figure that I may have a punctuation error, but not being an SQL guru, I cannot see it. MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac) AS/400 Data Manager & Programmer for BPCS 405 CD Rel-02 mixed mode (twinax interactive & batch) @ http://www.cen-elec.com Central Industries of Indiana--->Quality manufacturer of wire harnesses and electrical sub-assemblies - fax # 812-424-6838 +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +--- +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.