Open MSAccess database
You would probably have to place the Access exe’s folder in the machine’s PATH Environment Variable.

View Answer   |  October 24, 2007  11:13 PM
file open, Microsoft Access

update single row error
This worked but is there an update query that would do the same? begin for rstid in (select distinct mf.mfr_name_id, mf.mfr_code from eqp_mfr_names mf,property p where p.mfrcode = mf.mfr_code) loop update property set mfr_name_id = rstid.MFR_NAME_ID where mfrcode = rstid.mfr_code; end loop; end;

View Answer   |  October 22, 2007  12:44 AM
multiple row query, Update

Inserting multiple rows in Oracle 10g
Actually, Oracle has an “INSERT ALL” statement that I believe was added in 9i and is available in 10g (someone please correct this answer if I’m wrong on that!) It’s a pretty powerful statement that allows you to insert into multiple tables at once by performing a select from your temp table of all the [...]

View Answer   |  October 18, 2007  3:01 PM
INSERT statement, Oracle, SQL

Select from table where data row missing
I meant to say Data Corruption has necessitated that we find the above scenario.

View Answer   |  October 15, 2007  9:35 PM
OUTER JOIN statement, SELECT statement

SQL joins on encrypted data
If your encryption padds the encrypted value with filler data then yes, the join could fail as the values wouldn’t match. If you aren’t padding the encrypted value then your values should match and you should be able to do the join.

View Answer   |  October 5, 2007  8:26 PM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL Server, Web site design & management

SQL 2000 to Yukon Migration
You would either need to setup a new server running SQL 2005, or install a SQL 2005 instance leaving the SQL 2000 instance. Then detach the databases from the SQL 2000 instance and attach them to the SQL 2005 instance. Be sure to do full testing to make sure that there won’t be any issues [...]

View Answer   |  October 5, 2007  8:18 PM
Access, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server

I can update the dataset, but not the database
Have you called Update on the data adapter? e.g. customersTableAdapter.Update(northwindDataSet.Customers); from msdn

View Answer   |  October 5, 2007  1:20 PM
Database, SQL Express, Visual Basic

Tracking Changes to Files
Hi EsJay Journalling the files is a good way to achieve what you want although as an alternative you could look at the use of database triggers. A database trigger can be defined to call a program whenever the physical files are updated (or records created). There are a lot of examples you can find [...]

View Answer   |  August 13, 2007  5:18 PM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development

C#.Net
Hi Colleen. I’m President of GLUGnet.org, the Lansing MI area user group for .Net. We have over 350 developers on our email list that covers essentially the entire central Michigan area. Since the Michigan economy is struggling and jobs are tight, you should get a strong response to a posting at our job website, jobcoin.glugnet.org. [...]

View Answer   |  July 12, 2007  10:57 PM
Application development, Business Objects, Business/IT alignment, C, Career development, Certifications, Cognos, Computer Associates, Crystal Reports, Data Junction, Data mining/analysis, Data warehousing applications, Database, DB2, Deltek Systems, Desktops, Development, Distribution/logistics applications, Enterprise Desktop, Financial services applications, IBM, Linux, Management, Microsoft Windows, MySQL, Oracle, OS, PeopleSoft, SAP, SAS Institute, Security, Servers, Software Quality Assurance, Software testing, SPSS, SQL, SQL Server, SS&C Technologies, SunGard Data Systems, Systems Union Group, Training, Transaction Systems Architects, VBScript, Vendors, Visual Basic, Web development, Web development tools

Source Modified User
Hi The first thing that springs to mind is to use some Change Management Software to control the modification and logging of source changes, but that may not be an option. Ideas that spring to mind are: a) I don’t know if it’s possible or not, but you could investigate adding a trigger to the [...]

View Answer   |  July 11, 2007  10:54 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development

Backward compatibility on OS level V4R4 to V4R3
Wow. If you have this spare machine with the capacity to take this history data, you have nothing to loose by restoring the data and verifying if the software will work. If there are no errors when you restore the data, seeing whether the software will run will not hurt anything. I can say, if [...]

View Answer   |  July 7, 2007  2:31 AM
DataCenter, DB2 Universal Database, RPG

odbc access error…….
The best way to fix this is to load this data into a database (access or other) that all your users can see. Because you can open file: You could dump the info into flat flies and then load these flat flies into the database that all users can access. Drew

View Answer   |  July 2, 2007  11:00 AM
Database, DB2, Oracle

Selecting an area within security to start
In a very real sense, it doesn’t matter as much what position or area you start with as what you do with it. Unless you have the misfortune to get employed by an egotistic micromanager, you’ll always have some latitude in how you perform your duties. Here are some suggestions: - Learn what security-related tasks, [...]

View Answer   |  June 27, 2007  1:05 PM
Access control, Application security, Biometrics, Browsers, Career development, CCNA, CCSA, Certifications, CISSP, Compliance, configuration, CRM, Current threats, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, Firewalls, Forensics, Hacking, Identity & Access Management, Incident response, Intrusion management, MCSE, Network security, Networking, patching, PEN testing, Platform Security, Policies, Risk management, Secure Coding, Security, Security Program Management, Spyware, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms

AS400
re question 1: if you journal the PF, you can determine what was deleted and restore the data. re both questions: you really need to provide more information if you expect to get a reasonable answer. Try to include OS version, language(s) being used, and if possible samples of code causing the problem. Also, be [...]

View Answer   |  June 20, 2007  3:24 PM
Application development, AS/400, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Printing, RPG, RPGLE, Security

Excel Data Transfer Add In
look for the option to convert CCSID (it may be on the ODBC data source definition, if not in the Excel query)

View Answer   |  June 19, 2007  4:44 PM
AS/400, DB2 Universal Database, Printing

Looking for Antivirus for Win Storage 2003 x64 server
So what products have you tried? And did you try a 64bit specific version of said products? Bob

View Answer   |  June 9, 2007  12:08 AM
Antivirus, Application security, Database, Encryption, Microsoft Systems Management Server, Secure Coding, Servers, Storage, Storage management, Storage products and equipment, Storage servers, Viruses

URGENT!!! file field decoder generated on AS/400
assuming you mean PACKED field First, the “little squares” are the way your application’s display shows an unprintable character (meaning the hex value does not correspond to a known symbol). So somehow, you need to get your application to show you the HEX values for the packed fields. Then it is a matter or reading [...]

View Answer   |  May 22, 2007  9:02 AM
Application development, AS/400, DB2 Universal Database

Select last 3 transactions
are you looking for an SQL statement to embed in RPG? COBOL? JAVA? or for some other SQL based interface?

View Answer   |  May 22, 2007  8:28 AM
Data analysis, Data warehousing applications, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, SQL

Email Validation Software
What exactly are you trying to validate? We do quite a bit of bulk email to student populations, and “a high percentage of blounced emails” is a relative term. It may very well be that your experience with this population is typical/expected.

View Answer   |  May 21, 2007  3:54 PM
AS/400, CRM, Database, DB2, E-business, Ecommerce applications, Email, Exchange, Oracle, Web services

computer protection with revert
If speed is not a key issue, then build your boot environment on a CD, and set the machine to boot from that. Kinkos and other places do something similar with their rental machines – although as I recall, they forcibly re-image their machines every night from a network based standard image. Try googling for [...]

View Answer   |  May 17, 2007  11:53 AM
Application security, configuration, Database, Development, Encryption, Exchange, Instant Messaging, patching, PEN testing, Platform Security, Secure Coding, Security, vulnerability management