SQL Query to return a single value for each record based on max FIELD, not max record
First the lecture – (this is the price for the answer) – your table is not normalized properly. anytime you have “repeating” columns, it violates first normal form. You should understand the rules of normalization and consider the advantages before designing any tables. I would suggest that your table, even though it exists in an [...]
View Answer
| December 4, 2009 10:22 PM
Access 2007, Microsoft Access, SQL, SQL Query
First the lecture – (this is the price for the answer) – your table is not normalized properly. anytime you have “repeating” columns, it violates first normal form. You should understand the rules of normalization and consider the advantages before designing any tables. I would suggest that your table, even though it exists in an [...]
View Answer
| December 4, 2009 10:22 PM
Access 2007, Microsoft Access, SQL, SQL Query
start career
I can’t help you with the chennai stuff but here are some tips on <a href=”http://www.principlelogic.com/careers.html”>establishing your career in IT</a> you may want to check out. ———————— You can also take a look around the <a href=”http://itknowledgeexchange.techtarget.com/itanswers/tag/oracle-dba/”>Oracle DBA</a>, <a href=”http://itknowledgeexchange.techtarget.com/itanswers/tag/careers/”>Careers</a> and <a href=”http://itknowledgeexchange.techtarget.com/itanswers/tag/oracle-careers”>Oracle Careers</a> tags of our site for more information.
View Answer
| December 4, 2009 4:09 PM
Careers, Database administration, DBA, DBA training, IT careers
I can’t help you with the chennai stuff but here are some tips on <a href=”http://www.principlelogic.com/careers.html”>establishing your career in IT</a> you may want to check out. ———————— You can also take a look around the <a href=”http://itknowledgeexchange.techtarget.com/itanswers/tag/oracle-dba/”>Oracle DBA</a>, <a href=”http://itknowledgeexchange.techtarget.com/itanswers/tag/careers/”>Careers</a> and <a href=”http://itknowledgeexchange.techtarget.com/itanswers/tag/oracle-careers”>Oracle Careers</a> tags of our site for more information.
View Answer
| December 4, 2009 4:09 PM
Careers, Database administration, DBA, DBA training, IT careers
S/W course
Given the info you provided, it’s hard to be specific but I can say that Web-related software courses in ASP.NET, PHP, or JAVA would be beneficial. Also, here are some tips on <a href=”http://www.principlelogic.com/careers.html”>starting a career in IT</a> you may want to check out. —————————– You might also want to take a look around our [...]
View Answer
| December 4, 2009 4:06 PM
Careers, Certifications, IT careers, s/w
Given the info you provided, it’s hard to be specific but I can say that Web-related software courses in ASP.NET, PHP, or JAVA would be beneficial. Also, here are some tips on <a href=”http://www.principlelogic.com/careers.html”>starting a career in IT</a> you may want to check out. —————————– You might also want to take a look around our [...]
View Answer
| December 4, 2009 4:06 PM
Careers, Certifications, IT careers, s/w
About MCSE
What is your definition of high-profile? I know I doubled my income within two years of receiving my MCSE. It can’t hurt to get it. —————————– Be sure to check out the <a href=”http://itknowledgeexchange.techtarget.com/itanswers/tag/mcse/”>MCSE</a> and <a href=”http://itknowledgeexchange.techtarget.com/itanswers/tag/microsoft-certifications”>Microsoft certifications</a> tags in the community — there are many other members who are asking about their career path [...]
View Answer
| December 4, 2009 4:00 PM
Careers, IT careers, MCSE
What is your definition of high-profile? I know I doubled my income within two years of receiving my MCSE. It can’t hurt to get it. —————————– Be sure to check out the <a href=”http://itknowledgeexchange.techtarget.com/itanswers/tag/mcse/”>MCSE</a> and <a href=”http://itknowledgeexchange.techtarget.com/itanswers/tag/microsoft-certifications”>Microsoft certifications</a> tags in the community — there are many other members who are asking about their career path [...]
View Answer
| December 4, 2009 4:00 PM
Careers, IT careers, MCSE
which is the best among DBA and CCNA for career in all aspects
You have one year exp. in network field so you chose CCNA . CCNA is a good field in your exp. This field is very hard working field but 3-4 years after very easy work and earn more money. ——————————————————- You can also check out the <a href=”http://itknowledgeexchange.techtarget.com/itanswers/tag/careers/”>careers</a> and <a href=”http://itknowledgeexchange.techtarget.com/itanswers/tag/dba/”>DBA</a> tags on the site; [...]
View Answer
| December 4, 2009 3:57 PM
Careers, CCNA, Certifications, DBA, IT careers
You have one year exp. in network field so you chose CCNA . CCNA is a good field in your exp. This field is very hard working field but 3-4 years after very easy work and earn more money. ——————————————————- You can also check out the <a href=”http://itknowledgeexchange.techtarget.com/itanswers/tag/careers/”>careers</a> and <a href=”http://itknowledgeexchange.techtarget.com/itanswers/tag/dba/”>DBA</a> tags on the site; [...]
View Answer
| December 4, 2009 3:57 PM
Careers, CCNA, Certifications, DBA, IT careers
Physical / Logical file definitions
I have tested on our machine, it works fine, nothing is different. =========================================================== PF and LF fields can be different. That’s one of the points of why LFs are useful in the first place. Yes, there are naturally differences. There are conversions that must happen between data types — conversions always take time and sometimes [...]
View Answer
| December 3, 2009 9:00 AM
DB2 Universal Database, RPG, RPGLE
I have tested on our machine, it works fine, nothing is different. =========================================================== PF and LF fields can be different. That’s one of the points of why LFs are useful in the first place. Yes, there are naturally differences. There are conversions that must happen between data types — conversions always take time and sometimes [...]
View Answer
| December 3, 2009 9:00 AM
DB2 Universal Database, RPG, RPGLE
VB6.0 Connectivity to Oracle
Here’s an ADO example: <pre>Dim adoCn As New ADODB.Connection Dim sConString As String sConString = “Provider=MSDAORA.1;Password=<your password>;” _ & ” User ID=<your user name>;Data Source=<your oracle database alias>;” _ & ” Persist Security Info=True” With adoCn .ConnectionString = sConString .CursorLocation = adUseClient .ConnectionTimeout = 30 .Open End With ‘… ‘… do your database operations ‘… [...]
View Answer
| December 2, 2009 5:53 PM
ActiveX, Activex connectivity, ODBC, Oracle 9i, VB6.0, Visual Basic
Here’s an ADO example: <pre>Dim adoCn As New ADODB.Connection Dim sConString As String sConString = “Provider=MSDAORA.1;Password=<your password>;” _ & ” User ID=<your user name>;Data Source=<your oracle database alias>;” _ & ” Persist Security Info=True” With adoCn .ConnectionString = sConString .CursorLocation = adUseClient .ConnectionTimeout = 30 .Open End With ‘… ‘… do your database operations ‘… [...]
View Answer
| December 2, 2009 5:53 PM
ActiveX, Activex connectivity, ODBC, Oracle 9i, VB6.0, Visual Basic
using QDBRTVFD to find SQL view create statement
I’ve no experience with the command line version, however, you will find that the iSeries Navigator, installed with all the options, will make your task much easier. You can expand the databases to see schema, and once that is expanded you will have the option to look at the views in the schema. From there [...]
View Answer
| December 2, 2009 8:25 AM
Application development, AS/400, CLP, DB2, DB2 Universal Database, RPGLE, Tech support
I’ve no experience with the command line version, however, you will find that the iSeries Navigator, installed with all the options, will make your task much easier. You can expand the databases to see schema, and once that is expanded you will have the option to look at the views in the schema. From there [...]
View Answer
| December 2, 2009 8:25 AM
Application development, AS/400, CLP, DB2, DB2 Universal Database, RPGLE, Tech support
Would an Avaya certification help me?
I believe that almost any certification is a good thing. It helps prove that you have at least some level of understanding of a product or system. Going through the education is valuable and you more than likely might learn at least one or two things you did not know before and some of that [...]
View Answer
| December 2, 2009 4:48 AM
Avaya, Career development, Certifications, IT careers, Networking certifications
I believe that almost any certification is a good thing. It helps prove that you have at least some level of understanding of a product or system. Going through the education is valuable and you more than likely might learn at least one or two things you did not know before and some of that [...]
View Answer
| December 2, 2009 4:48 AM
Avaya, Career development, Certifications, IT careers, Networking certifications
SQL
No, SQL Server doesn’t provide a way to prompt the user for input. You would have to write your own app which supported this. The native tools do not. — It is T-SQL (Transact SQL) that you are looking at. T-SQL has the “pop up” feature.
View Answer
| December 1, 2009 5:34 PM
Access 2000, Access Datasheet, Microsoft Access 2000, SQL, Windows Server 2000
No, SQL Server doesn’t provide a way to prompt the user for input. You would have to write your own app which supported this. The native tools do not. — It is T-SQL (Transact SQL) that you are looking at. T-SQL has the “pop up” feature.
View Answer
| December 1, 2009 5:34 PM
Access 2000, Access Datasheet, Microsoft Access 2000, SQL, Windows Server 2000
Building an xml in java
Try this: http://www.lmgtfy.com/?q=example+of+building+an+xml+with+multiple+child+nodes+in+java
View Answer
| November 30, 2009 9:25 PM
AS/400, Java, JDBC, SQL Query, XML
Try this: http://www.lmgtfy.com/?q=example+of+building+an+xml+with+multiple+child+nodes+in+java
View Answer
| November 30, 2009 9:25 PM
AS/400, Java, JDBC, SQL Query, XML
User Auditing/Journaling
Mark In full disclosure: I work for an iSeries security vendor. We have a white paper on our website that does an excellent job of explaining the basics of iSeries auditing. Go to the following link: http://tinyurl.com/rsr95 Regards, Nick Blattner ============================================ The answer is “Yes, journaling is appropriate.” The full answer includes audit journaling. Program [...]
View Answer
| November 30, 2009 5:36 AM
Application development, Application security, AS/400, AS/400 careers, Backup & recovery, Biometrics, CLP, Compliance, configuration, CRM, Database, DataCenter, DB2 Universal Database, Digital certificates, Disaster Recovery, Email, Encryption, Exchange, IBM Marketing Sound Off, Identity & Access Management, Instant Messaging, patching, PC/Windows Connectivity, PEN testing, Platform Security, Policies, Printing, provisioning, Risk management, RPG, RPGLE, Secure Coding, Security, Security Program Management, Security tokens, Single sign-on, vulnerability management, Web development
Mark In full disclosure: I work for an iSeries security vendor. We have a white paper on our website that does an excellent job of explaining the basics of iSeries auditing. Go to the following link: http://tinyurl.com/rsr95 Regards, Nick Blattner ============================================ The answer is “Yes, journaling is appropriate.” The full answer includes audit journaling. Program [...]
View Answer
| November 30, 2009 5:36 AM
Application development, Application security, AS/400, AS/400 careers, Backup & recovery, Biometrics, CLP, Compliance, configuration, CRM, Database, DataCenter, DB2 Universal Database, Digital certificates, Disaster Recovery, Email, Encryption, Exchange, IBM Marketing Sound Off, Identity & Access Management, Instant Messaging, patching, PC/Windows Connectivity, PEN testing, Platform Security, Policies, Printing, provisioning, Risk management, RPG, RPGLE, Secure Coding, Security, Security Program Management, Security tokens, Single sign-on, vulnerability management, Web development
embedded sql performance over large files
debug your sql with Sql Visual Explain, it’s a tool provided with operation navigator. details ? look at http://jplamontre.free.fr/AS400/RTVSQL.htm and http://jplamontre.free.fr/AS400/SqlExplain.htm ============================================================ Ripping out the SQL and replacing with native RLA will almost certainly make things slower, so why even consider it? Of course, that assumes that SQL is being used appropriately in the first [...]
View Answer
| November 30, 2009 4:56 AM
AS/400, DB2 Universal Database
debug your sql with Sql Visual Explain, it’s a tool provided with operation navigator. details ? look at http://jplamontre.free.fr/AS400/RTVSQL.htm and http://jplamontre.free.fr/AS400/SqlExplain.htm ============================================================ Ripping out the SQL and replacing with native RLA will almost certainly make things slower, so why even consider it? Of course, that assumes that SQL is being used appropriately in the first [...]
View Answer
| November 30, 2009 4:56 AM
AS/400, DB2 Universal Database
Reading a File of unknown name, format, etc.
Try this : - declare your file as no-dds (program described) with only one field large enough for the largest record - before running programm, OVRDBF compil-time file to real file - read the record one by one - when you know the format, move the record field to some DS It’s an old technique. [...]
View Answer
| November 30, 2009 4:51 AM
DB2 Universal Database, RPGLE
Try this : - declare your file as no-dds (program described) with only one field large enough for the largest record - before running programm, OVRDBF compil-time file to real file - read the record one by one - when you know the format, move the record field to some DS It’s an old technique. [...]
View Answer
| November 30, 2009 4:51 AM
DB2 Universal Database, RPGLE
How can I split job by determine no. of records ?
Hi, Try OPNQRYF. Nikhil ============================================================== The best answer can’t be determined without knowing why 20000 transactions take too long. E.g., it may be because the transactions are applied against very large files with many logicals that must be updated. Breaking the file up might not make much difference if index maintenance is taking the time. [...]
View Answer
| November 29, 2009 8:08 PM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, RPG, RPGLE
Hi, Try OPNQRYF. Nikhil ============================================================== The best answer can’t be determined without knowing why 20000 transactions take too long. E.g., it may be because the transactions are applied against very large files with many logicals that must be updated. Breaking the file up might not make much difference if index maintenance is taking the time. [...]
View Answer
| November 29, 2009 8:08 PM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, RPG, RPGLE
Microsoft Access Report
Try saving it with a different name. If that works, let me know, i will tell you the reason.
View Answer
| November 27, 2009 7:52 AM
Microsoft Access
Try saving it with a different name. If that works, let me know, i will tell you the reason.
View Answer
| November 27, 2009 7:52 AM
Microsoft Access
lamp or sap
Hi, i don’t know about lamp, but what i can suggest is as a fresher is not recommnaded to get into sap as openings for freshers in sap is less than 1% decission is yours
View Answer
| November 26, 2009 2:56 PM
Careers, Certifications, IT careers, LAMP, SAP, SAP careers
Hi, i don’t know about lamp, but what i can suggest is as a fresher is not recommnaded to get into sap as openings for freshers in sap is less than 1% decission is yours
View Answer
| November 26, 2009 2:56 PM
Careers, Certifications, IT careers, LAMP, SAP, SAP careers
deal with microsoft access data base file from RPG program or clp
You only THINK you need to have your RPG program talk to a MS Access data base. What you really need to do is to move the MS Access data base onto your mainframe, and then have MS Access access it remotely. Sticking with the data base on MS Access is asking for trouble, including [...]
View Answer
| November 26, 2009 7:59 AM
Application development, AS/400, CLP, DB2 Universal Database, RPGLE
You only THINK you need to have your RPG program talk to a MS Access data base. What you really need to do is to move the MS Access data base onto your mainframe, and then have MS Access access it remotely. Sticking with the data base on MS Access is asking for trouble, including [...]
View Answer
| November 26, 2009 7:59 AM
Application development, AS/400, CLP, DB2 Universal Database, RPGLE
Best way to create a large access databases.
Hmm… let’s just throw this out and see if it works for you. If you want to use Access because you love the forms and VBA, you can always link Access tables to more heavy duty backend databases. If you haven’t got a “heavy duty backend database”, then you can download MySQL for free without [...]
View Answer
| November 25, 2009 10:23 PM
Database, Microsoft Access
Hmm… let’s just throw this out and see if it works for you. If you want to use Access because you love the forms and VBA, you can always link Access tables to more heavy duty backend databases. If you haven’t got a “heavy duty backend database”, then you can download MySQL for free without [...]
View Answer
| November 25, 2009 10:23 PM
Database, Microsoft Access
The IT Blog Top 10: Oct. 29, 2009
The most effective and informative <a href=”http://www.fifiland.pl/”>przedszkole Szczscin</a> for finland. Here you can find the impressive information which is helpful for you to select your desire goal.
View Answer
| November 25, 2009 1:06 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, IT Blogs, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
The most effective and informative <a href=”http://www.fifiland.pl/”>przedszkole Szczscin</a> for finland. Here you can find the impressive information which is helpful for you to select your desire goal.
View Answer
| November 25, 2009 1:06 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, IT Blogs, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
