• HOW TO READ A CSV FILE IN OBJECT STAR (O*)

    I have to requirements, 1) I need to extract data present in column A from a O* table, which is of of two columns 'A' and 'B'. The field value can be between 14 to 19 in length and numeric and the file should have a comma at the end of each record  ( e.g - the file extract should look like...

    Ari200940 pointsBadges:
  • How do i recover the DB from suspect mode in sqlserver 2000?

    I have a database that went to suspect mode in sqlserver 2000.How do i recover the DB from suspect without restore the DB? 

    Sqkservrdb20005 pointsBadges:
  • ODBC Error Message Windows Server 2003

    ODBC error:   "OLE IDispatch exception code 0 from Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.."

    Gina35 pointsBadges:
  • Adding Serial Number to an already existing access document

    Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as "Auto Number" and save the same it automatically gets changed to Text type.Please suggest. Thanks, Ansh

    Ansh12320 pointsBadges:
  • crystal report using parameter query

    i am doing one project using (vb6.0 + ms-access + crystal report 8.5) SELECT division_name, sum(Total_value) FROM segment_trans WHERE date between (Param1) And (Param2) GROUP BY division_name; this is my ms-access query (param1 and param2 thease two parameter value.) in crystal report i pass this...

    Srbatcha10 pointsBadges:
  • Large table in ASE 15.0.3

    Hello - I've got a process that loads 56million rows daily (via bcp) into a table, maintaining this data for 30days.  Our company is too cheap to pay for semantic partitioning so i'm wondering if anyone has any ideas on how to make queries respond in a semi-timely manner.  There's one date...

    Jyeager775 pointsBadges:
  • DB2 WebQuery: Metadata Error FOC1567

    I'm new to DB2 Web Query. Just starting with the product. In metadata, I'm trying to pull in a DB2 SQL derived Table. I keep getting an error FOC1567. *LOCAL, <create synonym>, Table <only>, library / filename Error FOC1567 Create Synonym Data Source 'StockKeepingUnit' is not unique The...

    Dlanor20 pointsBadges:
  • How to Export a MS SQL Image column to a file.

    I have pictures stored in a Ms Sql table in an image data type column. I want to be able to write the image(which is a JPG to a file. Is there a function in MS SQL 2005 or is another tool necessary?

    KatanaBeach115 pointsBadges:
  • Implementing a DBMS for a company

    I would like to know the basic steps I should take in implementing a DBMS for my company?

    Bigdate15 pointsBadges:
  • Update multiple tabs on an Access form on initial update

    I have 2 main tables, 1 main form and 4 subforms. The subforms all come from the same table. The subforms are in tabular format, and to fit all the fields I put each subform on a seperate Tabs. The Key Control Number ([Key Contl_Num]) is the Field that appears in each subform and on each tab. My...

    RKJohn95 pointsBadges:
  • database querying question SQLite

    Hi I'm setting up an SQLIte database within my C application that will be used as an intermediate stage in converting filetypes. My design tries to keep data normalized - for example, i have an Entity table, and in that table each entity has an integer type. There is another EntityTypes table with...

    Kreyszig15 pointsBadges:
  • How to calculate logical file size

    Hi, I need to be able to estimate the size of a logical file (inc access path). I've tried creating this file and almost filled the machine up. This is logical has quite a lot of key fields. Does anyone know a simple way of estimating the size (IBM has a formula in the manuals, but I can't make out...

    Gilly40023,730 pointsBadges:
  • OLE DB using Library List

    Hi, Do any one use OLE DB to connect to iSeries? Is OLE DB capable of using Library List provided by Job Description? Because when I used it, I have to specify the library name / schema and object name. Please advice... Thank you

    TG50 pointsBadges:
  • moving program code between lpars.

    I was wondering as to the best way to enable my operations staff to move program code from a test lpar to the production lpar. Because of audit requirements I can't have the programers able to move the code themselves.

    Mstallings0 pointsBadges:
  • Using Visual Basic and Access – having problems with other programs sharing memory

    Hi folks I have written a Point of Sale program which uses an access database. The program runs beautifully at sites where the the computers are dedicated specifically to running the software, but I am having nightmares at sites where the clients allow their staff to play games, download all sorts...

    JulianF25 pointsBadges:
  • MS access 2007 about field names?

    I'm making a very Simple database. its has ID, last name. telephone no. Type of OS (Windows/Linux/Mac). MY QUESTION IS, If a person has all the 3 OS, and some has 2 OS, other has 1 OS, How do i make only 1 field name for the the 3 selection, and make a database, a table and query where 1 person has...

    Voxli15 pointsBadges:
  • The most-watched IT questions this week: March 9, 2010

    1. A member asks how they can apply GPOs to non-domain computers to make sure they don’t get on the corporate domain, and MrDenny, Technochic, Denwood, and SiThu help with a solution. 2. A member asks about business intelligence in a cloud environment. 3. A SQL Server reader asks how to monitor...

    Michael Morisy8,323 pointsBadges:
  • Assign default values to SQL VIEW columns

    I'm trying to assign default values to VIEW columns defined for left joined columns or columns created by aggregate functions. I've tried the ALTER TABLE after the VIEW was created but get an error that my VIEW is not a TABLE and the ALTER VIEW is not supported by DB2/400 v5r3.

    Tgee60 pointsBadges:
  • How to use PL/I command LIKE with DB2

    I wont to use PL/I comman like for using same structure twice. Compiler returns error : IBM7043I S 4.1 SQL0314N The host variable "xxxxxxxx" is incorrectly declared. SQLSTATE=00000 IBM7043I S 9.1 SQL0117N The number of values assigned is not the same as the number of specified or implied columns....

    Sccsofti5 pointsBadges:
  • Cannot end RGZPFM on V5R4 (Journaled file)

    Batch job RGZPFM on V5R4 not complete after 3 days. I issued an ENDJOB, and job is not completely ended 1.5 days later. The file is journaled and is very large. SBMJOB CMD(RGZPFM FILE(MYLIB/MYFILE) KEYFILE(*NONE) ALWCANCEL(*YES) LOCK(*SHRUPD)) How can I end this job? If MYFILE is damaged, I can...

    AS400DBA15 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