• How can I pass tablename as a parameter in MySQL stored procedure?

    my SQL stored procedure is like this.... ALTER PROCEDURE [dbo].[Sp_InsertDataMaster] @_ImageID int, @_Stat bit, @_tablename nvarchar(200) AS begin declare @strTemp nvarchar(max) set @strTemp = 'Insert into ' + @_tablename + '(ImageID,Status) values ('+ convert(nvarchar(5),@_ImageID) +','+...

    Minal45 pointsBadges:
  • SQL / DB2 Optimization (timing out)

    I put together a simple VB program to run SQL commands on any of our 4 I-series machines to return a simple grid view. I have run across a strange problem and was told it may have to do with optimization. For example if I run the following SQL ( I just want a count of parts (pm) that have not been...

    ToddN200011,295 pointsBadges:
  • I need help with a SQL problem

    I have a SQL statement that reads as follows: select subject1, subject2, subject3, subject4, subject5, subject6 from card_catalog where subject1 like? This SQL statement works I just do not have the statement in front of me to type it in correctly. Is what my real question is. I have a TEXTBOX that...

    COMPCAD15 pointsBadges:
  • AS/400 query select count distinct

    Hello, does someone knows how I can count distinct values on a column via query select? (same as count distinct via SQL)

    WOES9995 pointsBadges:
  • how to set gridview column width to auto

    I put together a simple vb program, or so I thought. I am accessing DB2 tables and trying to pull the data in using a DB2 reader. What I'd like is to have the columns be set to width=auto. The number of columns depends on the DB2 table. I'm getting an error "Index was out of range. Must be...

    ToddN200011,295 pointsBadges:
  • iSeries: Text fields from different records in same file

    We have some data (in a file of course) on iSeries using DB2. Here's the file structure:Item Textline Text 12755 1 this item 12755 2 is no longer 12755 3 for sale abc123 1 please use abc123 2 another code xyz987 1 obsoleteThis is the result that we're trying to get: Item Text 12755 this item is no...

    ITKE346,430 pointsBadges:
  • Is COUNT a valid expression in SQL DB2 in iSeries?

    Can I use COUNT in SQL DB2 in iSeries for row partitions? I've tried to run the following query: select COUNT(1) over (partition by COL1, COL2) from MyTable and received the following error message: [Message SQL0401] Token ( is not a valid token. A partial list of valid tokens is , FROM INTO. How...

    ITKE346,430 pointsBadges:
  • Identifying SQL function dependencies

    Hello,Our Iseries site is a heavy user of embedded SQL. We have over the past few months started using SQL UDFs and have recently been found out when the dependent UDFs have not been deployed along with the main deployed code. Would anyone know if there is an easy way of identifying dependent SQL...

    IHDCSL25 pointsBadges:
  • SQL 2008 Security: How do I give users access to just views within a DB?

    I have inherited a SQL DB and need to give a group of users access to some views within a DB. We do not want them to access the tables, just the views. They will be connecting using MS Excel for reporting purposes. Do I use a role or schema? What is the best practice to accompish this task without...

    Multipass5 pointsBadges:
  • Security/ Audit Check list for DB2

    Hi, I'm in the process of hardening the DB2 in Linux and I'm looking for a checklist to help me make sure I don't miss anypoint. Since I'm not an expert on DB2 I would like to have a starting point. I'm looking to make sure I don't leave open doors and also I want ot make sure I don't get an Audit...

    Josec990 pointsBadges:
  • export data from forms to excel

    how to export the selected data from forms to excel?..

    Brithivi5 pointsBadges:
  • How do you do LIMIT in DB2 for iSeries?

    We currently have a table of more than 50,000 records and we're trying to return records of 0 to 10,000 / records of 10,000 to 20,000. We already know that in SQL, if you write "LIMIT 0,10000" at the end of the query, it will bring you that record. How can you do it in DB2 for iSeries? Thanks!

    ITKE346,430 pointsBadges:
  • SQL and OPNQRYF

    What we can do in SQL which we cannot do in OPNQRYF

    sunnygupta35 pointsBadges:
  • Inserting multiple rows in Oracle 10g

    I need to insert multiple rows of data into multiple tables from one temporary table. I need to put some of the columns into one, some into another, and the remainder into another table. I realize I will need to create INSERT statements for each table insert. Is there an easy way to select specific...

    Ora mer20 pointsBadges:
  • How save SQL and CL in SAVF!

    Hello, How to save CL and SQL in SAVF, while SAVLIB command these two type of members are not saved. I want to move these from V7R1 to V5R4. Please suggest!

    sgautam11110 pointsBadges:
  • Help joining data into table 1 from table 2 SQL

    I have 2 tables, table1 has columns A,B,C,D and table2 has columns B,C,D, I want to update table1 column A with table2 column B, where table1 c,d matches table2 b,c. I hope that was clear.

    JustAnotherITguy60 pointsBadges:
  • Porting a C+ app from SQL to Citrix

    I’m running a C# application on a number of workstations through the same MS-SQL database. I've been asked to port this to Citrix.  How would one even get started on such a transition?  Does anyone know of good documentation I could access? Once the C+ app is installed on the Citrix server,...

    ITKE346,430 pointsBadges:
  • How to manage SQL queries on iSeries

    We have users who are using SQL to perform queries on our iSeries. As such, we need a way to manage these queries so that, if a runaway, poorly written, etc. causes issues for CPU and/or DASD we can either be notified, end the job, or some other parameter. Is there such an animal? Thanks!

    StarTaylor15 pointsBadges:
  • Row by Row Stored Procedure in SQL Server 2008 R2

    Hi all, Hopefully someone will be able to help me here - I'm nearly there but can't get it right, I'm trying to create a stored procedure that when it runs, it will do a query and then send send an email out for each of the rows that it returns. e.g. If I have a DB with 4 columns (ID, Days,...

    Turdywills65 pointsBadges:
  • How to find a specific word in a SQL table

    How do you write a SQL query to find a specific word in a SQL column. Example: I want to show all records that have the word Bob in it but do not want to include records that are Bobby or Bobble etc., only the exact word Bob. Hope that makes sense.

    Boomer15 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following