Re: Conversion of data & associated logic from ISAM to RDB
- From: "James J. Gavan" <jgavandeletethis@xxxxxxx>
- Date: Wed, 04 Apr 2007 20:38:54 GMT
DaveM wrote:
On Apr 3, 9:13 pm, docdw...@xxxxxxxxx () wrote:
In article <1175626528.510733.311...@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
DaveM <renfre...@xxxxxxxxxx> wrote:
We are using Micro Focus Net Express 4.0 and Microsoft SQL Server
2000. The concepts/examples we are seeking however can be more
generic, i.e., not necessarily shown within COBOL source code per
se.
Right now we have two realized problems, both of which appear to
stem from our mutual and still-thriving ignorance......
The first problem is as follows: We are having surprising
difficulty in our attempts to find working examples of SQL-
related code sequences for handling low-volume user-entered
updates vs large-volume batch updates.
That's interesting... where have you looked for these, so that
others here might not duplicate your efforts?
If I'd kept a log of every single place I've been to while seeking
this information and then posted it here, as you seem to be kindly
requesting now, I am afraid that my inquiry would have become entirely
too enormous for most folks to bother with. Lets just say that I have
looked everywhere, with the obvious exception of those places where
the answers I am looking for are actually being kept.
The gist of what I am currently seeking should exist mainly within the
minds of many of those who frequent this newsgroup, hence my inquiry.
Forgive me for not making it clearer, but I am not asking anyone to go
out on a google tour on my behalf; I am only asking for information
relevant to people's own real-world experiences such that we might
gain a better perspective about the options we are faced with.
<snip>
So you have gone searching David, but did your search take the following into account :-
- Google Search, enter with the hyphen, "SQL-Examples" - will give you 54K hits
- The N/E V4.0 on-line book regarding SQL - Database Access http://supportline.microfocus.com/supportline/documentation/books/nx40/nx40indx.htm
- From the IDE top Menu Bar ----> Tools ----> Open ESQL Assistant, which lets you model SQL queries and run them, and get results, WITHOUT compiling. Once your test works, then you can copy/paste the proven SQL statement into a COBOL program and compile. (At first sight this tool looks complicated, but it isn't. Having set up a dummy DB table, have the patience to read through the text and then start experimenting with ESQL Assistant - you will be pleasantly surprised).
- Last and by no means least - sign up for the free Micro Focus Forum. Post under Net Express, ensuring "SQL" appears in your message title - and you should get help from an M/F lady specializing in DB support.
Regardless of the above, it will be worth your while to get a paperback 'How to ...." on DBs and SQL.
Jimmy
.
- Follow-Ups:
- References:
- Prev by Date: Re: Conversion of data & associated logic from ISAM to RDB
- Next by Date: Re: DATA MANIPULATION TEXT TO SIGNED NUMERIC RM COBOL
- Previous by thread: Re: Conversion of data & associated logic from ISAM to RDB
- Next by thread: Re: Conversion of data & associated logic from ISAM to RDB
- Index(es):
Relevant Pages
|
