1 - 9 of 9
PREVIOUS 1 NEXT
STRQMQRY in batch on i5
Can STRQMQRY be run in batch? I am getting error message: Global variable prompting is not allowed in batch mode. I am passing 2 parameters from a display screen Software/Hardware used: iSeries, SQL, CL
Can STRQMQRY be run in batch? I am getting error message: Global variable prompting is not allowed in batch mode. I am passing 2 parameters from a display screen Software/Hardware used: iSeries, SQL, CL
35 pts.
SQL image data type
Hello expert, I have a developer using .NET front end then call function with image data type to load data into #temp table. He said that will be easy. I need help with few questions. 1. Using image, xml and ntext, will those data type effect performance. 2. If I do not want to use those data type,...
Hello expert, I have a developer using .NET front end then call function with image data type to load data into #temp table. He said that will be easy. I need help with few questions. 1. Using image, xml and ntext, will those data type effect performance. 2. If I do not want to use those data type,...
I want to select months from Jan to Dec using SQL query.
i want to select months from jan to dec using sql query. i will use this for list item note:- without using pl/sql and less union
i want to select months from jan to dec using sql query. i will use this for list item note:- without using pl/sql and less union
What is the difference between software package in SQL and PL/SQL
why is the need of psql when the sql is already avaliable.
why is the need of psql when the sql is already avaliable.
Custom alert messages with SQL
sql custom messages, how to put a message box if value entered is already taken? and if value entered does not exist?
sql custom messages, how to put a message box if value entered is already taken? and if value entered does not exist?
SQL Developer Views and Programs
I created a view to simplify the cursor within the package body. The SQL statement being used works as expected in SQL Developer but the program returns zero records. The program worked correctly before replacing one of the tables with this view. Not sure why all of a sudden the sql statement isn't...
I created a view to simplify the cursor within the package body. The SQL statement being used works as expected in SQL Developer but the program returns zero records. The program worked correctly before replacing one of the tables with this view. Not sure why all of a sudden the sql statement isn't...
Query performance and tuning
Hi, I wanted know as to what I can do to my query so that it improves in performance.RIght now it it taking 3-4 hrs because of the large no of records in the DB.If i remove the group by and order by clause for the same no of records it is fast but when it does sorting it hangs.But I need to do the...
Hi, I wanted know as to what I can do to my query so that it improves in performance.RIght now it it taking 3-4 hrs because of the large no of records in the DB.If i remove the group by and order by clause for the same no of records it is fast but when it does sorting it hangs.But I need to do the...
Need SQL query
Hi, I have a emp table in which I have 7 columns and hiredate is one of the columns. I need to query for the hiredate which has maximum number of employees joined the company on a particular date?
Hi, I have a emp table in which I have 7 columns and hiredate is one of the columns. I need to query for the hiredate which has maximum number of employees joined the company on a particular date?
1 - 9 of 9
PREVIOUS 1 NEXT
