12-10-2018
Maybe you should simplify this and INSERT the data in the table in a loop versus trying to import all the data in one single INSERT chuck? Sometimes doing things in a simple way (INSERT in loop) have easier results to understand that some sweeping method, all in one statement method (INSERT).
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hello all,
I'm new here, so this information may exist elsewhere on this forum. If so, please point me in the right direction.
Here's the problem.
I'm trying to migrate Oracle data from an HP system to a Sun system using a raw device as a 'bridge' between the two systems. Both machines... (4 Replies)
Discussion started by: Neville
4 Replies
2. Shell Programming and Scripting
Hi guys
I have a need to compress the contents of a directory while I am copying data into it. I was able to do this when it was only one file by doing as below:
STEP1: mknod myfile p
STEP2: chmod 777 myfile
STEP3: compress -v < myfile > myfile.Z &
STEP4: cp -p xyz_file myfile... (2 Replies)
Discussion started by: user1602
2 Replies
3. Shell Programming and Scripting
Hii friends,
I am a newbie to unix/shell scripting and got stuck in implementing a functionality.Dear experts,kindly spare some time to bring me out of dark pit :confused:..
My requirement is somewhat wierd,let me explain what i have and what i need to do...
1) there are several excel... (1 Reply)
Discussion started by: 5ahen
1 Replies
4. Shell Programming and Scripting
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies
5. Programming
Hello, i'm new to the forum and so am i to C programming.
Recently i've gotten a task to create a program that will read an existing .bin file and copy the data to a non existing (so i have to create it) .txt file (some type of conversion)
Now, i now how to put the arguments, opening and... (5 Replies)
Discussion started by: Lyric
5 Replies
6. Programming
I have a series of observations of which one column is sometimes missing (zero):
date temp delta
1977 284.54 29.84
1978 149.82 0
1979 320.71 28.45
1980 176.76 0
1981 854.65 0
1984 817.65 0
1985 990.58 27.98
1986 410.21 0
1987 405.93 0
1988 482.9 0
What I would like to achieve is a... (8 Replies)
Discussion started by: figaro
8 Replies
7. Shell Programming and Scripting
I have the following that I'd like to do:
1. I have split a file into separate files that I placed into the /tmp directory. These files are named F1 F2 F3 F4.
2. In addition, I have several directories which are alphabetized as dira dirb dirc dird.
3. I'd like to be able to copy F1 F2 F3 F4... (2 Replies)
Discussion started by: newbie2010
2 Replies
8. Solaris
Hello people,
I have a question regarding transferring data from one file server to another.
The server is a Solaris 9 box
The old file server is connected via Ethernet cable, and the new file server we are switching is a Fiber channel.
can I use the
dd if=server:/app1 of=server2:/app1
... (2 Replies)
Discussion started by: br1an
2 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I have a large number of data files each containing simple integers from 1 to around 25000 in ascending order. However, they are not in a specific progression; some numbers are missing in each file.
For ex. datfile1 may have the numbers in order 1 2 4 6 7 8 12 ... 24996 24999
while datfile2... (8 Replies)
Discussion started by: latsyrc
8 Replies
10. Red Hat
I need to perform operation as captioned.
I found out USB CD Drive is attached, by running 'lsusb' command.
I am trying to identify mechanism by which I could mount this USB CD drive to disk. After which I expect to copy the contents.
Could anyone indicate how this could be performed ? (3 Replies)
Discussion started by: videsh77
3 Replies
LEARN ABOUT PHP
sqlsrv_next_result
SQLSRV_NEXT_RESULT(3) SQLSRV_NEXT_RESULT(3)
sqlsrv_next_result - Makes the next result of the specified statement active
SYNOPSIS
mixed sqlsrv_next_result (resource $stmt)
DESCRIPTION
Makes the next result of the specified statement active. Results include result sets, row counts, and output parameters.
PARAMETERS
o $stmt
- The statment on which the next result is being called.
RETURN VALUES
Returns TRUE if the next result was successfully retrieved, FALSE if an error occurred, and NULL if there are no more results to retrieve.
EXAMPLES
Example #1
sqlsrv_next_result(3) example
The following example executes a batch query that inserts into a table and then selects from the table. This produces two results
on the statement: one for the rows affected by the INSERT and one for the rows returned by the SELECT. To get to the rows returned
by the SELECT, sqlsrv_next_result(3) must be called to move past the first result.
<?php
$serverName = "serverNamesqlexpress";
$connectionInfo = array("Database"=>"dbName", "UID"=>"userName", "PWD"=>"password");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
$query = "INSERT INTO Table_1 (id, data) VALUES (?,?); SELECT * FROM TABLE_1;";
$params = array(1, "some data");
$stmt = sqlsrv_query($conn, $query, $params);
// Consume the first result (rows affected by INSERT) without calling sqlsrv_next_result.
echo "Rows affected: ".sqlsrv_rows_affected($stmt)."<br />";
// Move to the next result and display results.
$next_result = sqlsrv_next_result($stmt);
if( $next_result ) {
while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC)){
echo $row['id'].": ".$row['data']."<br />";
}
} elseif( is_null($next_result)) {
echo "No more results.<br />";
} else {
die(print_r(sqlsrv_errors(), true));
}
?>
SEE ALSO
sqlsrv_query(3), sqlsrv_fetch_array(3), sqlsrv_rows_affected(3).
PHP Documentation Group SQLSRV_NEXT_RESULT(3)