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

    ToddN200011,790 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...

    ToddN200011,790 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,790 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...

    ITKE347,780 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...

    ITKE347,780 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:

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