Collectives™ on Stack Overflow
Find centralized, trusted content and collaborate around the technologies you use most.
Learn more about Collectives Advice
0votes
3replies
69views
Procedure to show percentage of nulls in TERADATA SQL ASSISTANT
I'm working in Teradata SQL Assistant and I need to create a stored procedure that, given a table name, returns the percentage of NULL values for each column in that table.Right now, I generate the ...
- 67
-3votes
0answers
61views
Php and mssql. Extracting data from an MSSQL stored procedure to PHP [duplicate]
I have a stored procedure and know its input parameters. How can I extract this data from this stored procedure in PHP?I have a query that allows me to display this data in the MSSQL database itself. ...
-1votes
0answers
101views
Calling stored procedure through task results in empty table if procedure contains cross-database join
I have a stored procedure in Snowflake that joins data from two different databases, in the following form:CREATE OR REPLACE PROCEDURE database_1.schema_1.sp_test()RETURNS varcharAS BEGIN ...
- 344
1vote
1answer
58views
Redshift : Opening multiple cursors from within the same client connection is not allowed
I have the following procedure written in redshift, which uses 2 for loops to get country code first and then years as per the country codes.--Procedure : sp_for_loop_testcreate or replace procedure ...
- 7,345
0votes
0answers
60views
Redshift - SQL Error: Internal jdbc driver error
I am trying to use for loop within the stored procedure to retrieve the employee id and process further but getting an error:Error: SQL Error: Internal jdbc driver errorProcedure:create or replace ...
- 7,345
0votes
0answers
59views
How do I / example of adding source info in IBM MQ Header (possible MQRFH2/usr) from DB2 stored procedure
We have a stored procedure in DB2 written in an external sproc (possibly some mainframe language, possibly C++) that creates an XML structure and puts it on a queue.I know we can add a correlation id,...
- 3,021
0votes
1answer
194views
Does source length of SQL functions matter
First, to define what I'm talking about, the "length" of a source is how many characters it has. Having more characters allows improving readability by using more descriptive function and ...
0votes
2answers
82views
ASP.NET Core Web API + EF: how to convert the list of entities to queryable?
I need to rewrite the code for getting and filtering the list of products. The older version used directly the SQL table Products, and filtered the result by code or name of a product, category, etc, ...
- 21.1k
2votes
1answer
80views
User context and permissions when writing files from inside a plsh function in PostgreSQL on Ubuntu
I have a database on a Ubuntu system, that belongs to the postgresql user kalle (the owner of the database and the tables).That user is also the owner of the trigger function getimage, written in the ...
- 169
1vote
0answers
95views
Postgres stored procedure doesn't return if running longer than 5 minutes
I have the following simple Postgres stored procedure created that just sleeps a number of minutes as passed in to call:create procedure sleep_test(delay_minutes numeric) language plpgsqlas$$...
- 23
0votes
1answer
53views
DB2/LUW How to Perform Cross-database Query Comparison without Federation?
I did some reading and then confirmed with our DBA's that our databases are not federated. So, I figured I could write a stored procedure to connect to the first database and store the query output ...
- 153
1vote
1answer
92views
Writing and running a stored procedure asynchronously *and* getting a return value
Suppose I have two stored procedures, foo and bar, both written using Snowflake Scripting language.Inside foo, I want to call bar asynchronously and get a return value from bar. Is there currently a ...
- 1,729
0votes
1answer
132views
Filling Winforms datagrid using Postgres stored procedure
I am trying to get data from Postgres table with a help of stored procedure and fill a Winforms DataGrid with it.This is the stored procedure:CREATE OR REPLACE PROCEDURE public.get_list() LANGUAGE ...
- 27
2votes
1answer
268views
Make sure the consumer code uses @Transactional or any other way of declaring a (read-only) transaction] with root cause
I am trying to learn how to call stored procedure from springboot data jpa repository and returns a cursor from stored procedure. While I am implementing I am getting error like org.springframework....
- 1,688
-2votes
4answers
390views
PostgreSQL stored procedure call from Spring Boot gives "Procedure does not exist" and "might need to add explicit type casts" error
I am trying to learn and implement PostgreSQL Stored procedure call from Spring Boot repository using @Procedure annotated method. While calling stored procedure I am getting error saying that:Error...
- 1,688
- The Overflow Blog
- Featured on Meta
Hot Network Questions
- Number of subgroups in a semidirect product
- How do we decide whether a vibration of a solid object is longitudinal or transverse, when the object is not a 1D rod or 1D string?
- What are the correct lyrics to the song "Lola", by The Kinks?
- What exactly is Kripkenstein?
- Are the lampstands the same in Rev 11 and Zec 4?
- Can missed approach procedures be used for a PT?
- A novel where a time traveler arrived by mistake at the peak of the Black Death
- When was the symbol "U" first used to denote voltage or electric potential difference?
- Does the intersection of a variety with rational singularities with a smooth variety have rational singularities?
- To pretwist or not between two solids and one stranded?
- Making a case for a defensive infantry wedge formation
- Find the nearest school to you
- stim: why would order of CNOT operations affect detectors
- Bash script for manually cleaning up the Traefik access log file and limiting it to a maximum of 50 MB
- Condensation of water droplets on one side of a bottle!
- Why is the verb "to sic" conjugated with a double c rather than the more typical ck?
- What is the difference between V-inf+ことない and V-stem+ない
- What is the point of All In?
- If photons are the carriers of the electromagnetic force, why isn't electricity made of photons?
- About \def parameter list
- How to flip or mirror keyframes horizontally on the X-axis in Graph Editor?
- When exactly does the game clock start during an American football kickoff?
- MinMaxStack - tracks minimum and maximum values
- Find Extreme UV data source for the Sun