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



I added date and time fields to an existing table 'CRDSRVCFG' in a working program. Now my program won't compile.
I get the following error:
SQL5011: Position 14 Host structure array REC not defined or not usable. Reason: The datetime format of a member of the host structure array does not match the SQL datetime format.

My file only has 10 fields... so I have no idea what position 14 is in my Data Structure.

I found a recent post about this, but no resolution was mentioned other than setting the datefmt explicitly.

Code snippets:

ctl-opt datfmt(*iso) timfmt(*iso);

dcl-ds cfg extname('CRDSRVCFG') qualified dim(100) inz;
end-ds;

Exec Sql Set Option datfmt=*iso;

Exec Sql
Declare sqlcsr Cursor For
Select * from CRDSRVCFG where interface = :interface
Order by com_nbr
For Read Only;

Exec Sql Open sqlcsr;

My Procedure to fetch rows:

dcl-proc FetchGroup;

dcl-pi FetchGroup ind;
rec likeds(cfg) dim(100);
end-pi;

dcl-s sqlRows int(10);
dcl-s maxrows int(10) inz(%elem(rec));

Exec Sql
Fetch Next From sqlcsr For :maxrows Rows
Into :rec;
[Logo]<https://www.totalbizfulfillment.com/> Greg Wilburn
Director of IT
301.895.3792 ext. 1231
301.895.3895 direct
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>
1 Corporate Dr
Grantsville, MD 21536
www.totalbizfulfillment.com<http://www.totalbizfulfillment.com>

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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.