dbTalk Databases Forums  

4GL V7.32 issue

comp.databases.informix comp.databases.informix


Discuss 4GL V7.32 issue in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Malc P
 
Posts: n/a

Default 4GL V7.32 issue - 08-22-2003 , 07:15 AM






OK, testing i4GL V7.32 on HP-UX 11i, IDS9.40.
The following code is coredumping:
(this is a cut down version of a bigger file, to the point where this
is the minimum to replicate the coredump)

################################################## #########################
database active

FUNCTION default_de_bond1()
DEFINE mr_de_bond1 RECORD LIKE de_bond1.*

SELECT *
INTO mr_de_bond1.*
FROM de_bond1

END FUNCTION
################################################## #########################

the schema for table de_bond1 has 258 columns, total width 3881 bytes.
Mostly chars, dates and integers - no special columns (byte, text
etc). Similar functions using other tables from the database are ok.
Is this error caused by the number of columns or rowsize in the table?
No info in release notes to suggest this.
The code compiles OK with r4gl, and the .err file produced by i4gl is
0 bytes.

Schema header:
{ TABLE "dba".de_bond1 row size = 3881 number of columns = 258 index
size = 100
}

Thanks for any help
--
Malc_p

Reply With Quote
  #2  
Old   
Mark D. Stock
 
Posts: n/a

Default Re: 4GL V7.32 issue - 08-26-2003 , 04:02 AM







Venkatesh Gopal wrote:
Quote:
There is a bug associated with this in 4GL , and will be fixed in the new
release.

Venkatesh.

Malc_p wrote:


OK, testing i4GL V7.32 on HP-UX 11i, IDS9.40.
The following code is coredumping:
(this is a cut down version of a bigger file, to the point where this is

the minimum to replicate the coredump)



################################################## #########################

database active

FUNCTION default_de_bond1()
DEFINE mr_de_bond1 RECORD LIKE de_bond1.*

SELECT *
INTO mr_de_bond1.*
FROM de_bond1

END FUNCTION



################################################## #########################

the schema for table de_bond1 has 258 columns, total width 3881 bytes.

Mostly chars, dates and integers - no special columns (byte, text etc).
Similar functions using other tables from the database are ok. Is this
error caused by the number of columns or rowsize in the table? No info in
release notes to suggest this.

The code compiles OK with r4gl, and the .err file produced by i4gl is 0

bytes.

Schema header:
{ TABLE "dba".de_bond1 row size = 3881 number of columns = 258 index size

= 100

}


That is a MONSTER table! From your code I would expect this to be a
memory allocation problem. Have you tried explicitly defining the record
elements instead of using the LIKE keyword? (Cut&Paste is your friend
there. ;-)

Cheers,
--
Mark.
Cheers,
--
Mark.

+----------------------------------------------------------+-----------+
Quote:
Mark D. Stock mailto:mdstock (AT) MydasSolutions (DOT) com |//////// /|
Mydas Solutions Ltd http://MydasSolutions.com |///// / //|
+-----------------------------------+//// / ///|
|We value your comments, which have |/// / ////|
|been recorded and automatically |// / /////|
|emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+

sending to informix-list


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.