RE: SQL table edit code questions -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

Jack,
It's a great thing that you are using SQL more and more and yes you will see that there are certain elements of DDS which are not a part of SQL standards. EDTCDE is one of those. There is no SQL equivalent.
Query400 cannot consume any SQL function and sometimes cannot display a view depending on how it is defined. Views are similar to logical files and you can define new fields from other fields. I.e. a timestamp field coulld be split into two fields for date and time.
Jim

From: jacktucky@xxxxxxxxx
To: midrange-l@xxxxxxxxxxxx
Subject: SQL table edit code questions
Date: Tue, 1 Jul 2014 20:35:49 -0400

Hi All:

I've been using SQL more in my daily work. I'm working with my first table
defined using SQL.

Since I have users who like to use Query/400, Is there an equivalent to the
EDTCDE DDS keyword that I can use maybe via ALTER TABLE?

I also have a timestamp field in this table, is there a way to define a
separate date and time field as well?

I see iDate and and mcpress article for an edit code UDF from Bruce Vining,
but will they work with Query?

http://www.mcpressonline.com/programming/apis/the-api-corner-dynamically-edi
ting-a-numeric-value.html

Thanks, Jack

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.