SQL400 Strip non-numeric from a column
What type of format do you want it in? You might be able to use the strip, replace: SELECT REPLACE(clphone, ‘/’, ‘-’) (field, character being replaced, replace with) FROM Customers You would need to do several of these depending on the characters being changed. If there is a blank and you know the position you [...]
View Answer
| January 16, 2012 6:14 PM
AS/400, non-numeric, SQL/400, Striping
What type of format do you want it in? You might be able to use the strip, replace: SELECT REPLACE(clphone, ‘/’, ‘-’) (field, character being replaced, replace with) FROM Customers You would need to do several of these depending on the characters being changed. If there is a blank and you know the position you [...]
View Answer
| January 16, 2012 6:14 PM
AS/400, non-numeric, SQL/400, Striping
Job got hung and not able to clearing off from the system
The ENDJOBABN cannot be issued until the normal ENDJOB has been running for at least 10 minutes. Then this can take up to an additional 5 minutes to complete. I have not had this happen toi me for many years. When it did, I tried to to end the subssystem and if that does not [...]
View Answer
| January 16, 2012 4:25 PM
AS/400, iSeries, jobs, Subsystems
The ENDJOBABN cannot be issued until the normal ENDJOB has been running for at least 10 minutes. Then this can take up to an additional 5 minutes to complete. I have not had this happen toi me for many years. When it did, I tried to to end the subssystem and if that does not [...]
View Answer
| January 16, 2012 4:25 PM
AS/400, iSeries, jobs, Subsystems
Emailing remittance advices from outlook
You have not provided enough information, but nonetheless, I would recommend you schedule a meeting with the you, the vendor who wrote/maintains the management program, and your software team/systems group to determine the best way to resolve this issue. It is not uncommon for an application to interface with an email application and to have [...]
View Answer
| January 16, 2012 2:49 PM
Outlook 2010
You have not provided enough information, but nonetheless, I would recommend you schedule a meeting with the you, the vendor who wrote/maintains the management program, and your software team/systems group to determine the best way to resolve this issue. It is not uncommon for an application to interface with an email application and to have [...]
View Answer
| January 16, 2012 2:49 PM
Outlook 2010
Why in oracle sql the deleted(uncommited) rows are not visible in current session but visible to other session?
Here’s the link provided in the answer above: <a href=”http://docs.oracle.com/cd/B28359_01/server.111/b28318/consist.htm”>Oracle® Database Concepts – Data Concurrency and Consistency</a>
View Answer
| January 16, 2012 2:37 PM
Oracle
Here’s the link provided in the answer above: <a href=”http://docs.oracle.com/cd/B28359_01/server.111/b28318/consist.htm”>Oracle® Database Concepts – Data Concurrency and Consistency</a>
View Answer
| January 16, 2012 2:37 PM
Oracle
Benefits of Oracle database 10g vs. 11g editions?
I’m unaware of the existence of an 11g express edition. Have a look at the following document to get information on some of the new features/enhancements on 11g: <a href=”http://www.oracle.com/technology/products/database/oracle11g/pdf/database-11g-product-family-technical-whitepaper.pdf”>Oracle Database 11g Product Family</a> (pdf). A major advantage of Oracle11g over 10g is a 25% performance improvement in many SQL queries without any code modifications. [...]
View Answer
| January 16, 2012 2:31 PM
Oracle 10g, Oracle 11g, Oracle Database Versions
I’m unaware of the existence of an 11g express edition. Have a look at the following document to get information on some of the new features/enhancements on 11g: <a href=”http://www.oracle.com/technology/products/database/oracle11g/pdf/database-11g-product-family-technical-whitepaper.pdf”>Oracle Database 11g Product Family</a> (pdf). A major advantage of Oracle11g over 10g is a 25% performance improvement in many SQL queries without any code modifications. [...]
View Answer
| January 16, 2012 2:31 PM
Oracle 10g, Oracle 11g, Oracle Database Versions
ccna salary
I had a wonderful time with doing the CCNA course at NLP Tech for Mind Acceleration. I have recently (last week) completed the course and I can already feel immense improvement in my skills. I was suggested www.nlptechforma.com by a dear friend of mine for the CCNA course. The best thing about NLP Tech for [...]
View Answer
| January 16, 2012 12:30 PM
Networking
I had a wonderful time with doing the CCNA course at NLP Tech for Mind Acceleration. I have recently (last week) completed the course and I can already feel immense improvement in my skills. I was suggested www.nlptechforma.com by a dear friend of mine for the CCNA course. The best thing about NLP Tech for [...]
View Answer
| January 16, 2012 12:30 PM
Networking
iSeries Tool
A disk synchronization tool can do that.. I mean, you specify the source / destination machines. specify your set of libraries and what type of object would you like to synchronize.. and it’ll do the rest. (it will ensure that both libraries are fully matched, including source codes of course). I am not aware of [...]
View Answer
| January 16, 2012 10:10 AM
iSeries, iSeries application development tools, iSeries applications, iSeries data center, iSeries programming commands, iSeries RPG programming
A disk synchronization tool can do that.. I mean, you specify the source / destination machines. specify your set of libraries and what type of object would you like to synchronize.. and it’ll do the rest. (it will ensure that both libraries are fully matched, including source codes of course). I am not aware of [...]
View Answer
| January 16, 2012 10:10 AM
iSeries, iSeries application development tools, iSeries applications, iSeries data center, iSeries programming commands, iSeries RPG programming
Lotus Notes View Formula
Yes, it’s possible going forward, and there are a number of ways to accomplish this. You could write an agent that runs monthly and creates copies of the required documents on a different form and view, or you could make monthly copies of the whole database. Or, you could redesign the existing form in such [...]
View Answer
| January 16, 2012 7:57 AM
Lotus Notes, Lotus Notes 5.x, Lotus Notes View
Yes, it’s possible going forward, and there are a number of ways to accomplish this. You could write an agent that runs monthly and creates copies of the required documents on a different form and view, or you could make monthly copies of the whole database. Or, you could redesign the existing form in such [...]
View Answer
| January 16, 2012 7:57 AM
Lotus Notes, Lotus Notes 5.x, Lotus Notes View
faxing
100%. HIPAA security rules apply to faxing out of EMRs 100% and this comes from my experience working in a health care/services organization, being responsible for EMRs/PHI (Personal Health Information), and confirming with the Chief Information Security Officer and legal counsel of the institution.
View Answer
| January 16, 2012 12:48 AM
EMRs, Fax, Security rule
100%. HIPAA security rules apply to faxing out of EMRs 100% and this comes from my experience working in a health care/services organization, being responsible for EMRs/PHI (Personal Health Information), and confirming with the Chief Information Security Officer and legal counsel of the institution.
View Answer
| January 16, 2012 12:48 AM
EMRs, Fax, Security rule
how to block site by group policy
Use the GPO to add the sites in question to the restricted sites list. This will of course only effect IE, so getting around it is simply a mater of using FireFox or Chrome. Another option would be to add records for those sites to your local DNS servers.
View Answer
| January 15, 2012 5:06 AM
Group Policy Objects
Use the GPO to add the sites in question to the restricted sites list. This will of course only effect IE, so getting around it is simply a mater of using FireFox or Chrome. Another option would be to add records for those sites to your local DNS servers.
View Answer
| January 15, 2012 5:06 AM
Group Policy Objects
Access 2007 DB Project
OK, so first be careful with a database like Access for applications like this. Access doesn’t exactly scale very well as the use of the application grows. 1. Your question doesn’t make a lot of sense. It looks like part of the question got eaten. Please repost that question into the comments. 2. Now, that [...]
View Answer
| January 15, 2012 5:04 AM
Access 2007, Database, SQL
OK, so first be careful with a database like Access for applications like this. Access doesn’t exactly scale very well as the use of the application grows. 1. Your question doesn’t make a lot of sense. It looks like part of the question got eaten. Please repost that question into the comments. 2. Now, that [...]
View Answer
| January 15, 2012 5:04 AM
Access 2007, Database, SQL
Granting systems access in a DR situation
Granting access rights to additional personnel during recovery situations should be addressed in your company’s D/R plan under policies and procedures. The IS security officer should have input into the D/R plan and specify how to handle security during recovery operations.
View Answer
| January 15, 2012 4:03 AM
Disaster Recovery, Open IT Forum, Security
Granting access rights to additional personnel during recovery situations should be addressed in your company’s D/R plan under policies and procedures. The IS security officer should have input into the D/R plan and specify how to handle security during recovery operations.
View Answer
| January 15, 2012 4:03 AM
Disaster Recovery, Open IT Forum, Security
Regression On Large Systems – How To Test
Regression testing is paramount no matter what size the system is! Start by committing resources and time towards establishing a regression testing team/strategy and execute accordingly. There is no excuse for not regression testing and quality issues will invariably occur if overlooked. A little focus will go a long way so start regression testing immediately.
View Answer
| January 15, 2012 3:58 AM
Agile, Agile adoption, Agile testing, Automation Test, Regression
Regression testing is paramount no matter what size the system is! Start by committing resources and time towards establishing a regression testing team/strategy and execute accordingly. There is no excuse for not regression testing and quality issues will invariably occur if overlooked. A little focus will go a long way so start regression testing immediately.
View Answer
| January 15, 2012 3:58 AM
Agile, Agile adoption, Agile testing, Automation Test, Regression
SQL Server Logins
SQL Server 2000 is case insensitive by default due to collation and sort order. You can change collation after setup but it is important to use the correct collation settings and you must rebuild the databases and reload the data. It is also recommended that you develop a standard within your organization for these options [...]
View Answer
| January 15, 2012 1:12 AM
SQL 2000, SQL Logins, SQL Server 2000, SQL Server Password Management, SQL Server Passwords
SQL Server 2000 is case insensitive by default due to collation and sort order. You can change collation after setup but it is important to use the correct collation settings and you must rebuild the databases and reload the data. It is also recommended that you develop a standard within your organization for these options [...]
View Answer
| January 15, 2012 1:12 AM
SQL 2000, SQL Logins, SQL Server 2000, SQL Server Password Management, SQL Server Passwords
Exporting a (.csv) file from SQL 2005
welcome to: http://www.plzzshop.com The website wholesale for many kinds of fashion shoes, like the nike,jordan,prada,****, also including the jeans,shirts,bags,hat and the decorations. All the products are free shipping, and the the price is competitive, and also can accept the paypal payment.,after the payment, can ship within short time. free shipping competitive price any size available [...]
View Answer
| January 14, 2012 2:57 AM
CSV, SQL
welcome to: http://www.plzzshop.com The website wholesale for many kinds of fashion shoes, like the nike,jordan,prada,****, also including the jeans,shirts,bags,hat and the decorations. All the products are free shipping, and the the price is competitive, and also can accept the paypal payment.,after the payment, can ship within short time. free shipping competitive price any size available [...]
View Answer
| January 14, 2012 2:57 AM
CSV, SQL
Vb Script to get the selected(focussed) file names in a windows folder.
http://www.go4expert.com/forums/showthread.php?t=927 gives an example on reading a directory. I added the array part of it and commented out the write part of it. I write in vb but I’m not an expert in it so no promises. I prefer perl. I’m sure somebody else will chime in with another example. Here’s the code I ended [...]
View Answer
| January 13, 2012 9:16 PM
VB script
http://www.go4expert.com/forums/showthread.php?t=927 gives an example on reading a directory. I added the array part of it and commented out the write part of it. I write in vb but I’m not an expert in it so no promises. I prefer perl. I’m sure somebody else will chime in with another example. Here’s the code I ended [...]
View Answer
| January 13, 2012 9:16 PM
VB script
Crystal Reports XI period in database name
We ran into the same problem and the only fix we could find was to recreate the database without the “.’ In the name. It is a bad DBA practice to use special characters in the database name. The best solution would be to rename the database. You don’t need to delete and then create [...]
View Answer
| January 13, 2012 8:27 PM
Crystal Reports, Crystal Reports XI, SQL Server 2005, SQL Server 2005 Database
We ran into the same problem and the only fix we could find was to recreate the database without the “.’ In the name. It is a bad DBA practice to use special characters in the database name. The best solution would be to rename the database. You don’t need to delete and then create [...]
View Answer
| January 13, 2012 8:27 PM
Crystal Reports, Crystal Reports XI, SQL Server 2005, SQL Server 2005 Database
Single Page subfile
Try these links: http://books.google.com/books?id=EPQHQgAACAAJ&source=gbs_similarbooks http://www.lmgtfy.com/?q=how+to+write+subfiles+in+rpgle
View Answer
| January 13, 2012 4:33 PM
AS400 Subfile
Try these links: http://books.google.com/books?id=EPQHQgAACAAJ&source=gbs_similarbooks http://www.lmgtfy.com/?q=how+to+write+subfiles+in+rpgle
View Answer
| January 13, 2012 4:33 PM
AS400 Subfile
Creating DB of stories from documents for a website
I would recommend the Open Source Drupal content management (www.drupal.org) platform to create a searchable fanfiction database/website as all content is stored and searchable in the database which can be MySQL, Oracle, or SQL Server.
View Answer
| January 13, 2012 7:16 AM
Access Database, Access Database Design, Database design, Database Development, Database issues, Web development, Web development tools
I would recommend the Open Source Drupal content management (www.drupal.org) platform to create a searchable fanfiction database/website as all content is stored and searchable in the database which can be MySQL, Oracle, or SQL Server.
View Answer
| January 13, 2012 7:16 AM
Access Database, Access Database Design, Database design, Database Development, Database issues, Web development, Web development tools
Capacitation
To get started in SAP you should consider SAP training and certification, combined with contracting/consulting opportunities assuming you work somewhere that does not run SAP, and if your current employer uses SAP you should offer to assist after you complete your training and certification. More information about SAP training and certification can be found at [...]
View Answer
| January 13, 2012 6:55 AM
Learnig SAP
To get started in SAP you should consider SAP training and certification, combined with contracting/consulting opportunities assuming you work somewhere that does not run SAP, and if your current employer uses SAP you should offer to assist after you complete your training and certification. More information about SAP training and certification can be found at [...]
View Answer
| January 13, 2012 6:55 AM
Learnig SAP
