Large number rounding in Oracle 10g
Oracle 10g database table with a column having data type Number(20) stores 18 digits organization code. When this data is retrieved in SQL*Plus or Toad it is displayed in scientific notation format. The display format can be changed from scientific notation format to number format. But, for some reason the number rounds up. For example if the [...]
Answer Question
| July 19, 2010 8:27 PM
Oracle 10g administration, Oracle 10g Database, Oracle database administration, SQL Plus, TOAD
Oracle 10g database table with a column having data type Number(20) stores 18 digits organization code. When this data is retrieved in SQL*Plus or Toad it is displayed in scientific notation format. The display format can be changed from scientific notation format to number format. But, for some reason the number rounds up. For example if the [...]
iSeries SQL function in a SQL procedure – error: Function Name “in *LIBL type *N not found.”
A while back, Seeker1 posted this question. Unfortuantely, he didn’t provide enough information for Tom to help. Well – I have the same problem so hopefully, this will be enough. This Select statement generates the error: SELECT UNUNIT, ITRVEHLOC(UNUNIT , 'CITY ') FROM Units Here are the supporting commands and code: Create Function ITRVEHLOC( UNIT [...]
Answer Question
| July 16, 2010 8:13 PM
iSeries, iSeries RPG programming, RPG ILE, SQL, Stored Procedures
A while back, Seeker1 posted this question. Unfortuantely, he didn’t provide enough information for Tom to help. Well – I have the same problem so hopefully, this will be enough. This Select statement generates the error: SELECT UNUNIT, ITRVEHLOC(UNUNIT , 'CITY ') FROM Units Here are the supporting commands and code: Create Function ITRVEHLOC( UNIT [...]
Suggestions for intranet creation
What is the best free open source application to use to create our intranet? We have HTML and Java developers on hand but would rather use a package. Is there anything out there that is customizable and easy to use? We need to have a file area, a forum and blog posts.
Answer Question
| January 6, 2012 7:44 PM
HTML, Intranet, Java developers, Open source applications
What is the best free open source application to use to create our intranet? We have HTML and Java developers on hand but would rather use a package. Is there anything out there that is customizable and easy to use? We need to have a file area, a forum and blog posts.
Database structure and application outsource protocol
When an application has been outsourced, Don’t the software developer need to share the database structure with the client prior to development
Answer Question
| July 16, 2010 5:10 PM
Application development, Database design, Database Development, Database structure, SDLC, Software Development Process
When an application has been outsourced, Don’t the software developer need to share the database structure with the client prior to development
deploying an application in cloud platform
Can anyone help me in understanding the enterprise deployment and dedicated host deployment. a) what consists of a package ( we dont provide user the source code and db)and how to package an application. b) testing scenarios staging, developer , production
Answer Question
| October 17, 2010 9:41 AM
ASP, C# .NET, Cloud Computing, Web application deployment
Can anyone help me in understanding the enterprise deployment and dedicated host deployment. a) what consists of a package ( we dont provide user the source code and db)and how to package an application. b) testing scenarios staging, developer , production
Inserting parent and child tables at a time
Is there any way to insert parent and child tables data with select statement? On record in parent table and n number of records in child table. Please let me know if possible.
Answer Question
| February 22, 2013 6:41 AM
Oracle Database, Oracle Statements, TOAD
Is there any way to insert parent and child tables data with select statement? On record in parent table and n number of records in child table. Please let me know if possible.
I need to send an XML file every 5 min to another site.
I need to send an XML file every 5 min to another site. Someone suggested “ASYNC” what would that mean?
Answer Question
| July 16, 2010 9:12 PM
Asynchronous Transfer Mode, iSeries, XML development, XML File Creation
I need to send an XML file every 5 min to another site. Someone suggested “ASYNC” what would that mean?
GigaWAN service benefits
Has anyone ever heard of a GigaWAN service? I hear this data service is incredibly fast, but I want to know more about vendors, how much it costs and what the advantages or disadvantages are to using it for my corporate wide area network (WAN). Would I need GigaWAN or some other service/pipe to connect cloud computing centers?
Answer Question
| July 16, 2010 8:27 PM
GigaWAN, Services, telecom service providers, WAN, wide area network, Wide Area Networks
Has anyone ever heard of a GigaWAN service? I hear this data service is incredibly fast, but I want to know more about vendors, how much it costs and what the advantages or disadvantages are to using it for my corporate wide area network (WAN). Would I need GigaWAN or some other service/pipe to connect cloud computing centers?
Web services for windows 7
Currently I have excel .xla addin with a macro that was created by the Microsoft Office 2003 Web Services Toolkit. Works fine with XP and Excel 2003. Now some users in office have Windows 7 and Excel 2003 and I have to remove the references to the mssoap30.dll and msxml6.dll in order to have the .xla [...]
Answer Question
| July 15, 2010 3:32 PM
Office 2003, Visual Basic for Applications, WebServices, Windows 7, Windows 7 in 2010
Currently I have excel .xla addin with a macro that was created by the Microsoft Office 2003 Web Services Toolkit. Works fine with XP and Excel 2003. Now some users in office have Windows 7 and Excel 2003 and I have to remove the references to the mssoap30.dll and msxml6.dll in order to have the .xla [...]
What is a software framework?
I am a non-technical recruiter, recruiting for technical positions, and am wondering what a framework is? I am specifically hiring Java developers. Thanks!
Answer Question
| July 15, 2010 2:53 PM
Java developers, JavaScript Frameworks, Software, Software quality management
I am a non-technical recruiter, recruiting for technical positions, and am wondering what a framework is? I am specifically hiring Java developers. Thanks!
Developer 2000 error- program too large
how do i increase the size of developer 2000 form 5.0 using when button pressed trigger coz when compiling i m getting error program too large n if the answer is defining subprogram then tell me stepwise answer.
Answer Question
| July 15, 2010 8:16 AM
Oracle Developer 2000, Software performance, Subprogram
how do i increase the size of developer 2000 form 5.0 using when button pressed trigger coz when compiling i m getting error program too large n if the answer is defining subprogram then tell me stepwise answer.
Set DataTable name in returned data set
I have a SQL stored procedure with simple select statements that returns multiple datatables within the dataset. The stored procedure is being called from C#/.NET code. The stored procedure is returning the data but the datatable names end up Table, Table1, Table2,… when the dataset is received on the .NET side. Is there a way to define [...]
Answer Question
| July 20, 2010 3:29 AM
C# .NET, DataTable name, iSeries SQL, SQL stored procedures
I have a SQL stored procedure with simple select statements that returns multiple datatables within the dataset. The stored procedure is being called from C#/.NET code. The stored procedure is returning the data but the datatable names end up Table, Table1, Table2,… when the dataset is received on the .NET side. Is there a way to define [...]
Excel 2000 cannot open .ods file
I have a client using Excel 2000, and he is unable to open an Open Office Spreadsheet in his email attachments. I have set the file association, and tested the actual file to make sure there is no corruption. No matter what, this file will not open on his computer – a message comes up [...]
Answer Question
| May 1, 2012 9:33 PM
Excel 2000, Open Office, Open source software, Windows XP Pro
I have a client using Excel 2000, and he is unable to open an Open Office Spreadsheet in his email attachments. I have set the file association, and tested the actual file to make sure there is no corruption. No matter what, this file will not open on his computer – a message comes up [...]
Sponsor Post: Join Us for the Identity Access Management Live Expert Chat on 7/20 at 11am ET
To compete in the new economy, organizations need to provide efficient and secure access to their internal applications and data for external entities, such as business partners, customers, and mobile employees. Join Microsoft’s Senior Technical Product Manager, Brjann Brekkan, on July 20 from 11am-2pm ET for Microsoft Business Ready Security – Identity Access Management. He [...]
Answer Question
| July 14, 2010 3:31 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange server software, Identity and access management, Linux, Lotus Domino, Microsoft Live Chat, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
To compete in the new economy, organizations need to provide efficient and secure access to their internal applications and data for external entities, such as business partners, customers, and mobile employees. Join Microsoft’s Senior Technical Product Manager, Brjann Brekkan, on July 20 from 11am-2pm ET for Microsoft Business Ready Security – Identity Access Management. He [...]
How to access Cisco CME when GUI has died?
Silly me: Guess who put double quotes around extension/label name for phone, hit save changes, and now the Cisco CME GUI does not come up… I imagine a Telnet session is required, but not sure where to start. Not sure also what version CME it is. Using 7940 series phones. Any advice for someone with [...]
Answer Question
| July 22, 2010 3:53 AM
Cisco Call Manager, Cisco Phones, Graphical User Interfaces
Silly me: Guess who put double quotes around extension/label name for phone, hit save changes, and now the Cisco CME GUI does not come up… I imagine a Telnet session is required, but not sure where to start. Not sure also what version CME it is. Using 7940 series phones. Any advice for someone with [...]
Password protection for Joomla intranet site
How can I password protect my Joomla intranet site so that all users need to login before they see ANY data? We’re working on setting up a Joomla site to replace our current intranet site. What are the methods people use to password protect the entire site and not just individual modules?
Answer Question
| July 13, 2010 2:53 PM
Intranet, Joomla, Password policies, Password Protection, Permissions and settings
How can I password protect my Joomla intranet site so that all users need to login before they see ANY data? We’re working on setting up a Joomla site to replace our current intranet site. What are the methods people use to password protect the entire site and not just individual modules?
Radial graph in JAVA
In my project i need to draw a radial tree/graph,that will change dynamically according to the result.Can any one please tell me where i can get the source code for this radial tree. My mail id: suresh.appana@gmail.com Thanks in advance
Answer Question
| July 13, 2010 1:49 PM
Java, Java code, Radial graph in JAVA, Source code
In my project i need to draw a radial tree/graph,that will change dynamically according to the result.Can any one please tell me where i can get the source code for this radial tree. My mail id: suresh.appana@gmail.com Thanks in advance
What is the code that links vb 6.0 to Ms Access and how to go about it?
What is the code that links vb 6.0 to Ms Access and how to go about it?
Answer Question
| August 2, 2010 1:01 PM
Access Database, Microsoft Access, VB Code, Visual Basic 6
What is the code that links vb 6.0 to Ms Access and how to go about it?
Need help with documentation on a time tracker project
i m workin on a project – time tracker. its my 1st one. m a newbie n have no idea about documentation. can someone plz brief me how it wil b done? thanx
Answer Question
| July 13, 2010 8:28 AM
C# .NET, MySQL documentation, MySQL functions, MySQL query
i m workin on a project – time tracker. its my 1st one. m a newbie n have no idea about documentation. can someone plz brief me how it wil b done? thanx
Segmentation fault (core dumped)
when i restart the apache ,Segmentation fault (core dumped) error has araised. how to fix the issue.
Answer Question
| July 13, 2010 7:04 AM
Apache Web Server, core dump, Error Messages, Segmentation Fault
when i restart the apache ,Segmentation fault (core dumped) error has araised. how to fix the issue.





