• Multiple SQL statements through OLE DB on DB2/400

    We have a third party application built on SharePoint, and we want to use DB2/400 on our System i for the application's backend database. The app uses ADO and OLE DB to query whatever database it links to, and the vendor has it working on a number of different databases, including DB2 on Windows...

    AndyFarrar15 pointsBadges:
  • Coding of MD5 file in SQL format as accessing and recovering password?

    Add two-factor authentication on clients accounts when clients make an account. We're also trying to put in a security question and the answer should be saved with md5 format in a SQL file so when clients try to reset his account, they should answer the security question. What's the coding to do...

    ravikumarhg5 pointsBadges:
  • SQL to go From N Rows to 1 Row and N Columns

    I would like to ask for your help one more time, if you may. I work for an insurance company and am facing a challenge. I have two tables as such: policy_table Policy_number 12345 98765 45678 Policy_id (PK) 1 2 3 endorsement_table Endorsement flood quake theft hurricane freeze-pipe fire dog-bite...

    Esdras25 pointsBadges:
  • Getting ORA-29283 error when opening CSV file using UTL_FILE.FOPEN

    I have a SQL script and all it does in to open a CSV file using UTL_FILE.FOPEN. I keep getting the ORA-29283 error.  I have an Oracle directory object pointing to the file location. Here is the code snippet: create or replace procedure "SKINNY" as v_inputfile            ...

    jkeri360 pointsBadges:
  • REGEXP_SUBSTR

    I have a CSV file and in the first column i want to find only the records that start with 'S-'.

    jkeri360 pointsBadges:
  • How Would You Define Database Concepts?

    I am recruiting for a DBA for an ecommerce company and so far every candidate I have submitted to the HM has been rejected as they "do not understand database concepts". Circling round to the rejected candidates they all comment the HM is asking programming questions yet when I ask the HM and...

    tekhunter5 pointsBadges:
  • How to convert a TIMESTAMP data field to a CHAR data field in SQL

    How can I convert a TIMESTAMP data field to a CHAR data field?

    Keifford5 pointsBadges:
  • Domino web query returns incomplete result set

    I've inherited a a web based application which when executed via the notes form returns a false result set. The sql query executes and returns the proper result set when run through query manager however, when executed via the Notes web form using the ALL ALL input search parameter only a partial...

    Wolfen400 pointsBadges:
  • How to recover deleted tables from SQL Server

    I have created tables in sql server 2005 but some how all the tables get deleted so can anyone tell me a way by which i can recover my deleted tables.

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

    CLK35 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...

    ToddN200013,050 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...

    ToddN200013,050 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...

    ToddN200013,050 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...

    ITKE350,945 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