Re: COBOL/DB2 Date edit question

Pete Dashwood wrote:

(When you have your "--" and the sig block at the top of the message, my reader truncates everything - that's why there's nothing quoted here...)

There are benefits to stored procedures - but the RDBMS runtime would still have been charged to our program, as the thread that started the whole mess would have been part of the program's charged time. :) There's another school of thought that stored procedures tie one to a particular database, and that a program-based solution is preferable to obtain DB independence. Of course, we've had enough debate in here as of late... ;)

Personally, I believe that call has to be made for each system, by analyzing what it's going to do. On our Unisys mainframe-based COBOL system, putting stored procedures in their proprietary RDMS format would probably make sense. If it gets ported to another architecture, they're likely going to have different ways of validating dates. On the other hand, on my websites I'm working on now with PHP 5, I'm using PHP Data Objects (PDO), which should allow me to extract the data access from the underlying database. (Not that I plan on running it on anything but MySQL; but, I'll have the option.)

<ot>
Then, in my next set of college classes is .NET. I'll be having fun with Mono, I'm sure - I may just finally get the knack of that. (Part of it is I'm not getting paid for either - it's hard to justify sitting on the couch with a laptop in my lap when the kids want folks to bounce them on the trampoline, maintain their bikes, etc... ;> )

And then, I've been "selected" to "voluntarily" retrain into a different career field (not programming). They want 20, and I'm #45 on the list, so I should be safe. (If 20 don't volunteer, then everyone on the list has to pick what they want, and risk being involuntarily retrained.) So, I have to decide whether to a) not play this game and get out when this enlistment's up (with 13+ years at that point, that seems foolish); b) risk being involuntarily retrained to some combat career field; or c) choose my own path (there are current openings in safety, radio/TV, and as a chaplain's assistant).

Even if I switch career fields, though, I'll still pursue my bachelor's degree in Computer Science - especially when I can breeze through so many classes.
</ot>

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~ / \/ _ o ~ Live from Albuquerque, NM! ~
~ _ /\ | ~ ~
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
~ Business E-mail ~ daniel @ "Business Website" below ~
~ Business Website ~ http://www.djs-consulting.com ~
~ Tech Blog ~ http://www.djs-consulting.com/linux/blog ~
~ Personal E-mail ~ "Personal Blog" as e-mail address ~
~ Personal Blog ~ http://daniel.summershome.org ~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

GEEKCODE 3.12 GCS/IT d s-:+ a C++ L++ E--- W++ N++ o? K- w$ !O M--
V PS+ PE++ Y? !PGP t+ 5? X+ R* tv b+ DI++ D+ G- e h---- r+++ z++++

"Who is more irrational? A man who believes in a God he doesn't see,
or a man who's offended by a God he doesn't believe in?" - Brad Stine
.

Relevant Pages

  • Re: COBOL/DB2 Date edit question
    ... There are benefits to stored procedures - but the RDBMS runtime would ... Play with the kids. ... risk being involuntarily retrained to some combat career field; ...
    (comp.lang.cobol)
  • Assessment of Database Stored Procedures
    ... I am attempting to compile a list of questions that will enable me ... assess 'at risk' stored procedures that need to be remediated in order ...
    (comp.databases.ms-sqlserver)
  • Re: COBOL/DB2 Date edit question
    ... we've had enough debate in here as of ... DB, although now that DB2 is "free"I may return to that and bring the wheel full circle) and ACCESS and SQL Server, the ones required by the client, without problem. ... I didn't even know Access supported stored procedures. ... A man who believes in a God he doesn't see, ...
    (comp.lang.cobol)
  • Re: Passing Back Table Information from Oracle .NET Stored Procedures
    ... Stored Procedures. ... My God, it doesn't take a rocket scientist to figure this out that a result set is returned automatically out of the Stored Procedure, and is accessible via datareader. ... OracleDataReader rdr = cmd.ExecuteReader; ...
    (microsoft.public.dotnet.languages.csharp)
Quantcast