ESQL/C to Oracle Conversion Tools. Post: 92737

5 More Discussions You Might Find Interesting

1. Programming

esql/c for 64 bit

I tried to compile a program esql/c in 64 bits but I couldn't do it, I want to know how I can do this, I make a makefile but it doesn't work.

2. Shell Programming and Scripting

Epoch & Unix Timestamp Conversion Tools

Hi All, Please read the below data carefully. I need an unix command for converting unix timestamp to Epoch timestamp. I need to daily convert this today's unix(UTC) time to epoch time, so i am thinking to make a shellscript for this. Please help me for this by providing...

3. Programming

RHEL: Problem while using "purify gcc" for ESQL-C

Hi I am facing a problem while doing Purify Instrumentation of the Informix ESQL-C files. The system is RedHat Linux 5.6 and compiler is gcc. I have set both CC and INFORMIXC variables to "purify gcc" and compiled the source code. All the .c and .ec files were compiled successfully, but...

4. Shell Programming and Scripting

Help required for Oracle database shutdown script conversion from shell to perl

Please tell me how to convert below program from shell script to perl. Same commands need to use in shutdown, just need program help for startup. export ORACLE_BASE=/home/oracle1 lsnrctl start lndb1 sqlplus '/ as sysdba' startup;

5. Solaris

Where can I get Sun Ultra 20 tools & drivers when Oracle abandoned them?

I'm in a desperate pursuit for Tools and Drivers CD for the six of my Ultra 20 M2 workstations - some of them have latest BIOS, some of them don't. Oracle doesn't support them anymore - I even bought myself a CSI to get to support, but still no luck - and it seems the ISOs are nowhere to be found...

LEARN ABOUT PHP

ifx_fieldproperties

IFX_FIELDPROPERTIES(3)							 1						    IFX_FIELDPROPERTIES(3)

ifx_fieldproperties - List of SQL fieldproperties

SYNOPSIS

       array ifx_fieldproperties (resource  $result_id)

DESCRIPTION

	Returns  the  Informix	SQL  fieldproperties  of  every  field	in  the  query	as  an associative array. Properties are encoded as: "SQL-
       TYPE;length;precision;scale;ISNULLABLE" where SQLTYPE = the Informix type like "SQLVCHAR" etc. and ISNULLABLE = "Y" or "N".

PARAMETERS

	      o $result_id
		-$result_id is a valid resultid returned by ifx_query(3) or ifx_prepare(3) (select type queries only!).

RETURN VALUES

	Returns an associative array with fieldnames as key and the SQL fieldproperties as data for a query  with  $result_id.	Returns  FALSE	on
       errors.

EXAMPLES

       Example #1

	      Informix SQL fieldproperties

	      <?php
	      $properties = ifx_fieldproperties($resultid);
	      if (!isset($properties)) {
		  /* ... error ... */
	      }
	      foreach ($properties as $fname => $val) {
		  echo "$fname:	 property = $val
";
	      }
	      ?>

SEE ALSO

       ifx_fieldtypes(3).

PHP Documentation Group 												    IFX_FIELDPROPERTIES(3)