Search results for query: *

...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))) --If Feb and either 28th or 29th-- arrayOne(I).longDateVar =...

...day value. I need it to be the last day of the month for each month. [ For I = 0 to UBound(varB) ArrayA(I).dtBillDate = Date2Num(DateAdd("m", I * globStruct.iFrqCnt, Num2Date(globStuct.dtBDate))) Next ] Its been a while since I posted a thread - hope I put the code snippet in correctly -...

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

Tom, Thanks. -David

...example of how PREPARE would follow CONSTRUCT. CONSTRUCT code... SQL CONSTRUCT QUERY sql-QrySQL, sql-DirSetDS sql-ConnectionHandle, *> set connection "SELECT * FROM ", sql-DirQtID sql-TableName, *> quoted table name " WHERE HireDate = "...

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...

...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 "SELECT JunkId, JunkName, JunkDate, Description FROM Junk"...

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...

There it goes. Stars...

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

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...

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...

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...

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...

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

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...

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

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

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...

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...