Convert MS Access Queries to AIX SQL Post: 302925859

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

SQL queries in background?

I have to query a DB2 database, and sometimes they take a long time to produce results. Can I run these queries in the background, and if so, where will the results appear?

2. UNIX for Dummies Questions & Answers

Hi All, I have written 4 sql queries . Now I want to write one SHELL SCRIPTING program for all these queries... i.e 1.select * from head; 2. select * from detail; 3. delete from head; 4. delete from detail; Please let me know how to write a shell script... Thank you

3. Shell Programming and Scripting

Select SQL Queries Option

count.sh#!/bin/ksh SQL1=`sqlplus -s usr/pwd @count.sql $1 $2 $3` SQL2=`sqlplus -s usr/pwd @selectall.sql $1 $2 $3` LIST="Count Select_All" select i in $LIST do if then echo $SQL1 elif then echo $SQL2 fi done

4. Shell Programming and Scripting

Nested SQL queries within Shell script

Hi, Would someone know if I can fire nested sql queries in a shell script? Basically what I am trying to do is as follows: my_sql=$(sqlplus -s /nolog<<EOF|sed -e "s/Connected. *//g" connect...

5. Emergency UNIX and Linux Support

Insert data into sql queries from a file

Hello friends, I need to insert data from a file to another. I need this to form an sql query file which will consist of 50.000 INSERT INTO sentences. my sql query file will consist of 50.000 times the below line consecutively: insert into subscriber...

6. Shell Programming and Scripting

Script (with sql queries) not working using cron

Hi all, I have script, which performing sql queries and put output into file. When I run this script manually, its working fine, but when I want to schedule it with cron I am getting errors... I defined LD_LYBRARY_PATH and ,but no result. After I defined it, I am getting error: # more...

7. Shell Programming and Scripting

Code needed to get sql queries

Hi i need code to get sql queries through a shell script for a text file input which contain the service ids iputfile I-H-2048-10GB-M I-H-4096-12GB-M I-H-2048-p1000-M the code should contain below queries among which service_id is replacable with value from input file. ...

8. Shell Programming and Scripting

Help with storing the output of multiple sql queries to a file

Hi All, I have a file queries.txt as follows : SELECT COLUMN1 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN1 FROM SCDEMA2.TABLE2; SELECT COLUMN2 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN2 FROM SCDEMA2.TABLE2; SELECT COLUMN3 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN3 FROM SCDEMA2.TABLE2; SELECT...

9. Programming

Join 2 SQL queries into one

Dear community, could someone help me to join 2 queries into one? Basically it's the same query with different clauses (please notice the FIELD3 filters and related counters into the subquery): SELECT A.FIELD1,A.FIELD2,A.FIELD3 FROM TABLE A INNER JOIN ( SELECT FIELD1,...

10. Shell Programming and Scripting

Storing multiple sql queries output into variable by running sql command only once

Hi All, I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise. Eg : Select 'Query 1 output' from dual; Select 'Query 2 output' from dual; I want to...

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)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

SQL queries in background?

Discussion started by: jpprial

2. UNIX for Dummies Questions & Answers

shell script for sql queries

Discussion started by: user71408

3. Shell Programming and Scripting

Select SQL Queries Option

Discussion started by: killboy

4. Shell Programming and Scripting

Nested SQL queries within Shell script

Discussion started by: shrutihardas