SQL0204N occoured 3 times
[description] SQL0204N "ITUAM.VW_TT_VALUES" is an undefined name.
SQLSTATE=42704
blah blah blah....
SQL3196N occoured 7 times
[description] SQL3196N The input file was not found
blah blah...
......
.... [The no. of lines varies for this error description]
..
blah blah blah....
how do i get the entire description part?
The only cue is that there is a blank line after the description is over in the output.log file which i am reading.
hi,
I get this error message after I pipe a lot of output into grep. Does anyone know what his means?
grep: writing output: Invalid argument
thanks,
gammaman (3 Replies)
Hello...
I'm trying to run the sshd script, but I keep geting the Syntax errot message .
Here's the last few lines on the script. set nu in vi shows 58 lines, but I keep getting error referring to line 59. Any help is appreciated.
Thanks,
Remi
else
echo... (4 Replies)
My file creates an output log after which includes a few sql queries.
I segregate them into warnings and errors and then get a total count.
The errors' and warnings' lines always start with SQL{4} followed by the details of the error.
This is what im doing as o now...
errors=`grep -A 1 -E... (1 Reply)
Hi Folks,
I got to know from this forums on how to grep from a particular line say line 6
awk 'NR==6 {print;exit}'
But how do i grep from line 6 till the end of the file or command output.
Thanks, (3 Replies)
Does anyone know how to use awk to act like grep from a particular line number to the end of file? I am using Solaris 10 and I don't have any GNU products installed.
Say I want to print all occurrences of red starting at line 3 to the end of file.
EXAMPLE FILE:
red
green
red
red... (1 Reply)
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
#/bin/sh -xv
#Author: Lauren Buecker
#Date: September 28 2012
#Class COP3353
#Assignment: Assignment 4... (7 Replies)
I'm trying to grep lines where the digits at the end of each line are greater than digits. Tried this but it will only allow me to specify 2 digits. Any ideas would greatly be appreciated. grep -i '\<\{3,4,5\}\>' file
---------- Post updated at 05:58 PM ---------- Previous update was at 05:41... (1 Reply)
In COBOL, a hyphen can be used in a field name and in a specific program some field names would be identical to others except a suffix was added--sometimes a suffix to a suffix was used. For example, assume I am looking for AAA, AAA-BBB, and AAA-BBB-CCC and don't want to look at AAA-BBB-CCC... (7 Replies)
Hi,
i need to cat a file after # till the end of the file
usually ill do cat /etc/somthing | grep -A999999 #
but its not that professional
thanks
edit by bakunin: please use CODE-tags (or ICODE-tags) for code and data. Thank you. (9 Replies)
Discussion started by: batchenr
9 Replies
LEARN ABOUT PHP
sqlsrv_errors
SQLSRV_ERRORS(3)SQLSRV_ERRORS(3)sqlsrv_errors - Returns error and warning information about the last SQLSRV operation performedSYNOPSIS
mixed sqlsrv_errors ([int $errorsOrWarnings])
DESCRIPTION
Returns error and warning information about the last SQLSRV operation performed.
PARAMETERS
o $errorsOrWarnings
- Determines whether error information, warning information, or both are returned. If this parameter is not supplied, both error
information and warning information are returned. The following are the supported values for this parameter: SQLSRV_ERR_ALL, SQL-
SRV_ERR_ERRORS, SQLSRV_ERR_WARNINGS.
RETURN VALUES
If errors and/or warnings occurred on the last sqlsrv operation, an array of arrays containing error information is returned. If no errors
and/or warnings occurred on the last sqlsrv operation, NULL is returned. The following table describes the structure of the returned
arrays:
Array returned by sqlsrv_errors
+---------+---------------------------------------------------+
| Key | |
| | |
| | Description |
| | |
+---------+---------------------------------------------------+
|SQLSTATE | |
| | |
| | For errors that originate from the ODBC driver, |
| | the SQLSTATE returned by ODBC. For errors that |
| | originate from the Microsoft Drivers for PHP for |
| | SQL Server, a SQLSTATE of IMSSP. For warnings |
| | that originate from the Microsoft Drivers for PHP |
| | for SQL Server, a SQLSTATE of 01SSP. |
| | |
| code | |
| | |
| | For errors that originate from SQL Server, the |
| | native SQL Server error code. For errors that |
| | originate from the ODBC driver, the error code |
| | returned by ODBC. For errors that originate from |
| | the Microsoft Drivers for PHP for SQL Server, the |
| | Microsoft Drivers for PHP for SQL Server error |
| | code. |
| | |
|message | |
| | |
| | A description of the error. |
| | |
+---------+---------------------------------------------------+
EXAMPLES
Example #1
functionname(3) example
<?php
$serverName = "serverName/sqlexpress";
$connectionInfo = array( "Database"=>"dbName", "UID"=>"username", "PWD"=>"password");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false ) {
die( print_r( sqlsrv_errors(), true));
}
/* Set up a query to select an invalid column name. */
$sql = "SELECT BadColumnName FROM Table_1";
/* Execution of the query will fail because of the bad column name. */
$stmt = sqlsrv_query( $conn, $sql );
if( $stmt === false ) {
if( ($errors = sqlsrv_errors() ) != null) {
foreach( $errors as $error ) {
echo "SQLSTATE: ".$error[ 'SQLSTATE']."<br />";
echo "code: ".$error[ 'code']."<br />";
echo "message: ".$error[ 'message']."<br />";
}
}
}
?>
NOTES
By default, warnings generated on a call to any SQLSRV function are treated as errors. This means that if a warning occurs on a call to a
SQLSRV function, the function returns FALSE. However, warnings that correspond to SQLSTATE values 01000, 01001, 01003, and 01S02 are never
treated as errors. For information about changing this behavior, see sqlsrv_configure(3) and the WarningsReturnAsErrors setting.
SEE ALSO sqlsrv_configure(3).
PHP Documentation Group SQLSRV_ERRORS(3)