Transform DB2 to XML from AS/400
I have written programs to do what you want to do, and would be happy to provide an example, for you and anyone else who is interested. You can get me at john.blenkinsop@ne.nykline.com Sloopy ————– DB2 SQL has the capability of creating XML … SELECT XML2CLOB( XMLELEMENT(NAME “DEPARTMENT”, XMLATTRIBUTES (DEPT AS “NAME” ), XMLAGG(XMLELEMENT(NAME “EMP”, [...]

View Answer   |  November 1, 2010  6:54 AM
AS/400 development, DB2, DB2/400, iSeries development, XML, XML Toolkit for iSeries

SQL performance vs. Internal pgogram database access
SQL is hardly the most efficient way to access a database file. SQL’s strength relies on being a structed language that can be applied to several databases without change not on its speed. Internal program database access will perform better in most cases, especially if the program is coded in a language optimized to access [...]

View Answer   |  October 31, 2010  12:37 PM
AS/400, SQL

Java development career
Do u working before ! if not then u can write resume as a fresher, cause experienced person’s resume is totally separate from freshers (hope u r not, u mentioned as student). I just show u some imp points: 1. Summary of ur objectives or rather ur skill (what kind of job u want, how [...]

View Answer   |  October 31, 2010  7:05 AM
IT careers, Java developers, Java development, Java/J2EE

JAVA! Isn’t effort saved spent elsewhere?
JVM or Java Virtual Machine is an in-built mechanism of modern OS. and it is found also in browser or later may configure it. In my case, it is not necessary to write jvm for each platform !

View Answer   |  October 31, 2010  6:56 AM
Compilers, Java, JAVA jvm, JVM

SAP short term course
There r no of division in SAP. As per ur choice it is better to move for n/w course. But must take global certification viz CCNA, CCNP, MSCE or Linux networking…..

View Answer   |  October 30, 2010  8:49 AM
.NET training, Java training, SAP careers, SAP training

what is needed to beacome a ethical hacker
For Ethical Hacking there r no of global courses / trainings, but before going to take certification it is recommended that, as EmNichs guided u, u may gain more knowledge…..

View Answer   |  October 30, 2010  6:01 AM
Ethical hackers, Ethical hacking, Hackers and hacking groups, Hacking tools and techniques, PHP, Python

Total Balance for Concatenated Unique ID in Access and Excel
Try a query like this: <pre>SELECT t1.identifier, SUM(t1.amount) FROM table_1 AS t1 GROUP BY t1.identifier HAVING (((Sum(t1.amount))<> SELECT SUM(amount) FROM table_2 WHERE identifier = t1.identifier)));</pre>

View Answer   |  October 29, 2010  3:31 PM
Access, compare reconciliation balance unique identifier, Concatenate, excel

HTTP Server on Linux Virtual Server
python comes with a simple http server /usr/bin/python -m SimpleHTTPServer 80 run it from the directory containing your html pages like the name implies it’s simple and probably best suited for light load/testing/temporay solution

View Answer   |  October 28, 2010  2:50 PM
HTTP, Http Server, Linux Virtual Server, SUSE Linux, Virtual machine management, Virtual Server

Career in Software Testing v/s Mainframes
Both have enormous scope of career. It depends on how much u have time to provide for these course or training ! and ofcourse ur taking capacity and grasping power. Though u have done BCA so u may go for any one as per ur choice ! But must do from a renowned institutions and [...]

View Answer   |  October 28, 2010  10:39 AM
Mainframe careers, Mainframe certifications, Software testing jobs, Unix administration

SQL Server 2005 Enterprise Edition SP3 Performance
based on the second screenshot you’ve got a lot of database tuning that needs to be done. This will require making index changes to improve your query time. This will reduce the SOS_SCHEDULER_YIELD and will probably reduce the disk IO access.

View Answer   |  October 28, 2010  5:13 AM
SQL, SQL performance, SQL Server, SQL Server 2005, SQL Server 2005 SP3, SQL Server Enterprise Edition

What are your questions for software testing expert James Christie? 100 Point Bounty!
What is the recommendation for a small IT consulting company developing applications with Access database, Visual Basic 2008 and/or Excel to use automated testing tools. Is it fairly easy and intuitive to pick the knowledge and apply the tools? Or do we have to develop an expert in testing tools? Thank you, for initiating ands [...]

View Answer   |  October 28, 2010  3:07 AM
IT Blogs, IT career advice, Software testing

ESXi v4.1 White Box
That looks fine. Just make sure that all the components are on the VMware Hardware Compatibility list.

View Answer   |  October 27, 2010  9:27 PM
ESXi, SQL Server, Virtual Machines, VMware ESXi, Web servers, Windows Server 2008

SQL SERVER 2005 Database Options
None will give you the best performance because no page verification is done. However if there is a corrupt page the database won’t find it until it tries to process the data within the page. The other values will do a set of checks which the pages are read looking to database corruption.

View Answer   |  October 27, 2010  9:25 PM
SQL, SQL Database, SQL Server, SQL Server 2005, SQL Server 2005 Database

Open IT Forum: What services have you adopted after a trial period?
Recently we did a free trial period for Encryption and FTP software. We ending up pruchasing both packages.

View Answer   |  October 27, 2010  8:30 PM
Amazon Web services, AWS, Open IT Forum, Trial period software

Chrome doesn’t render the end-span correctly
No-one? one mistake in my post: it must be “without having them beteween ul and /ul-tags”

View Answer   |  October 27, 2010  7:38 AM
CSS, Forms Design, HTML

SQL Server 2005 Memory
If you don’t have AWE then SQL Server can only use 2 Gigs of memory. With AWE the SQL Server can use the rest of the memory for the buffer cache. The private memory and procedure cache will stay within the first 2 Gigs.

View Answer   |  October 26, 2010  6:26 PM
SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server memory

Risks in Testing?
Risk are events that has a chance of occurance and a potential loss if it occurs. There are several types of risk and testers have to take these into account when creating test plans. Some risks are scope creep, budget risks (due to estimation or cost), operational risks (insufficient resources, etc), technical risks (new technology, [...]

View Answer   |  October 26, 2010  1:35 PM
Functional software testing, Functional testing, Manual Testing

Runtime error and compile time error in RPG/400
Compile Time Error: An error within the code, that causes the compile of the program to fail. (i.e. Variable not defined) Runtime Error: An error that occurs when a compiled program encounters an error, while running. (i.e. Array element is out of bounds; like when you have an array defined to handle up to 99 [...]

View Answer   |  October 26, 2010  1:35 PM
AS/400 compile, AS/400 Runtime Errors, RPG/400, Runtime Errors

Print Image File in iSeries
Not sure about the GRAPHIC keyword but there’s an article (19313) by Glenn Rose at iSeriesNetwork.com that deals with adding colour to iSeries prints and, amongst other things, image files that are stored in the IFS. V5R3 of the OS must be installed. ================================================== There might be a technical possibility that some kind of image [...]

View Answer   |  October 24, 2010  10:30 PM
AS/400, DB2, Development, i5, Integration/Connectivity, iSeries, OS/400, Programming Languages, RPG, tips and tricks, Tools

Message subfile
Hi, have you already checked that this is not a library list problem because it seems you don’t specify the library in your clear statement. If the MSGQ is owned by the program that calls the CLP to clear it , you may use *PRV as first parameter. Hope it may help. Regards. =========================================================== The [...]

View Answer   |  October 24, 2010  8:54 PM
Programming Languages, RPG