Business Analysis and Project Management Documents
I get a lot of my information and templates from Tech Republic. There website is www.TechRepublic.com. I really like the IT Policies and Procedures information. Hope this helps.
View Answer
| October 27, 2004 9:07 AM
Business/IT alignment, Data analysis, Development, IT architecture, Project management, Software testing
I get a lot of my information and templates from Tech Republic. There website is www.TechRepublic.com. I really like the IT Policies and Procedures information. Hope this helps.
View Answer
| October 27, 2004 9:07 AM
Business/IT alignment, Data analysis, Development, IT architecture, Project management, Software testing
Inhibit Close Button (x) on IE6 Browser
I can’t imagine such a thing. Can you imagine if there was, how the advertisers would love it. I would ‘cache’ the transaction instructions in state until the final go.
View Answer
| October 27, 2004 7:48 AM
VB.NET
I can’t imagine such a thing. Can you imagine if there was, how the advertisers would love it. I would ‘cache’ the transaction instructions in state until the final go.
View Answer
| October 27, 2004 7:48 AM
VB.NET
Easy XML editing and creating?
This article will show you how to create a form and transfer the data to xml http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=199
View Answer
| October 26, 2004 5:36 PM
XML
This article will show you how to create a form and transfer the data to xml http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=199
View Answer
| October 26, 2004 5:36 PM
XML
How do I check for changes in a database on insert / update?
Please provide more detail about how updates will be handled to the database so I can give you a better answer. For example, what is the threshold for accuracy? If you want 100% accuracy you must check each field in each row 1-by-1. If there is a “low” risk that other applications would modify the [...]
View Answer
| October 26, 2004 5:11 PM
Microsoft Access, SQL Server, VB.NET, Visual Basic
Please provide more detail about how updates will be handled to the database so I can give you a better answer. For example, what is the threshold for accuracy? If you want 100% accuracy you must check each field in each row 1-by-1. If there is a “low” risk that other applications would modify the [...]
View Answer
| October 26, 2004 5:11 PM
Microsoft Access, SQL Server, VB.NET, Visual Basic
TCP on AS/400 Ping
According to the error message (TCP3216) you are receiving duplicate response to your PING request. What kind of response times do you generally get in PING tests ? Are you running these tests inside a program or just giving ping command at a terminal session ? Then, are you using IP-address or system name as [...]
View Answer
| October 26, 2004 4:54 PM
AS/400, Development, Networking, Ping
According to the error message (TCP3216) you are receiving duplicate response to your PING request. What kind of response times do you generally get in PING tests ? Are you running these tests inside a program or just giving ping command at a terminal session ? Then, are you using IP-address or system name as [...]
View Answer
| October 26, 2004 4:54 PM
AS/400, Development, Networking, Ping
Question about IT management software-2
An excellent package for IT Service Departments is Remedy Service Management. It is from GE and is a modular system that you can structure to suit your needs. You can call them at (877) 443-2487 and they’ll put you in touch with someone who can help you. WARNING- Once placed in use, you can become [...]
View Answer
| October 25, 2004 10:40 AM
Content management applications, Corporate portal applications, DataCenter, Desktops, E-mail applications, Exchange, Firewalls, Forensics, Hardware, Help Desk, Incident response, Intrusion management, IT architecture, Knowledge management applications, Lotus Domino, Migration/Upgrades, Mobile devices, Network management software, Network security, Networking, Outlook, Planning, Project management, Security, Security management, Systems management software, Tech support, VPN, Wireless
An excellent package for IT Service Departments is Remedy Service Management. It is from GE and is a modular system that you can structure to suit your needs. You can call them at (877) 443-2487 and they’ll put you in touch with someone who can help you. WARNING- Once placed in use, you can become [...]
View Answer
| October 25, 2004 10:40 AM
Content management applications, Corporate portal applications, DataCenter, Desktops, E-mail applications, Exchange, Firewalls, Forensics, Hardware, Help Desk, Incident response, Intrusion management, IT architecture, Knowledge management applications, Lotus Domino, Migration/Upgrades, Mobile devices, Network management software, Network security, Networking, Outlook, Planning, Project management, Security, Security management, Systems management software, Tech support, VPN, Wireless
Managing Third Party Interfaces of Large System Conversion
Have your Interface Team TRY to figure out a Least Common Denominator (remember fractions?) approach. Almost all interfaces will convert to something else with relative ease. Put as many of your ‘various types’ on to whichever conversion platform would be possible. This will reduce the bulk of the headache. PS- In the future, only accept [...]
View Answer
| October 25, 2004 10:34 AM
Business/IT alignment, DataCenter, ERP, Exchange, Lifecycle development, Online transaction processing, Third-party services
Have your Interface Team TRY to figure out a Least Common Denominator (remember fractions?) approach. Almost all interfaces will convert to something else with relative ease. Put as many of your ‘various types’ on to whichever conversion platform would be possible. This will reduce the bulk of the headache. PS- In the future, only accept [...]
View Answer
| October 25, 2004 10:34 AM
Business/IT alignment, DataCenter, ERP, Exchange, Lifecycle development, Online transaction processing, Third-party services
Data Conversion on IBM AS/400
Is the physical file keyed? Are there any logical files built over the new physical? If so, you should consider temporarily removing the logicals. If the application isn’t keying the physical as it runs, it should run much faster….
View Answer
| October 25, 2004 8:20 AM
COBOL, Data analysis, DataCenter, Development, Disaster recovery software, ERP, Financial services applications, Help Desk, Incident response, Lifecycle development, Manufacturing applications, Office Applications, Programming Languages, RPG, Special-purpose software, SQL, Storage, SunGard Data Systems, Systems Union Group, Tech support, Transaction Systems Architects
Is the physical file keyed? Are there any logical files built over the new physical? If so, you should consider temporarily removing the logicals. If the application isn’t keying the physical as it runs, it should run much faster….
View Answer
| October 25, 2004 8:20 AM
COBOL, Data analysis, DataCenter, Development, Disaster recovery software, ERP, Financial services applications, Help Desk, Incident response, Lifecycle development, Manufacturing applications, Office Applications, Programming Languages, RPG, Special-purpose software, SQL, Storage, SunGard Data Systems, Systems Union Group, Tech support, Transaction Systems Architects
Oracle – database link
Here is an interesting remark from a metalink forum: From: Oracle, Dagmar Thompson 04-Sep-02 22:14 Subject: Re : Database links between Oracle 9.2 and 8.0.5.2.1 It is not a supported configuration. You need to be using at least 8.0.6 to be able to link between the two instance. — (end of remark). Personally, I have [...]
View Answer
| October 23, 2004 11:55 AM
Development
Here is an interesting remark from a metalink forum: From: Oracle, Dagmar Thompson 04-Sep-02 22:14 Subject: Re : Database links between Oracle 9.2 and 8.0.5.2.1 It is not a supported configuration. You need to be using at least 8.0.6 to be able to link between the two instance. — (end of remark). Personally, I have [...]
View Answer
| October 23, 2004 11:55 AM
Development
Web services and SOA
Service Oriented Architecture is a generic term for an architecture offering Services and all the supporting infrastructure such as directories and permissioning, etc. It could be argued that the first SOA was the Distributed Computing Environment (DCE) many moons ago. Web Services is the current fashionable SOA, coming as it does from a long line [...]
View Answer
| October 22, 2004 4:56 PM
Implementation, IT architecture, Planning, Web services
Service Oriented Architecture is a generic term for an architecture offering Services and all the supporting infrastructure such as directories and permissioning, etc. It could be argued that the first SOA was the Distributed Computing Environment (DCE) many moons ago. Web Services is the current fashionable SOA, coming as it does from a long line [...]
View Answer
| October 22, 2004 4:56 PM
Implementation, IT architecture, Planning, Web services
Converting Upsized MS Access/SQL database and application to ASP.net for the web
You can put all of yous business logic into COM Components creaded with VB or other language and Frontend in HTML/DHTM/ASP. It will be helpfull for you to distibute processing to no. of servers and upsizing your application From Arun
View Answer
| October 22, 2004 6:59 AM
ASP.NET, SQL
You can put all of yous business logic into COM Components creaded with VB or other language and Frontend in HTML/DHTM/ASP. It will be helpfull for you to distibute processing to no. of servers and upsizing your application From Arun
View Answer
| October 22, 2004 6:59 AM
ASP.NET, SQL
Remote system calls
You can use the SBMRMTCMD command to run commands, programs etc on a target system. It’s been a while since I used this function but I think you would need to start a DDM session in order to perform the SBMRMTCMD.
View Answer
| October 21, 2004 8:30 PM
Development
You can use the SBMRMTCMD command to run commands, programs etc on a target system. It’s been a while since I used this function but I think you would need to start a DDM session in order to perform the SBMRMTCMD.
View Answer
| October 21, 2004 8:30 PM
Development
VBA – Class/Procedure names
Have you tried getting the name from the object that contains the class or procedure? For example if the procedure is in say sheet1 of an excel workbook, you could get the name by drilling down in the sheet1 object. Hope that helps get you going in a positive direction.
View Answer
| October 21, 2004 11:13 AM
VB.NET, VBA, Visual Basic
Have you tried getting the name from the object that contains the class or procedure? For example if the procedure is in say sheet1 of an excel workbook, you could get the name by drilling down in the sheet1 object. Hope that helps get you going in a positive direction.
View Answer
| October 21, 2004 11:13 AM
VB.NET, VBA, Visual Basic
C# sample code for copying a table from oracle to ms sql with ODP.NET needed
I found a solution now: The way to go is as I thought to use a OracleDataAdapter, then filling a DataSet und using this DataSet to Update a SQLAdapter. But this only works if you set the property AcceptChangesDuringFill = false from the OracleDataAdapter !!
View Answer
| October 21, 2004 1:24 AM
C, Oracle, SQL
I found a solution now: The way to go is as I thought to use a OracleDataAdapter, then filling a DataSet und using this DataSet to Update a SQLAdapter. But this only works if you set the property AcceptChangesDuringFill = false from the OracleDataAdapter !!
View Answer
| October 21, 2004 1:24 AM
C, Oracle, SQL
Extracting records from Oracle based on a created time of a Unix file
Why do you want to create an empty file ? Why not saving the timestamp after a successful run of your procedure in a new created working table. Your procedure is then able to check the update field against the last saved timestamp in this table. If your procedure run into exception, don’t reset the [...]
View Answer
| October 19, 2004 8:27 PM
SQL
Why do you want to create an empty file ? Why not saving the timestamp after a successful run of your procedure in a new created working table. Your procedure is then able to check the update field against the last saved timestamp in this table. If your procedure run into exception, don’t reset the [...]
View Answer
| October 19, 2004 8:27 PM
SQL
School Project-setting up a network from the ground up for a real estate business that has 10 satellite offices. $125,000 budget.
IMHO. as the budget is only 125k I would say forget it. eg 40 average laptops @ $2k = 80k leaving $45k for infrastructue. Even if go to a server at main site and all satellite clients over terminal services etc the licensing as well as assoc. hw will chew up much of the if [...]
View Answer
| October 19, 2004 6:48 PM
Budgeting, DataCenter, Networking, Project management, Security, Servers
IMHO. as the budget is only 125k I would say forget it. eg 40 average laptops @ $2k = 80k leaving $45k for infrastructue. Even if go to a server at main site and all satellite clients over terminal services etc the licensing as well as assoc. hw will chew up much of the if [...]
View Answer
| October 19, 2004 6:48 PM
Budgeting, DataCenter, Networking, Project management, Security, Servers
Can you suggest an alternative to an IN statement?
Ooops, left out one point. The IN statement that I’d be interested in replacing is contained within the main select clause. The purpose of the IN statement is to count up the number of products contained within the category.
View Answer
| October 19, 2004 4:09 PM
SQL
Ooops, left out one point. The IN statement that I’d be interested in replacing is contained within the main select clause. The purpose of the IN statement is to count up the number of products contained within the category.
View Answer
| October 19, 2004 4:09 PM
SQL
PRM business case
“If I don’t make it easy to do business — whether through processes or technology — it won’t get done.” Search.com does a great job on research: http://searchcrm.techtarget.com/originalContent/0,289142,sid11_gci1008291,00.html
View Answer
| October 18, 2004 8:29 AM
Application software, Project management, ROI & cost justification, Services
“If I don’t make it easy to do business — whether through processes or technology — it won’t get done.” Search.com does a great job on research: http://searchcrm.techtarget.com/originalContent/0,289142,sid11_gci1008291,00.html
View Answer
| October 18, 2004 8:29 AM
Application software, Project management, ROI & cost justification, Services
Client Access File Transfer in CL Program
Did you run a STRPCO before your STRPCCMD ? It should work fine.
View Answer
| October 18, 2004 3:37 AM
Development
Did you run a STRPCO before your STRPCCMD ? It should work fine.
View Answer
| October 18, 2004 3:37 AM
Development
Data dictionary find time of long running query
Jim: I’m not sure what you mean by ‘limit it to a specific query’. Do you mean search for specific query text with LIKE in v$sqltext or v$sqlarea?
View Answer
| October 17, 2004 6:13 AM
SQL
Jim: I’m not sure what you mean by ‘limit it to a specific query’. Do you mean search for specific query text with LIKE in v$sqltext or v$sqlarea?
View Answer
| October 17, 2004 6:13 AM
SQL
