List of Contributions

Jonathan Leffler

Contact Details

My Content

1 to 3 of 3 total
Posted By Jonathan Leffler Tue October 17, 2023 11:54 AM
Found In Egroup: Informix
\ view thread
Support for describing output values from a DESCRIBE statement without the keyword OUTPUT has been in the product since it was first released circa 1987. Support for the explicit DESCRIBE OUTPUT (to parallel the explicit DESCRIBE INPUT) was coded in the server for version 9.40 in mid-2002 (PTS#151098, ...
Posted By Jonathan Leffler Thu January 14, 2021 01:23 AM
Found In Egroup: Informix
\ view thread
No, there isn't a table to do that. You have to perform a calculation using the value in collength. Treated as a 16-bit value, the MSB (most significant byte) records the first number in DECIMAL(n,m), and the LSB (least significant byte) records the second number, with the caveat that a floating-point ...
Posted By Jonathan Leffler Fri May 15, 2020 03:34 PM
Found In Egroup: Informix
\ view thread
You can use $dbh = DBI::connect('dbi:Informix:.DEFAULT.', …) to create your database handle. You can then use $dbh->execute("DATABASE sysmaster"); to access your first database (sysmaster) and create your temporary table, and then use $dbh->execute('DATABASE sales_demo'); to access your second database ...