php---sql Post: 6698

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to install PHP and My SQL on Solaris OS

Hi all I am really need your hand in my critical problem , I want to install PHP and My SQL on my Solaris 9 station , I am already have Apache Webserver on it . This is my system specs , I think it means some thing for who will help me : SunOS STATION_NAME 5.9 Generic_112233-08 sun4u sparc...

2. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Hi- I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment... I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert...

3. UNIX for Dummies Questions & Answers

Execute PL/SQL function from Unix script (.sql file)

Hi guys, I am new on here, I have a function in oracle that returns a specific value: create or replace PACKAGE BODY "CTC_ASDGET_SCHED" AS FUNCTION FN_ASDSCHEDULE_GET RETURN VARCHAR2 AS BEGIN DECLARE ASDSchedule varchar2(6); ASDComplete...

4. Shell Programming and Scripting

Execute multiple SQL scripts from single SQL Plus connection

Hi! I would like to do a single connection to sqlplus and execute some querys. Actually I do for every query one connection to database i.e echo 'select STATUS from v$instance; exit' > $SQL_FILE sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT echo 'select VERSION from v$instance;...

5. UNIX for Advanced & Expert Users

Call parallel sql scripts from shell and return status when both sql are done

Hi Experts: I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing...

6. UNIX for Advanced & Expert Users

Using PHP , call a sql inside a unix script

I am running the xampp on WINDOWS, and my php script is connecting to a unix script on a different server (ssh2_connect("11.31.138.56", 22). I am running the unix script and inside this script I am calling the .sql file . The SQL is connecting to oracle db on the unix server. But the sqlplus...

7. Shell Programming and Scripting

Getting junk data from MS SQL Server 2008 R2 using PHP 5.3.16

Hey!!! I am just trying to connect MS SQL Server 2008 R2 from PHP Version 5.3.16 using IIS 7.0. I am able to connect my MS Sql Server but I am getting junk data eventhough there is a valid data exists. I don't know what is the reason for that. Below is my code snippet. $conn =...

8. Shell Programming and Scripting

How to add decimal month to some month in sql, php, perl, bash, sh?

Hello, i`m looking for some way to add to some date an partial number of months, for example to 2015y 02m 27d + 2,54m i need to write this script in php or bash or sh or mysql or perl in normal time o unix time i`m asking or there are any simple way to add partial number of month to some...

9. 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 SUNOS

asadmin-set

asadmin-set(1AS)						   User Commands						  asadmin-set(1AS)

NAME

       asadmin-set, set - sets the values of attributes

SYNOPSIS

       set--user  admin_user[--password  admin_password][--host  localhost]  [--port  4848][--secure|-s] [--passwordfile filename] [--terse=false]
       [--echo=false] [--interactive=true] attributename=value [attribute_name=value]*

       Sets the values of one or more configurable attribute. This command is supported in remote mode only. On Solaris, quotes  are  needed  when
       executing commands with * as the option value or operand.

OPTIONS

       --user		       authorized domain application server administrative username.

       --password	       password to administer the domain application server.

       --host		       machine name where the domain application server is running.

       --port		       port number of the domain application server listening for administration requests.

       --secure 	       if true, uses SSL/TLS to communicate with the domain application server.

       --passwordfile	       file containing the domain application server password.

       --terse		       indicates that any output data must be very concise, typically avoiding human-friendly sentences and favoring well-
			       formatted data for consumption by a script. Default is false.

       --echo		       setting to true will echo the command line statement on the standard output. Default is false.

       --interactive	       if set to true (default), only the required password options are prompted.

OPERANDS

       attributename=value     identifies the attribute name and its value. See the Application Server Reference for a listing	of  the  available
			       attribute names.

       Example 1: Using set

       asadmin> set --user admin --password adminadmin --host localhost
       --port 4848 server.transaction-service.automatic-recovery=true

EXIT STATUS

       0		       command executed successfully

       1		       error in executing the command

       asadmin-get(1AS), asadmin-list(1AS)

J2EE 1.4 SDK							    March 2004							  asadmin-set(1AS)