Need to know equipment needed to setup a simple network to share DB
Hi there, In order to create a small network that will allow 12 computers to communicate you be glad to know you actually need very little equipment. You have 2 directions you can go in though so first thing is you have to make decision!! I will give you some options for both though so [...]
View Answer
| May 6, 2010 11:41 AM
Database connectivity, Network design, Network equipment, network setup, routers and switches
Hi there, In order to create a small network that will allow 12 computers to communicate you be glad to know you actually need very little equipment. You have 2 directions you can go in though so first thing is you have to make decision!! I will give you some options for both though so [...]
View Answer
| May 6, 2010 11:41 AM
Database connectivity, Network design, Network equipment, network setup, routers and switches
New Member contest: Win a free iPad
5/5/2010: Not too many changes to the list, but it’s not too late to earn more points. TomLiotta Carlosdl Aguacer0 Technochic Mrdenny Mshen Jim4522 ToddN2000 Splat RichS Boost your total now with an extra 200 Knowledge Points just for entering the <a href=”http://itknowledgeexchange.techtarget.com/intel-open-port-scavenger-hunt/”>Intel Open Port Scavenger Hunt.</a>. Then earn an extra 100 Knowledge Points by [...]
View Answer
| May 5, 2010 6:05 PM
Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Notes, Mobile, Network connectivity, Oracle, SAP, Security, SQL Server, VMware, VoIP, Windows
5/5/2010: Not too many changes to the list, but it’s not too late to earn more points. TomLiotta Carlosdl Aguacer0 Technochic Mrdenny Mshen Jim4522 ToddN2000 Splat RichS Boost your total now with an extra 200 Knowledge Points just for entering the <a href=”http://itknowledgeexchange.techtarget.com/intel-open-port-scavenger-hunt/”>Intel Open Port Scavenger Hunt.</a>. Then earn an extra 100 Knowledge Points by [...]
View Answer
| May 5, 2010 6:05 PM
Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Notes, Mobile, Network connectivity, Oracle, SAP, Security, SQL Server, VMware, VoIP, Windows
How to learn DB2?
IBM has a free DB2 for just this sort of thing – it is called DB2 Express. Check the IBM web site WWW.IBM.COM and search within it for DB2 Express. Depending on what you want to learn about DB2, this may or may not be what you are after. A product will only go so [...]
View Answer
| May 4, 2010 7:57 PM
DB2, DB2 administration, DB2 certification
IBM has a free DB2 for just this sort of thing – it is called DB2 Express. Check the IBM web site WWW.IBM.COM and search within it for DB2 Express. Depending on what you want to learn about DB2, this may or may not be what you are after. A product will only go so [...]
View Answer
| May 4, 2010 7:57 PM
DB2, DB2 administration, DB2 certification
Auto Replace Text in a table
That would be the <a href=”http://www.techonthenet.com/access/functions/string/replace.php”>Replace Function</a> If you want to use it in a SQL UPDATE command, it would be something like this: <pre>UPDATE your_table SET your_field = REPLACE(your_field,”NORTH”,”BILLY BOB”) WHERE <conditions></pre> —————–
View Answer
| May 4, 2010 6:42 PM
IIF statement, REPLACE, tables
That would be the <a href=”http://www.techonthenet.com/access/functions/string/replace.php”>Replace Function</a> If you want to use it in a SQL UPDATE command, it would be something like this: <pre>UPDATE your_table SET your_field = REPLACE(your_field,”NORTH”,”BILLY BOB”) WHERE <conditions></pre> —————–
View Answer
| May 4, 2010 6:42 PM
IIF statement, REPLACE, tables
Fetch to datastructure in RPG/400
Hi, This should only retrieve one record into your data structure (your data structure is defined as single occurrence, so cannot contain more than one record worth of data anyway), but you should specify first, next or last on your FETCH to be sure of which record the fetch will retrieve. Regards, Martin Gilbert. ======================================================== [...]
View Answer
| May 4, 2010 7:20 AM
C+, Data structures, RPG, RPG/400
Hi, This should only retrieve one record into your data structure (your data structure is defined as single occurrence, so cannot contain more than one record worth of data anyway), but you should specify first, next or last on your FETCH to be sure of which record the fetch will retrieve. Regards, Martin Gilbert. ======================================================== [...]
View Answer
| May 4, 2010 7:20 AM
C+, Data structures, RPG, RPG/400
About MCTS 70-432 exam
Granted I’m biased towards <a href=”http://www.amazon.com/Real-MCTS-Server-2008-70-432/dp/1597494208/ref=ntt_at_ep_dpt_1″>this book</a>, but I’d recommend that you give it a shot. I’m biased as I was one of the authors of the book.
View Answer
| May 4, 2010 7:15 AM
IT careers, IT training, IT training and certifications, SQL Server
Granted I’m biased towards <a href=”http://www.amazon.com/Real-MCTS-Server-2008-70-432/dp/1597494208/ref=ntt_at_ep_dpt_1″>this book</a>, but I’d recommend that you give it a shot. I’m biased as I was one of the authors of the book.
View Answer
| May 4, 2010 7:15 AM
IT careers, IT training, IT training and certifications, SQL Server
Role of Excel/Access in SQL Server 2008 R2
PowerPivot for Excel is an free Excel Add-in that allows you to easily access data from diverse data sources, easily mashup data within Excel, process large volumes of data (millions to hundreds of millions of rows), use native Excel capabilities to analyze the data. With PowerPivot for SharePoint – which requires SQL Server 2008 R2 [...]
View Answer
| May 4, 2010 6:43 AM
Microsoft Access, Microsoft Excel, SQL Server 2008 R2
PowerPivot for Excel is an free Excel Add-in that allows you to easily access data from diverse data sources, easily mashup data within Excel, process large volumes of data (millions to hundreds of millions of rows), use native Excel capabilities to analyze the data. With PowerPivot for SharePoint – which requires SQL Server 2008 R2 [...]
View Answer
| May 4, 2010 6:43 AM
Microsoft Access, Microsoft Excel, SQL Server 2008 R2
Do Businesses still need SQL Server?
SQL Server 2008 and SQL Server 2008 R2 with both Enterprise Edition and the new DataCenter Edition has focused on meeting the needs for Enterprise customers to run their mission critical applications…greater scalability, Resource Governor, Enhanced Data Compression – including Unicode compression delivered in R2, Transparent Data Encryption, single system scale – taking advantage of [...]
View Answer
| May 3, 2010 9:45 PM
MySQL, SQL Server 2008 R2
SQL Server 2008 and SQL Server 2008 R2 with both Enterprise Edition and the new DataCenter Edition has focused on meeting the needs for Enterprise customers to run their mission critical applications…greater scalability, Resource Governor, Enhanced Data Compression – including Unicode compression delivered in R2, Transparent Data Encryption, single system scale – taking advantage of [...]
View Answer
| May 3, 2010 9:45 PM
MySQL, SQL Server 2008 R2
is there any way to know the jobs which are using a particular job description?
This is tricky since jobs don’t actually use job descriptions (*JOBDs). They are used by users to tell Work Management how to set up an environment for a job to run under. Once the environment is set, the *JOBD is no longer important. That’s why you can change a *JOBD attribute after a job starts [...]
View Answer
| May 3, 2010 2:17 PM
IT careers, Job Description
This is tricky since jobs don’t actually use job descriptions (*JOBDs). They are used by users to tell Work Management how to set up an environment for a job to run under. Once the environment is set, the *JOBD is no longer important. That’s why you can change a *JOBD attribute after a job starts [...]
View Answer
| May 3, 2010 2:17 PM
IT careers, Job Description
Print User Permissions
You can print a list of users and/or groups by clicking on Tools/Security/User and Group Accounts. That opens a window with a “Print Users and Groups” button. I don’t see any way to print the rights granted to each group. Changing my answer: Under Tools/Analyze/Documenter, you get a window where you can choose various componenets [...]
View Answer
| April 30, 2010 5:18 PM
Access 2003, Security protocols, User Permissions
You can print a list of users and/or groups by clicking on Tools/Security/User and Group Accounts. That opens a window with a “Print Users and Groups” button. I don’t see any way to print the rights granted to each group. Changing my answer: Under Tools/Analyze/Documenter, you get a window where you can choose various componenets [...]
View Answer
| April 30, 2010 5:18 PM
Access 2003, Security protocols, User Permissions
MDE files
Converting the file to MDE will prevent users from altering database objects (design), but not from modifying data. If you want to restrict what users can do with the data, you could use user-level security. Note that user-level security is not available in databases that use some of the new file formats (for example .accdb) [...]
View Answer
| April 27, 2010 11:34 PM
.MDE files, Access 2003, MDBDATA, Microsoft Access 2003 permissions
Converting the file to MDE will prevent users from altering database objects (design), but not from modifying data. If you want to restrict what users can do with the data, you could use user-level security. Note that user-level security is not available in databases that use some of the new file formats (for example .accdb) [...]
View Answer
| April 27, 2010 11:34 PM
.MDE files, Access 2003, MDBDATA, Microsoft Access 2003 permissions
Access form -updating details for Not in list
In design mode chosse the field you have in question. In the propert sheet chose “Not in List” and chosse “Event procedure”. Then click on the “…”. Enter the following code. “Dim iAnswer As Integer iAnswer = MsgBox(“WHAT IS NOT IN THE FILE. Add (Yes/No)”, vbYesNo + vbQuestion) If iAnswer = vbYes Then DoCmd.OpenForm “KEY [...]
View Answer
| April 26, 2010 5:49 PM
Microsoft Access, MS Access 2007
In design mode chosse the field you have in question. In the propert sheet chose “Not in List” and chosse “Event procedure”. Then click on the “…”. Enter the following code. “Dim iAnswer As Integer iAnswer = MsgBox(“WHAT IS NOT IN THE FILE. Add (Yes/No)”, vbYesNo + vbQuestion) If iAnswer = vbYes Then DoCmd.OpenForm “KEY [...]
View Answer
| April 26, 2010 5:49 PM
Microsoft Access, MS Access 2007
Storing array values into an Access database table from a program
First, this syntax: <pre>INSERT INTO <table name> FROM ARRAY <array name></pre> Is not standard SQL, and it would only work (I think) on Visual Fox, and I guess this is Visual Basic (you didn’t mention the language being used). Second, to use this constructor of the OleDbDataAdapter class you have to use a SELECT statement. [...]
View Answer
| April 26, 2010 2:52 PM
Array, Database, MS Access, MS Visual Studio 2005, SQL
First, this syntax: <pre>INSERT INTO <table name> FROM ARRAY <array name></pre> Is not standard SQL, and it would only work (I think) on Visual Fox, and I guess this is Visual Basic (you didn’t mention the language being used). Second, to use this constructor of the OleDbDataAdapter class you have to use a SELECT statement. [...]
View Answer
| April 26, 2010 2:52 PM
Array, Database, MS Access, MS Visual Studio 2005, SQL
Packed fields in Flat Files
Hi John, Simple method is to create another (physical) file with the same fields, but with non-packed decimals and do a CPYF with FMTOPT(*MAP *DROP). This should give you a copy of the file without packed fields. Regards, Martin Gilbert. =========================================================== <i>How can I see the contents of a packed field in a flat file?</i> [...]
View Answer
| April 24, 2010 9:20 PM
AS/400, Flat files, OS/400
Hi John, Simple method is to create another (physical) file with the same fields, but with non-packed decimals and do a CPYF with FMTOPT(*MAP *DROP). This should give you a copy of the file without packed fields. Regards, Martin Gilbert. =========================================================== <i>How can I see the contents of a packed field in a flat file?</i> [...]
View Answer
| April 24, 2010 9:20 PM
AS/400, Flat files, OS/400
Creating a database in Access 2007
I think you are confused a little. Database basics. Tables are a collection of similar information, which are the building blocks for a simple, or complex database. Templates are used to define a way to collect, store and display the information. Access has several template databases, which are freely available. ( So, by definition, templates [...]
View Answer
| April 24, 2010 11:29 AM
Access 2007, Access Database, CREATE DATABASE statement
I think you are confused a little. Database basics. Tables are a collection of similar information, which are the building blocks for a simple, or complex database. Templates are used to define a way to collect, store and display the information. Access has several template databases, which are freely available. ( So, by definition, templates [...]
View Answer
| April 24, 2010 11:29 AM
Access 2007, Access Database, CREATE DATABASE statement
How to save data back to databse from radio button? SQL Server 2005
The question is not clear enough. In summary, you would have to: -Import the SqlClient namespace: <pre>Imports System.Data.SqlClient</pre> -Connect to the database: <pre> Dim conn As SqlConnection Dim command As SqlCommand conn.ConnectionString = “Data Source=<your_database_server>;Initial Catalog=<your_database>;User ID=<your_user>;Password=<your_password>” conn.Open() </pre> -Execute an insert command: <pre> command.CommandText = “INSERT INTO <your_table> VALUES (<your,values>)” command.Connection = conn iRowsAffected [...]
View Answer
| April 23, 2010 9:41 PM
ASP.NET, Database issues, SQL Server 2005
The question is not clear enough. In summary, you would have to: -Import the SqlClient namespace: <pre>Imports System.Data.SqlClient</pre> -Connect to the database: <pre> Dim conn As SqlConnection Dim command As SqlCommand conn.ConnectionString = “Data Source=<your_database_server>;Initial Catalog=<your_database>;User ID=<your_user>;Password=<your_password>” conn.Open() </pre> -Execute an insert command: <pre> command.CommandText = “INSERT INTO <your_table> VALUES (<your,values>)” command.Connection = conn iRowsAffected [...]
View Answer
| April 23, 2010 9:41 PM
ASP.NET, Database issues, SQL Server 2005
Database Last modified.
Check the drive on which the data bases are located. Change the view to details and you will see the last modified date and time.
View Answer
| April 23, 2010 6:48 PM
Database Last modified., Database management, Last modified
Check the drive on which the data bases are located. Change the view to details and you will see the last modified date and time.
View Answer
| April 23, 2010 6:48 PM
Database Last modified., Database management, Last modified
Remove Q in Microsoft Access
I think you will need to do this using a text field, because a numeric one will probably cause an error before trying to remove the ‘Q’. I hope someone else provides a better solution, but meanwhile… You could use an unbound text field and in the ‘AfterUpdate’ event remove the ‘Q’ and assign the [...]
View Answer
| April 22, 2010 11:30 PM
Microsoft Access, Microsoft Access forms
I think you will need to do this using a text field, because a numeric one will probably cause an error before trying to remove the ‘Q’. I hope someone else provides a better solution, but meanwhile… You could use an unbound text field and in the ‘AfterUpdate’ event remove the ‘Q’ and assign the [...]
View Answer
| April 22, 2010 11:30 PM
Microsoft Access, Microsoft Access forms
SQL Join on multiple columns?
Yes, you can. You have it coded correctly by just using the AND. Here is a sample of my code: This is in a source member as I try to use RUNSQLSTM. That way I can make modifications without having to recompile programs. ==== INSERT INTO CUBRANCH (CUNO, ORGBRN, ORGNAM, BRNAME, USRPRF) SELECT ’1379′, t.ORGBRN, [...]
View Answer
| April 22, 2010 7:48 PM
AS/400, JOIN statement, SQL
Yes, you can. You have it coded correctly by just using the AND. Here is a sample of my code: This is in a source member as I try to use RUNSQLSTM. That way I can make modifications without having to recompile programs. ==== INSERT INTO CUBRANCH (CUNO, ORGBRN, ORGNAM, BRNAME, USRPRF) SELECT ’1379′, t.ORGBRN, [...]
View Answer
| April 22, 2010 7:48 PM
AS/400, JOIN statement, SQL
Joining More Than 2 Files
Hello <a href=”http://itknowledgeexchange.techtarget.com/itanswers/embedded-sql-in-sqlrpgle-using-join-on-multiple-files/”>someone already answered </a>to this question in the past. Bye ====================================================== Unfortunately, that other answer doesn’t answer the question that is asked here. There is no “best” way to do it. It always depends on what’s in the files, what you plan on selecting by (WHERE) and what you have available to join [...]
View Answer
| April 22, 2010 7:04 AM
Embedded SQL, SQLRPGLE
Hello <a href=”http://itknowledgeexchange.techtarget.com/itanswers/embedded-sql-in-sqlrpgle-using-join-on-multiple-files/”>someone already answered </a>to this question in the past. Bye ====================================================== Unfortunately, that other answer doesn’t answer the question that is asked here. There is no “best” way to do it. It always depends on what’s in the files, what you plan on selecting by (WHERE) and what you have available to join [...]
View Answer
| April 22, 2010 7:04 AM
Embedded SQL, SQLRPGLE
