Road to become a Security Auditor?
Hi, I am really confused about way to follow to become a Security Auditor… and the opportunities it has in future.. esp. in India ?? Currently I am working as a Security Consultant but dealing only with Security Related products including Firewalls, NMS, IPS etc and not Standards like BS7799, ISO27001, CoBit etc.. Being in [...]

Answer Question   |  February 29, 2012  8:22 AM
CCIE, Certified Information Systems Auditor, CISA, Cisco Certified Internetwork Expert, Information Security Management System, ISMS, IT careers, Security auditing, Security Auditor, Security audits, Security careers

How to match CSV field values in SQL Server 2005
i have an table in sql-server 2005, in which my one field is storing csv values. suppose i have two tables; one is roles and another is users; and multiple role can be assign to one user. so that i have make a fields i.e roles in user table which is keeping the values in [...]

Answer Question   |  March 26, 2009  7:18 AM
CSV, CSV file format, CSV format, SQL Server 2005

Paste from Microsoft Excel cells to Microsoft Access table successfully but…
When I perform a Paste Append into the table, the field I need that is a hyperlink is being truncated, thus link fails. How can I get the link to pates exactly as is from Excel?

Answer Question   |  March 30, 2009  10:51 PM
Hyperlinks, Microsoft Access, Microsoft Access tables, Microsoft Excel

Embedded SQL in an RPG FREE program
I am developing an on-line screen program, where the user can select a view of the data from a list of “views”. This is my first crack at embedded SQL, Basically i issue the Prepare, declar the c1 scroll cursor, and then open c1, and then do the fetch. At this point I am loading [...]

Answer Question   |  March 26, 2009  5:17 PM
Embedded SQL, RPGILE, SQL

Generating ASPX pages from a MYSQL table
I have a series of MYSQl Tables that I want to inspect via a web page, generating the logic to simply display the data is straightforward, however, it’s tedious to create each page then write the logic to make the data editable. Since it’s largely repetition it should be fairly easy for someone to have [...]

Answer Question   |  March 27, 2009  3:04 PM
ASPX, MySQL, VB.NET, Visual Studio

VB6 retrieving MSAccess all records in VB6 ComboBox
Im beginner to VB6 and I have project to buildup company Database, I will be so grateful if anybody could help me in that: “How can I get all records of any field of MSAccess database in ComboBox or ListBox of VB6

Answer Question   |  May 20, 2012  12:03 PM
ComboBox, Microsoft Access, Microsoft Access ComboBox, VB 6, VB 6.0, Visual Basic

FoxPro 2.6 for DOS
when programs (small or large) runs in foxprox 2.6 for DOS the CPU usage showing 100%. how can i solve this problem

Answer Question   |  March 25, 2009  7:23 AM
CPU usage 100%, Database optimization, FoxPro 2.6, FoxPro 2.6 for DOS, FoxPro 2.6 performance

Oracle OLAP degenerate dimension
Hi, How to declare a dimension as degenerate dimension in oracle Analytic workspace manager(AWM) tool? Is there any other tool to achieve this or any manual process involved? Thanks in advance, Vinay

Answer Question   |  March 25, 2009  6:56 AM
Degenerate Dimension, Online Analytical Processing, Oracle Analytic Workspace Manager, Oracle AWM, Oracle OLAP

how can i learn to be a network admin/engineer?
i am getting a degree in network security/telecommunications currently. is school going to teach me everything i know to do a job or it’s just going to give the skills to get it done but how do actually get experience in doing it which is what an employer wants. internships are hard to get as [...]

Answer Question   |  March 30, 2009  8:57 PM
Careers in networking, Information security careers, Information security spending, IT careers, Network administration, Network Administrator, Networking careers

How to use lookup query to return only entries matching the related field of active record
I’m creating a lookup field and would like to list only those items relevant to the record actively using the lookup. So my DB has two tables one using the lookup which as a child ID field that I’d like to match with the parent ID field of another table.

Answer Question   |  March 29, 2009  6:11 PM
Access 2007, Access query, Microsoft Access

COMPARISION OF DBMS AND RDBMS
what is the difference between DBMS and RDBMS

Answer Question   |  March 27, 2009  3:58 PM
Database engineering, DBMS, RDBMS

Advice on Certs and networking career
I was promoted from a tech support position to an entry level NOC Tech position in my company. I don’t have a degree or any certs and I have no experience with networking. Right now I mostly monitor NMS alarms and work tickets. Not really any networking invlolved but networking is where I want to [...]

Answer Question   |  February 14, 2011  3:32 PM
Certifications, Cisco certifications, IT careers, Networking careers, Networking certifications

SQL Data Types Conversions
I’m new to SQL. Anyone have a good example or link of converting from one data type to another. We are converting from an iSeries (AS400) to SQL-based ERP solution and we are having some difficulty with how to get data from numeric fields to date or “numeric” data types. Our iSeries ERP solution had [...]

Answer Question   |  March 24, 2009  2:41 PM
ERP, iSeries, iSeries Data Transfer, SQL, SQL Data Types

Oracle Forms 6i and Oracle 11g database – Multilingual I18N
HI, We have Forms 6i, we are going for Multilingual, and it has Oracle 11g db. We are updating the database with one more column in an exiting table with NVarchar2. The approach we are going for Column level Character set Updates. One more approach is Full Database level Character Set. I try to compile [...]

Answer Question   |  March 25, 2009  6:59 AM
Crystal Reports, Database character set, Database localization, Java, JSP, Localization, Multilingual support, Oracle 10g, Oracle 11g, Oracle character set, Oracle Forms 6i

Numbers of records in flat file without opening it?
Can we find the number of records in the files using the parameters Space used , Space allocated, LRECL, BLKSIZE in mainframe or are any other parameters required. I have to find the no of records without opening the file or even accessing it. Is it possible.

Answer Question   |  March 25, 2009  5:59 AM
BLKSIZE, Flat files, LRECL

How to use Store Procedure for multiple column database update?
I created a store procedure to update a table based on values from another table using inner join. 15 records need to be updated but when the store procedure is executed no rows are updated bu the return value is 0.

Answer Question   |  March 24, 2009  3:28 AM
INNER JOIN, Stored Procedures

How to connect my application using Visual Studio 2005 to a SQL Server database?
how to connect my application using visual studio 2005 to a database using sql server?

Answer Question   |  May 30, 2009  12:27 AM
Database connectivity, Database programming, SQL Server connectivity, SQL Server database, Visual Studio, Visual Studio 2005

tablespace
when does alter Tablespace trackmod yes become active

Answer Question   |  August 3, 2009  3:40 PM
DB2, TABLESPACES

subform
I have one table and a main form and a subform. All fields for these form are in this table. The subform is called from the main form via a command button. When I go to the main form and go to, say record 3, it displays the correct data, but when I use the [...]

Answer Question   |  March 23, 2009  3:46 PM
Microsoft Access, Microsoft Access forms, Microsoft Access subforms

How to create a Microsoft Access form that generates a spreadsheet with parametered values?
Hello, I have a table that has this type of fields (almost 26,000): Cia Type Account Type Call flag Country Client code related main include China 5765 not related auxiliar not include USA 3372 related auxiliar excepted USA 981 related auxiliar include China 789 In access I need to create a Form that using 4 [...]

Answer Question   |  March 23, 2009  10:35 PM
Microsoft Access ComboBox, Microsoft Access forms, Microsoft Access import/export