Database

Timestamps

I wish to:1.) define a timestamp and initialize it to system date/time. What odes the D spec look like for this or can it not be done in the D spec?2.)Load a data structure whihc is formatted to match timestamp defaults with data by field (CCYY MM DD...etc,).I want to then 3.)Move this data to...

View Answer   |  May 16 2008   7:47 PM GMT   |  asked by Bigdog55
RPG, Timestamp, D specs

run DBCC SQLPREF on linked server.

I want to run DBCC command on linked server remotly

Answer Question   |  May 16 2008   10:05 AM GMT   |  asked by Mangesh jadhav
SQL Server administration, Database Consistency Checker, DBCC

Convert time as text to datetime

I've got a stupid table that I have to work with (and no, I can't change it) that stores times of certain events as text (example: '10:25 pm' or '3:02 am'). This table has an actual date to work with, which is essentially just the date with no time component. Know what I'm going to ask yet? You...

View Answer   |  May 15 2008   11:53 AM GMT   |  asked by VentureFree
Microsoft Access, DateTime

Storing Binary Data

I've been in the process of reviewing the pros and cons of storing binary data (e.g. image files) either in blob fields in a database (presumably MySQL) vs. the filesystem of a server. I'm aware there are some concerns of security, but I'm mainly interested in performance at present.I could easily...

View Answer   |  May 14 2008   3:45 PM GMT   |  asked by Chunter
Binary data, Database, MySQL

VB.NET ans ORACLE database

Hi all. I know, that there is a big risk of asking a silly question, but I try to connect to a ORACLE 10g database witch MS Visual Basic 2005 Express Edition and all programming examples I found do not work. Is this a configuration that does not work? Or what software do I need exactly? What should...

View Answer   |  May 14 2008   6:59 AM GMT   |  asked by Flyer
Oracle 10g, VB.NET 2005 Express Edition, Database connectivity

Index Tuning Wizard shows error occurred while executing SQL statement but I can’t find the problem

I am facing a strange problem while using the Index Tuning Wizard (ITW) in SQL Server 2000. It shows error occurred while executing a SQL statement. I've checked every thing like trace is okay, as they show no problem with SQL Server 2005. Kindly give me some solution, URGENT.

Answer Question   |  May 14 2008   3:36 AM GMT   |  asked by SQL Server Ask the Experts
SQL Server performance tuning, Index Performance, SQL

Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?

Is the data in a SQL Server 2000 table still available for external applications, during editing or adding indexes via the Enterprise Manager?

View Answer   |  May 14 2008   3:24 AM GMT   |  asked by SQL Server Ask the Experts
SQL Server 2000, Enterprise Manager, Indexes

access2k unicode text column even # of bytes error

a certain row(s?) in an access2k table is corrupted. it causes the application to fail quite often requiring a messy procedure of bringing it up to date each time and it's been like this for years so no older backup exists. archive and fix fails for the same reason (unicode text column width must...

Answer Question   |  May 13 2008   7:38 PM GMT   |  asked by Santa
Access 2000, Unicode text column error, Data recovery

Unloading specific records in a foreign key, cascade format.

Hi,We have DB2 version 8, os/390. I know how to use QMF and JCL.I would like to unload, to files, specific records that I would enter, by the key, in a where clause. The record would then cascade down to unload ALL tables, with a specified TBCREATOR name based on foreign keys. I would like the...

Answer Question   |  May 13 2008   6:33 PM GMT   |  asked by Donnaw
DB2 Administration, OS/390, DB2

MS Access - Email from form - VAR email receipients

Hello,I have an access dbase and I need to email records (usually one at a time) to different receipients. The receipient name is part of the form and I have a table that lists the name and e-mail address. I am hoping to click a cmd button that will e-mail that individual the record on view. I...

Answer Question   |  May 13 2008   6:26 PM GMT   |  asked by Asuasol
Microsoft Access

DB2 Transaction in C#.Net

Hi,I am using C#.Net with DB2 batabase. I have installed IBM .Net Data Provider.I am facing problem with Transaction. when I execute insert query with transaction it doesn't work and without Transaction it works fine.does anybody know what's the problem am i making? remember i am using...

Answer Question   |  May 13 2008   1:12 PM GMT   |  asked by Mr. SEA
DB2, .NET, C#

Microsoft Access

I have created an Iff statement where it will compare two fields and return the bigger number. The problem is that instead of compare the numbers as a whole, it compares them digit for digit. Result is that it will return a value of 150 instead of the bigger value of 1040, because the second digit...

View Answer   |  May 13 2008   8:06 AM GMT   |  asked by Jaco
Microsoft Access

MS Access ActiveX Control

I am using a MS Form where I am trying to fill in a couple of date fields from a Calendar I inserted using ActiveX controls. How do I go about doing that?Thanks,Asuasol

View Answer   |  May 12 2008   6:50 PM GMT   |  asked by Asuasol
Microsoft Access, ActiveX, MS Access

Combined Address

I have one tblContacts that has "Home" and "Work" address included within it, I also have an option button 1="Work" and 2="Home". I need to prepare a mailling report, but only for the defaut address.Someone suggested that I create a calculated field. I tried this but all that it is doing is pulling...

Answer Question   |  May 12 2008   5:29 PM GMT   |  asked by Thuzinec
SQL, Query, Microsoft Access

Net Present Value

In an Access Form, I want to be able to have five values in text boxes and use those five values along with another value in the form, the return rate, to produce the Net Present Value

Answer Question   |  May 12 2008   4:41 PM GMT   |  asked by Mattylar12
Financial Functions, Microsoft Access

Best RAID for Database Server

We have 70+ users connecting almost 125 machines to connect to an Intel 5000VSA 4dimm Board Server with 2 Xeon processors, 6 SATA (on-board RAID 0, 5 or 10), 1 IDE port. I want to put the best possible RAID with 200/250GB SATA drives, with Best Redundancy and Performance, irrespective of the cost....

View Answer   |  May 12 2008   2:00 PM GMT   |  asked by Mkanjani
RAID configuration, Intel Xeon, Database Servers

MySQL Stored Procedures with Parameters in Crystal Reports 9???

Hi,am using Crystal Reports 9 and the MySQL 5 DBMS.I have a stored procedure which accepts a parameter, Crystal Reports won't accept this stored procedure and cites 'Incorrect Number of Arguments; expected 1, got 0'. Im pretty new to MySQL and perhaps I shouldn't be creating stored procs the way I...

Answer Question   |  May 12 2008   11:10 AM GMT   |  asked by Les za
Crystal Reports 9, MySQL, Stored procedures

how to get list of encrypted objets in sqlserver 2005?

i need a list of encrypted store procedure name,encrypted trigger ,encrypted functions from sql server 2005.

View Answer   |  May 12 2008   7:50 AM GMT   |  asked by Subrata73
SQL Server 2005, Encrypted stored procedures, Encrypted triggers

Aggregate data

Can I manipulate aggregate tables at the census tract level? In essence, could I create dummy variables, such as: white, black, hipanic, other for 100 census tracts? Or is this only possible with individual level data?

Answer Question   |  May 11 2008   5:42 AM GMT   |  asked by Romanov38
Census Tract data, Database programming, Database

Grouping and Sorting

I have a Crystal report in which I want to group employee number but sort the group by hire date. Is this possible?

Answer Question   |  May 9 2008   9:48 PM GMT   |  asked by KatSil
Crystal Reports, groups, Sorting