• SQL7917 job log message: Access Plan Not Updated

    SQL7917 Access Plan Not Updated message is being displayed in the job log thousands of times. What does this mean and how do we get rid of it?

    Pgmr4660 pointsBadges:
  • Adding a field when using SQL to copy a file on iSeries

    My company is upgrading some applications and I need to copy the data from current files into the new files. In some cases the new files have additional fields. Is there a way with sql to copy the current data and at the same time add either a default value or a running sequentional value to the...

    CLK50 pointsBadges:
  • Issue with Notes SQL ODBC driver

    Installing on W7 either x64 or x32, always get the error "unable to find nssqlc32.dll" even if set in PATH variable or all files copied to win system folder

    Trevorb30 pointsBadges:
  • sql not retuning column using DB2 data reader

    Strange one. I have a user that created a database file using WRKQRY. In this file is a user defined result field. Its basically a text label stating the build level 'LVL01'. After all levels are run (11 total) the file is complete. I am trying to access this data using a .NET program and a iDB2...

    ToddN200015,605 pointsBadges:
  • Forms in Access 2007

    I am using a form to upload data from the form into a database. I have a submit button on my form that upon clicking, needs to input all the users data into the correct slots in the database but I have no clue on how to do this, or where to get started. How should I go about solving this problem?

    Jenkinac40 pointsBadges:
  • 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...

    ToddN200015,605 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...

    ToddN200015,605 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...

    ITKE352,565 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...

    ITKE352,565 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:
  • 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!

    ITKE352,565 pointsBadges:
  • SQL and OPNQRYF

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

    sunnygupta35 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:
  • 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,...

    ITKE352,565 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:

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