Questions tagged [routines]
103 questions
1
vote
2 answers
Why the variable will empty after assign the values to the variable in go routines?
I'm using go routines to do fast execution. I'm making a sample program for practice but I'm wondered when I see that the value of the variable empty after assigning in the go routines. I'm showing my code:-
package main
import (
"fmt"
)
func…
puneet55667788
- 89
- 2
- 10
1
vote
1 answer
Stored procedure is too slow in mysql
I have a routine. But it' s too slow. How can I improve the query?
My records: http://www.sqlfiddle.com/#!9/14cceb/1/0
My query:
CREATE DEFINER = 'root'@'localhost'
PROCEDURE example.ssa()
BEGIN
drop table if exists gps_table;
drop table if exists…
Mikail Boybeyi
- 23
- 6
1
vote
1 answer
What better way to implement a routine that verifies and performs posts in social networks?
I'm writing a small application to perform automatic postings on social networks.
My intention is that the user can via the web interface create the post at a specific time and the bot can be checking for new posts scheduled and execute them.
I'm…
Wilson Tamarozzi
- 606
- 1
- 8
- 10
1
vote
1 answer
How to reuse same query code (Not result) in other stored procedures mysql?
I am working on stored proceudes in mysql.
I found that for some of proc i have to write a same portion of sql query, But i need a way to reuse the same query code(not result) in all proc, How i can do that?
Here is my S.proc:
BEGIN
SELECT date,…
1
vote
1 answer
How do I select whether the routine continues based on the participant's response?
I want to create an experiment in PsychoPy Builder that conditionally shows a second routine to participants based on their keyboard response.
In the task, I have a loop that first goes through a routine where participants have three options to…
Natalia L
- 43
- 4
1
vote
1 answer
How are I/O library routines implemented for languages which does not support low-level access?
Languages which don't support low level access to the machine, such as memory-mapped I/Os, often (if not always) have library routines which provides such access. Now, if the language itself does not support such access, how are these library…
gablin
- 4,678
- 6
- 33
- 47
1
vote
0 answers
How to automate the Junit test written using Talend routines using Jenkins?
We have a Talend job, in which we have written a routines with our own customized function to verify the functionality using Junit Assert methods.
How we can automate this Talend routine test using Jenkins? somehow we need to fail the build if the…
Shankar
- 8,529
- 26
- 90
- 159
1
vote
2 answers
Retrieving Row Key from HBase table in Talend
I'm a novice to talend.
I'm trying to read data from hbase and make some transformations on the data in expression builder using big data batch and write the output to a file.
now i want to get the row key of the table and apply transformations on…
jack AKA karthik
- 885
- 3
- 15
- 30
1
vote
0 answers
How to upload localhost phpmyadmin mysql procedures to server?
I am getting an error while uploading my database to server. my database has many stored procedures(routines) I am getting the following error how i resolve that ?
SQL query:
CREATE DEFINER=`root`@`localhost` PROCEDURE `getAttractions` () …
Bilal Hussain
- 149
- 1
- 12
1
vote
1 answer
MySQL using routine output to join on table
I have a routine that is called using
SET @p0='55'; SET @p1='-6'; SET @p2='100'; CALL `distanceSearch`(@p0, @p1, @p2);
Basically i pass in latitude, longitude and a distance to search for users, e.g 100 miles. The routine creates a temp table and…
user2202098
- 830
- 1
- 9
- 24
1
vote
1 answer
Intersystems Cache routine to write process information to a file on local system?
I am interested in creating a routine that would query the currently running cache processes and then write this information to a file. How could this be done in Cache 2008.2?
MattUebel
- 2,737
- 4
- 21
- 22
1
vote
1 answer
function statement error in datastage server routine (BASIC). Very simple but didn't working
I have problem with using datastage server routine function statement.
Would you please notice me to what is problem with my code?
It is simple but I don't know why didn't work...
The code is
$INCLUDE DSINCLUDE JOBCONTROL.H
FUNCTION GetTS(A,B)
…
gadiz
- 31
- 1
- 2
- 8
1
vote
1 answer
MySQLdump hangs with routines
I am trying to use a bat file to do a complete copy of a database to a different database. There are procedures and functions which need to be transferred over which is my biggest problem.
When I use
mysqldump -u user -p password db1 -v -R | mysql…
Conflict
- 13
- 3
1
vote
3 answers
Query to return internal details about stored function in SQL Server database
I have been given access to a SQL Server database that is currently used by 3rd party app. As such, I don't have any documentation on how that application stores the data or how it retrieves it.
I can figure a few things out based on the names of…
Anthony
- 36,459
- 25
- 97
- 163
1
vote
2 answers
Launch Trigger and Routine on Insert
Im attempting to have MySQL automatically insert data into another table after insert into one. I know to do this required Triggers and potentially Routines. I have a couple I've been trying to modify to do what I wish to accomplish but I appear to…
Seán McCabe
- 893
- 4
- 23
- 47