Re: Opinions on approach, please...

Hey Pete


There are some very good points in this discussion.

I’ll tell you what, send me a small program and all the copy books to
compile it and I’ll send you the sql, vb.net (I don’t use c#), and
cobol code needed to run this application in sql.

A few things that you should know.
• In a trade off of disk size vs speed I chose speed.
• Each program has a single data connection. If you have dozens of
programs with dozen of files (tables) maintaining a connection of
each becomes a marshaling issue.
• Date time fields are pic 9(8)v9(9). 9(8)=date 9(9)=time
• I don’t use locks, they are stripped by the converter.
• I don’t use comp fields, they are stripped by the converter.
• I don’t store single quotes in the data base.
• Leading spaces in alpha fields. I don’t have a problem if I’m
loading the data through a cobol program but if I use a text dirver or
sql bulk load utility the data tends to shift.
• I don’t use sorts. On the system where most of my cobol code was
developed, writing to an indexed file and reading the file back was
faster than a sort. So no sorts.
• I write in Cobol, VB and SQL fairly interchangeably. So if the
customer master file has a prime key of CST-ACCOUNT the sql table name
is CST_ACCOUNT. So if I’m researching an issue I can find the problem
regardless of the language used.
• I’m still using Visual Studio 2003, mainly so I don’t have to rebuy
the Fujitsu compiler.


I would prefer a program that starts a program with a multi part
primary key. Something like an invoice header followed by an invoice
detail read for example, or that control break program you were
discussing the other day. The program should use indexed files and
start, read, etc no “exec sql”. If you want me to generate the data
conversion programs let me know.

Let me know the name of the default data base you want to use. I am
reworking the encryption routines that I use to pass user, password
etc. so I will probably strip that code. I will code it for a trusted
connection to the data base you choose.

I am considering build a web site where someone could upload selects,
fd, and programs and have them converted to use sql. It is still in
the planning stage. Other projects have priority. My conversion
programs are mostly cobol running against text files. Changing them to
run against a sql table is a minor change, changing so that each user
has their own conversion rules, is not.
For this reason I don’t want the vb or sql code posted to the
internet. The cobol code I don’t care about.

I am looking for feedback to improve my code and find the issues that
I overlooked.
Let me know what you think.

Tom
TLeaders gmail.com






.

Relevant Pages

  • Re: Opinions on approach, please...
    ... cobol code needed to run this application in sql. ... conversion programs let me know. ...
    (comp.lang.cobol)
  • Re: Where are the CONVERT & CAST functions in MDB?
    ... but I cannot the SQL type-conversion functions that works in SQL Server ... Each function coerces an expression to a specific data type. ... CVar Variant Same range as Double for numerics. ... you can document your code using the data-type conversion ...
    (microsoft.public.access.modulesdaovba)
  • Re: Where are the CONVERT & CAST functions in MDB?
    ... I thought those functions were only for VBA code, not SQL. ... Each function coerces an expression to a specific data type. ... CVar Variant Same range as Double for numerics. ... you can document your code using the data-type conversion ...
    (microsoft.public.access.modulesdaovba)
  • Re: object databases
    ... No I never heard of SQLJ as I don't program in Java. ... SQLJ checks your SQL statements against the db. ... The compile time check is not mandatory. ... So you use an object oriented language, ...
    (comp.object)
  • Re: Setup of 2005 Dev edition Client Components fails
    ... And try SQL Server setup ... to compile: C:\Program Files\Microsoft SQL ... Microsoft SQL Server 2005 Tools -- Install started. ...
    (microsoft.public.sqlserver.clients)