Free IT Book: CompTIA Security+ Certification Passport
This week’s free IT book is Mike Meyers’ CompTIA Security+ Certification Passport: Revised for the new CompTIA Security+ exam (SY0-301). The new edition provides a condensed and concise review of CompTIA’s well-established security credential. For a chance to win this quick review, cram-style test preparation guide that offers 100% coverage of all exam objectives for [...]
Answer Question
| September 16, 2011 8:37 PM
AS/400, Business Intelligence, Channel, CIO, CompTIA, CompTIA Security+, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
This week’s free IT book is Mike Meyers’ CompTIA Security+ Certification Passport: Revised for the new CompTIA Security+ exam (SY0-301). The new edition provides a condensed and concise review of CompTIA’s well-established security credential. For a chance to win this quick review, cram-style test preparation guide that offers 100% coverage of all exam objectives for [...]
Answer Question
| September 16, 2011 8:37 PM
AS/400, Business Intelligence, Channel, CIO, CompTIA, CompTIA Security+, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
System tables in SQL Server
How to view System tables in drop down menu of a database in SQL SERVER 2005
Answer Question
| June 23, 2011 12:43 PM
Database, SQL 2005, SQL Server 2005, System tables
How to view System tables in drop down menu of a database in SQL SERVER 2005
Answer Question
| June 23, 2011 12:43 PM
Database, SQL 2005, SQL Server 2005, System tables
How to call a shell script from ABAP program?
This question is to SANDEEP KULKARNI. If he is still with this website then please respond to this question, if not, requesting other users to provide real time solution. Also, requesting this forum owner to pass the SANDEEP KULKARNI’s email ID/contact number. Question is: I have a shell script written for moving the flat file [...]
Answer Question
| August 30, 2011 8:44 PM
ABAP, Flat files, FTP Server, Linux, Shell scripts
This question is to SANDEEP KULKARNI. If he is still with this website then please respond to this question, if not, requesting other users to provide real time solution. Also, requesting this forum owner to pass the SANDEEP KULKARNI’s email ID/contact number. Question is: I have a shell script written for moving the flat file [...]
Answer Question
| August 30, 2011 8:44 PM
ABAP, Flat files, FTP Server, Linux, Shell scripts
Creating a view from an external database
I am working with Domino designer 8.5 () and have a form that contains a field of type ‘Names’ that has the Choices set to ‘Use View dialog for choices’ (as there are a lot of entries to choice from I choice the view dialog to allow sorting and searching). The view that I use [...]
Answer Question
| June 27, 2011 1:33 PM
Database Views, Domino Designer 8.5, Lotus Domino
I am working with Domino designer 8.5 () and have a form that contains a field of type ‘Names’ that has the Choices set to ‘Use View dialog for choices’ (as there are a lot of entries to choice from I choice the view dialog to allow sorting and searching). The view that I use [...]
Answer Question
| June 27, 2011 1:33 PM
Database Views, Domino Designer 8.5, Lotus Domino
Free IT Book: Securing SQL Server
This week’s free IT book is written by one of IT Knowledge Exchange’s very own members, Mrdenny. Securing SQL Server promises to help you “secure your SQL Server database so the outside world can’t access your internal data.” With Mrdenny’s extended experience in simplifying SQL speak via his blog, SQL Server with Mr. Denny, this [...]
Answer Question
| June 24, 2011 7:56 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
This week’s free IT book is written by one of IT Knowledge Exchange’s very own members, Mrdenny. Securing SQL Server promises to help you “secure your SQL Server database so the outside world can’t access your internal data.” With Mrdenny’s extended experience in simplifying SQL speak via his blog, SQL Server with Mr. Denny, this [...]
Answer Question
| June 24, 2011 7:56 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Open IT Forum: Are you on hacking offense or defense?
Sony isn”t the only company getting hit hard by hackers. Sega just joined the bunch, and Lockheed Martin’s breach is still fresh. How does your company set up a strong offense against hacks and breaches? Or, if your company’s security has been compromised in the past, how did you respond and set up a sufficient [...]
Answer Question
| June 29, 2011 7:52 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, Sony, Sony PlayStation Network breach, SQL Server, Storage, Virtualization, VoIP, Windows Server
Sony isn”t the only company getting hit hard by hackers. Sega just joined the bunch, and Lockheed Martin’s breach is still fresh. How does your company set up a strong offense against hacks and breaches? Or, if your company’s security has been compromised in the past, how did you respond and set up a sufficient [...]
Answer Question
| June 29, 2011 7:52 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, Sony, Sony PlayStation Network breach, SQL Server, Storage, Virtualization, VoIP, Windows Server
RPGLE Embedded SQL Not null
RPGLE Embedded SQL is getting a SQL0305 (SQLcid-305, sqlstate 22002) when fetching the next record from a view. This is pointing to null values encountered. /free exec sql fetch next from C1 into :wtclaims ; /end-free Wtclaims is an Externally Described Data structure. There could be null values in any field in the ds over [...]
Answer Question
| June 24, 2011 3:33 PM
AS/400, Embedded SQL, RPGLE, SQL
RPGLE Embedded SQL is getting a SQL0305 (SQLcid-305, sqlstate 22002) when fetching the next record from a view. This is pointing to null values encountered. /free exec sql fetch next from C1 into :wtclaims ; /end-free Wtclaims is an Externally Described Data structure. There could be null values in any field in the ds over [...]
Answer Question
| June 24, 2011 3:33 PM
AS/400, Embedded SQL, RPGLE, SQL
FAQ Database
how do you build a FAQ database using Microsoft Access?
Answer Question
| June 29, 2011 2:14 PM
Access, Access Database, FAQ
how do you build a FAQ database using Microsoft Access?
Answer Question
| June 29, 2011 2:14 PM
Access, Access Database, FAQ
Access Database Splitting
I just split a database because there are multiple people using it and we started having problems with people not able to get into the database while someone else was in it. I moved all the tables to the back-end and created links to the tables in the front-end. After doing this we tested out. [...]
Answer Question
| June 20, 2011 8:07 PM
Access 2007, Access Database, Access Database Design
I just split a database because there are multiple people using it and we started having problems with people not able to get into the database while someone else was in it. I moved all the tables to the back-end and created links to the tables in the front-end. After doing this we tested out. [...]
Answer Question
| June 20, 2011 8:07 PM
Access 2007, Access Database, Access Database Design
Access 2010 database query
I am new to Access and am having some trouble writing a query, for an absentee database. I only have two tables, one for the roster and the other with the absentee logs. The Roster table only has employee name, badge number, and shift. The Attendance Log table has the date of occurrence, the employee [...]
Answer Question
| June 16, 2011 5:11 PM
Access 2010, Access Database, Access Database Attachments, Access query
I am new to Access and am having some trouble writing a query, for an absentee database. I only have two tables, one for the roster and the other with the absentee logs. The Roster table only has employee name, badge number, and shift. The Attendance Log table has the date of occurrence, the employee [...]
Answer Question
| June 16, 2011 5:11 PM
Access 2010, Access Database, Access Database Attachments, Access query
Connects the oracle from java applets
if any necessary to install thin driver for connect to the oracle database from an applet. But my applet and oracle running on the same host…I face difficult problems when i connecct the database from an applet.Pls help me…..
Answer Question
| June 15, 2011 10:38 AM
Database connectivity, Java applets, Oracle connectivity, Oracle Database
if any necessary to install thin driver for connect to the oracle database from an applet. But my applet and oracle running on the same host…I face difficult problems when i connecct the database from an applet.Pls help me…..
Answer Question
| June 15, 2011 10:38 AM
Database connectivity, Java applets, Oracle connectivity, Oracle Database
Open IT Forum: What tech blogs and Twitter feeds do you follow?
Each month, we cast the net asking what [Insert tech topic here] Twitter feeds and blogs you read, but this month is a free for all! We want to know any and all tech blogs or Twitter feeds you trust, admire, and follow religiously. We want links and we’d love to hear why you love [...]
Answer Question
| March 7, 2012 7:36 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, IT Blogs, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
Each month, we cast the net asking what [Insert tech topic here] Twitter feeds and blogs you read, but this month is a free for all! We want to know any and all tech blogs or Twitter feeds you trust, admire, and follow religiously. We want links and we’d love to hear why you love [...]
Answer Question
| March 7, 2012 7:36 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, IT Blogs, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
Free IT Book: Achieving Extreme Performance with Oracle Exadata
This week you could win a copy of Achieving Extreme Performance with Oracle Exadata from Oracle Press. Chock full of best practices for Oracle Exadata Database Machine deployment and maintenance, this resource covers data warehousing, transaction processing, consolidation strategies, maximum availability, and backup and recovery. To win, simply answer one of five questions and post [...]
Answer Question
| June 21, 2011 5:55 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exadata Database Machine, Exchange, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
This week you could win a copy of Achieving Extreme Performance with Oracle Exadata from Oracle Press. Chock full of best practices for Oracle Exadata Database Machine deployment and maintenance, this resource covers data warehousing, transaction processing, consolidation strategies, maximum availability, and backup and recovery. To win, simply answer one of five questions and post [...]
Answer Question
| June 21, 2011 5:55 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exadata Database Machine, Exchange, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Embedded SQL using SUM or some other method to total up qty and display 1 unique record
I have an sqlrpgle pgm setup, I want to add another sql select statement. I have a file that contains barcode label data, where multiple records can be assigned to the same Master serial #. My sqlrpg pgm is display various sorts in a screen inquiry. I want to setup my select, to display one [...]
Answer Question
| June 10, 2011 11:30 AM
Embedded SQL, SQL, SQL Select, SQL Select statement problem, SQLRPG
I have an sqlrpgle pgm setup, I want to add another sql select statement. I have a file that contains barcode label data, where multiple records can be assigned to the same Master serial #. My sqlrpg pgm is display various sorts in a screen inquiry. I want to setup my select, to display one [...]
Answer Question
| June 10, 2011 11:30 AM
Embedded SQL, SQL, SQL Select, SQL Select statement problem, SQLRPG
Announcing the Symantec Endpoint Protection 12 Scavenger Hunt (sponsored)
Want the chance to win an iPad 2 or Amazon.com gift cards? The Symantec Endpoint Protection 12 Scavenger Hunt is your opportunity to learn about all of the new features of Symantec Endpoint Protection 12 while getting in the running to earn great prizes. Think you know about all of the new features of Symantec [...]
Answer Question
| June 8, 2011 3:49 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Scavenger Hunt, Security, SQL Server, Storage, Symantec Endpoint Protection 12, Virtualization, VoIP, Windows Server
Want the chance to win an iPad 2 or Amazon.com gift cards? The Symantec Endpoint Protection 12 Scavenger Hunt is your opportunity to learn about all of the new features of Symantec Endpoint Protection 12 while getting in the running to earn great prizes. Think you know about all of the new features of Symantec [...]
Answer Question
| June 8, 2011 3:49 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Scavenger Hunt, Security, SQL Server, Storage, Symantec Endpoint Protection 12, Virtualization, VoIP, Windows Server
Cloning C and G drives on Windows Server 2008
I need to clone my C drive and G drive on a Windows server 2008. The C drive is a mirror and the G drive is a 6 disk raid 5. What is my best option for cloning this setup?
Answer Question
| October 21, 2011 6:11 PM
C drive, Clone database, RAID 5, Windows Server 2008
I need to clone my C drive and G drive on a Windows server 2008. The C drive is a mirror and the G drive is a 6 disk raid 5. What is my best option for cloning this setup?
Answer Question
| October 21, 2011 6:11 PM
C drive, Clone database, RAID 5, Windows Server 2008
Dell PowerEdge 6800 drives in array corrupted
We have a used Dell Power Edge 6800. The two drives in array 0 (the mirrored boot drives) keep getting corrupted. I tried different drives and the same issue. The drives are fine in other slots. Can this be a chassis issue?
Answer Question
| June 9, 2011 5:27 PM
Arrays, Corrupt Database, Dell PowerEdge, Dell PowerEdge Performance
We have a used Dell Power Edge 6800. The two drives in array 0 (the mirrored boot drives) keep getting corrupted. I tried different drives and the same issue. The drives are fine in other slots. Can this be a chassis issue?
Answer Question
| June 9, 2011 5:27 PM
Arrays, Corrupt Database, Dell PowerEdge, Dell PowerEdge Performance
Free IT Book: The Data Warehouse Mentor
The Data Warehouse Mentor by Robert Laberge will show you how to plan, design, construct, and administer an integrated end-to-end DW/BI solution. He’ll explain how to choose appropriate components, build an enterprise data model, configure data marts and data warehouses, establish data flow, and mitigate risk. Change management, data governance, and security are also covered [...]
Answer Question
| June 8, 2011 12:43 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
The Data Warehouse Mentor by Robert Laberge will show you how to plan, design, construct, and administer an integrated end-to-end DW/BI solution. He’ll explain how to choose appropriate components, build an enterprise data model, configure data marts and data warehouses, establish data flow, and mitigate risk. Change management, data governance, and security are also covered [...]
Answer Question
| June 8, 2011 12:43 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Restoring a backup from Brightstor 12 server
Can we restore a backup from a Brightstor 12 server without the database? What would be the procedure for that?
Answer Question
| June 7, 2011 2:29 PM
Backup, BrightStor, BrightStor ARCserve Backup 12, Database Backup, Database backup and recovery
Can we restore a backup from a Brightstor 12 server without the database? What would be the procedure for that?
Answer Question
| June 7, 2011 2:29 PM
Backup, BrightStor, BrightStor ARCserve Backup 12, Database Backup, Database backup and recovery
AS/400 tab text delimited format of physical file
Hi , Using i series utility you can download PF as Text Tab Delimited format in your PC.However when I do the same by CLP using CPYTOIMPF using FLDDLM as X’05′ or *tab , I get a text tab delimited file which is not completely same as the file downloaded using I series utility.
Answer Question
| June 17, 2011 6:06 AM
AS/400, AS/400 Database File, CLP, CPYTOIMPF, Database Files, DBF file
Hi , Using i series utility you can download PF as Text Tab Delimited format in your PC.However when I do the same by CLP using CPYTOIMPF using FLDDLM as X’05′ or *tab , I get a text tab delimited file which is not completely same as the file downloaded using I series utility.
Answer Question
| June 17, 2011 6:06 AM
AS/400, AS/400 Database File, CLP, CPYTOIMPF, Database Files, DBF file
