Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SiouxCityElvis

    DateAdd-Start with last day of February + 1 month

    Sheco, Thanks. I used something that Bob suggested in thread222-97014 which is basically what you are saying. I return a long since we store our dates as long. For I = 0 To UBound(OfSomething) ... arrayOne(I).longDateVar = Date2Num(DateAdd("m", I * blah.iFreqCnt, Num2Date(blah.dtFirstDate)))...
  2. SiouxCityElvis

    DateAdd-Start with last day of February + 1 month

    I am trying to get the following For Loop to return the last day of each month starting with the last day in February. But when I start with a date of 02/28/2006 or 02/29/2008 the rest of the months end up with '28' as their day value. I need it to be the last day of the month for each month...
  3. SiouxCityElvis

    how to run 1st Monday of every month

    How do I set my crontab to run a process 1st Monday of every month? Thanks. -Programmer dummy
  4. SiouxCityElvis

    Date formatting

    Tom, Thanks. -David
  5. SiouxCityElvis

    "Literal" line to line continuation

    Okay, Thanks all. Tom, Looks like I've got it working a couple of different ways. There is a flow chart on the site showing how SQL CONSTRUCT QUERY precedes SQL PREPARE QUERY, and examples of each, I just don't see an example of how PREPARE would follow CONSTRUCT. CONSTRUCT code... SQL...
  6. SiouxCityElvis

    "Literal" line to line continuation

    Okay. This will work as long as I am not using the WHERE clause. I'm confused as to how go and populate the "?" values after my PREPARE stmt. Example from InstantSQL... SQL PREPARE QUERY Statement Example: 01 ws-SelectQueryHandle USAGE ISqlHandle. 01...
  7. SiouxCityElvis

    "Literal" line to line continuation

    Hello everyone, I am using RMCOBOL-85 on Linux. The following I have on one line but it goes past column 72 and thus I get an error 1152 "SELECT JunkId, JunkName, JunkDate, Descripti ***** 1) 0098: E Nonnumeric literal must end with quotation mark. (scan suppr...
  8. SiouxCityElvis

    Date formatting

    Doesn't that JUSTIFIED justify it to the Left??? So, wouldn't 8/09/2004 yield 8space in the WS-MM field 09 in the WS-DD field and 2004 in the WS-YYYY field ? Not trying to be difficult, just want to understand. My approach without help would have been to JUST RIGHT the WS-MM, DD, and YYYY...
  9. SiouxCityElvis

    Date formatting

    There it goes. Stars...
  10. SiouxCityElvis

    Date formatting

    Works like a charm. Thanks COBOLKid and K5tm(Tom). I tried to hand out stars to you but it said page was undergoing maintenance.... -David
  11. SiouxCityElvis

    Date formatting

    Tom, I'm confident that the dates are valid simply to the point that they are using quickbooks when sending this data. I guess, since really I'm storing this field as a field in a check stub record(simply informational) it doesn't matter if they put 14/21/2021 in there - that's there problem if...
  12. SiouxCityElvis

    Date formatting

    Hello. I'm on RMCOBOL-85 on Linux. I'm parsing a record and trying to figure out the best way to reformat a date field on it. The date field appears in the very beginning of the record. There are many ways I should anticipate this date field coming in, but my end goal is to put it into a...
  13. SiouxCityElvis

    InstantSQL C.R.U.D. Example Request

    Everyone(Especially Tom - the man of great COBOL wizardry), We have resolved the connection issues and now I'm ready to start using InstantSQL queries, update, and delete functions. Connection was made to our test data source. The only challenge now is that if I want to run my InstantSQL, I am...
  14. SiouxCityElvis

    InstantSQL C.R.U.D. Example Request

    Tom, or anyone who has had the challenge of setting up MyODBC on Linux... The README.TXT Says "The iODBC driver manager uses several environment variables to track ODBC data sources. The OpenLink installation procedure installs a file (named openlink.sh in the test installation) that sets...
  15. SiouxCityElvis

    InstantSQL C.R.U.D. Example Request

    I hate trouble shooting Network admin related issues :( Latest and greatest is that I'm not getting the old problem after installing iodbc and running prgname -l=libisql.so but I'm getting the connection error from the DISPLAY stmt in my code. -David
  16. SiouxCityElvis

    InstantSQL C.R.U.D. Example Request

    Tom, The java programmer verified that the MyODBC is working simply by using the "isql". We've looked at the tables through isql, queried, updated, etc and it seems to work fine. I looked at my SQLEXAMPLE.LST file per your instructions and pinpointed the line the runtime gave for error 204...
  17. SiouxCityElvis

    InstantSQL C.R.U.D. Example Request

    Tom, Yes, I understand the INSERT deal. I was making a mystery out of something that didn't need to be a mystery. The EXSQRY01 sample from Liant is a good one. I will just substitute INSERT for UPDATE in the ws-update-sql variable. Sorry about that. Thanks. -David
  18. SiouxCityElvis

    InstantSQL C.R.U.D. Example Request

    Excuse me, I meant the java programmer is looking into the MyODBC he setup not MySQLODBC. Sorry.
  19. SiouxCityElvis

    InstantSQL C.R.U.D. Example Request

    Yes, I created the ccomp for rmcobol command. It is an Alias. I'll try it using the rmcobol command instead with the -l option. Is there a specific file that the listing appears in? Here's what I did from compile through run... [root@Vallon rmcobol]# rmcobol SQLEXAMPLE.CBL -l RM/COBOL...
  20. SiouxCityElvis

    InstantSQL C.R.U.D. Example Request

    Also, I can not for the life of me find an example for INSERT statements(adding records) to an SQL database. I'm wondering if any of this can actually be accomplished. It's out there, but I haven't found an example that actually works. Pure ignorance on my part and I can't find answers...

Part and Inventory Search

Back
Top