Unique ID for existing table
This could be different depending on the database, which you didn’t specify. If you already have data in the table, you will probably need to create a stored procedure to generate the sequential number for the existing records, and then set a trigger up to auto-generate the number when new records are inserted.
View Answer
| April 20, 2009 4:09 PM
Auto increment, Database design, Database programming, SQL
This could be different depending on the database, which you didn’t specify. If you already have data in the table, you will probably need to create a stored procedure to generate the sequential number for the existing records, and then set a trigger up to auto-generate the number when new records are inserted.
View Answer
| April 20, 2009 4:09 PM
Auto increment, Database design, Database programming, SQL
Network forensics
There is a <a href=”http://www.eccouncil.org/chfi.htm”>Certified Hacking Forensic Investigator certification from EC Council</a> that can give you a good baseline for the steps. <a href=”http://www.sans.org/training/description.php?tid=2872″>SANS also has forensic courses</a>.
View Answer
| April 20, 2009 2:33 PM
Forensic analysis, Forensics, IT careers, Network forensics, Networking careers
There is a <a href=”http://www.eccouncil.org/chfi.htm”>Certified Hacking Forensic Investigator certification from EC Council</a> that can give you a good baseline for the steps. <a href=”http://www.sans.org/training/description.php?tid=2872″>SANS also has forensic courses</a>.
View Answer
| April 20, 2009 2:33 PM
Forensic analysis, Forensics, IT careers, Network forensics, Networking careers
ODBC Connection to iSeries
Have you applied the lastest PTF package? There are a lots of APARs opened for ODBC connection problems on V6R1 system version.
View Answer
| April 19, 2009 3:39 PM
Crystal Reports, Data Transformation Services, iSeries Access, iSeries connectivity, iSeries interoperability, ODBC, Open Database Connectivity, SQL Server DTS
Have you applied the lastest PTF package? There are a lots of APARs opened for ODBC connection problems on V6R1 system version.
View Answer
| April 19, 2009 3:39 PM
Crystal Reports, Data Transformation Services, iSeries Access, iSeries connectivity, iSeries interoperability, ODBC, Open Database Connectivity, SQL Server DTS
creating reports with forms/subforms
This looks like you have control element with data (emp.id) which absent from query underlying report. To print on separate page the data for each Employee ID number, add group by this column and set a page break at the beginning of this group.
View Answer
| April 19, 2009 8:32 AM
Access 2000, Access forms, Microsoft Access, Microsoft Access forms, Microsoft Access subforms
This looks like you have control element with data (emp.id) which absent from query underlying report. To print on separate page the data for each Employee ID number, add group by this column and set a page break at the beginning of this group.
View Answer
| April 19, 2009 8:32 AM
Access 2000, Access forms, Microsoft Access, Microsoft Access forms, Microsoft Access subforms
Career change
As you know IT has several aspects and security is just one of them, in any case I strongly suggest you googling for certifications that document that you’re an expert.
View Answer
| April 18, 2009 7:49 AM
IT careers
As you know IT has several aspects and security is just one of them, in any case I strongly suggest you googling for certifications that document that you’re an expert.
View Answer
| April 18, 2009 7:49 AM
IT careers
log sql queries?
Try this: <pre>SELECT username users, sql_text, Executions, loads, users_executing FROM sys.v_$sqlarea a, dba_users b WHERE a.parsing_user_id = b.user_id AND b.username LIKE UPPER(‘%&user_name%’);</pre>
View Answer
| April 17, 2009 7:55 PM
Oracle 9i, SQL queries, SQL Server logs
Try this: <pre>SELECT username users, sql_text, Executions, loads, users_executing FROM sys.v_$sqlarea a, dba_users b WHERE a.parsing_user_id = b.user_id AND b.username LIKE UPPER(‘%&user_name%’);</pre>
View Answer
| April 17, 2009 7:55 PM
Oracle 9i, SQL queries, SQL Server logs
spool to flat file from SQL editor
Hi SQuirel SQL appears to be a Java SQL client type program running on your PC. We could tell you how to automate the running, capture, and subsequent download of a series of SQL statements on the AS/400 but this part of the forum probably cannot help with your SQuirel SQL questions. Perhaps you could [...]
View Answer
| April 17, 2009 1:31 PM
AS/400 Spooled Files, Flat files, SQL, SQL Editor
Hi SQuirel SQL appears to be a Java SQL client type program running on your PC. We could tell you how to automate the running, capture, and subsequent download of a series of SQL statements on the AS/400 but this part of the forum probably cannot help with your SQuirel SQL questions. Perhaps you could [...]
View Answer
| April 17, 2009 1:31 PM
AS/400 Spooled Files, Flat files, SQL, SQL Editor
Make Table query Produces different result than same select query
Are you referring to different number of records in the resulting table than the query or are you referring to different column types created or different number of columns? If you formatted a numeric field, the corresponding column in the “made” table would be text. The same goes with date. Are you doing that?
View Answer
| April 16, 2009 8:11 PM
Access query, Access table, Microsoft Access, Microsoft Access tables
Are you referring to different number of records in the resulting table than the query or are you referring to different column types created or different number of columns? If you formatted a numeric field, the corresponding column in the “made” table would be text. The same goes with date. Are you doing that?
View Answer
| April 16, 2009 8:11 PM
Access query, Access table, Microsoft Access, Microsoft Access tables
Change year range on ActiveX calendar on Access form
I do not see any way to change the default range on the the year dropdown. I found that same code you did, but I do not think it is trying to tell us how to set the StartDateYear. I think StartDate is the name they gave their instance of the control. For instance, I [...]
View Answer
| April 16, 2009 7:28 PM
ActiveX, Microsoft Access, Microsoft Access Calendar control, Microsoft Access forms
I do not see any way to change the default range on the the year dropdown. I found that same code you did, but I do not think it is trying to tell us how to set the StartDateYear. I think StartDate is the name they gave their instance of the control. For instance, I [...]
View Answer
| April 16, 2009 7:28 PM
ActiveX, Microsoft Access, Microsoft Access Calendar control, Microsoft Access forms
Autopopulating following fields
Check the properties of these fields. Open the form in Design mode – click on the field & then right click . Then select property. Look the Row Source field and change/modify accordingly. If no luck – please provide more details. Is this Access 2007?
View Answer
| April 16, 2009 6:19 PM
Access Database, Microsoft Access
Check the properties of these fields. Open the form in Design mode – click on the field & then right click . Then select property. Look the Row Source field and change/modify accordingly. If no luck – please provide more details. Is this Access 2007?
View Answer
| April 16, 2009 6:19 PM
Access Database, Microsoft Access
how do i go about using cluster software
Can you be more specific? Is this an established cluster and you need to know more about using the cluster administrator? Or are you asking about installing a cluster? Also what OS are you working with? Where exactly do you need the assistance? Thanks.
View Answer
| April 16, 2009 2:49 PM
Cluster, Cluster management, Clustering
Can you be more specific? Is this an established cluster and you need to know more about using the cluster administrator? Or are you asking about installing a cluster? Also what OS are you working with? Where exactly do you need the assistance? Thanks.
View Answer
| April 16, 2009 2:49 PM
Cluster, Cluster management, Clustering
View is taking so much time for fetching data
More information is needed to give a good answer to this question. There could be many factors affecting the response time, and different actions could be necessary depending on the database you are using, which you didn’t specify. One common reason for slow queries is the lack of appropriate indexes, so I would recommend to [...]
View Answer
| April 16, 2009 1:53 PM
Database Views, Query optimization
More information is needed to give a good answer to this question. There could be many factors affecting the response time, and different actions could be necessary depending on the database you are using, which you didn’t specify. One common reason for slow queries is the lack of appropriate indexes, so I would recommend to [...]
View Answer
| April 16, 2009 1:53 PM
Database Views, Query optimization
Updating a field and counting unique field values from another fields all in the same query?
<b>I just noticed an error in my code:</b> <pre>With rsMessageIn .Fields(5) = 1 ‘Set record uniqueness status .Update End With</pre> <b>Should be:</b> <pre>With rsMessageIn .Fields(0) = 1 ‘Set record uniqueness status .Update End With</pre> But this is irrelevant to my question, I am just correcting this for completeness! ———————— You are getting the error because [...]
View Answer
| April 15, 2009 1:53 PM
Query optimization, SQL, SQL Aggregate error, SQL queries
<b>I just noticed an error in my code:</b> <pre>With rsMessageIn .Fields(5) = 1 ‘Set record uniqueness status .Update End With</pre> <b>Should be:</b> <pre>With rsMessageIn .Fields(0) = 1 ‘Set record uniqueness status .Update End With</pre> But this is irrelevant to my question, I am just correcting this for completeness! ———————— You are getting the error because [...]
View Answer
| April 15, 2009 1:53 PM
Query optimization, SQL, SQL Aggregate error, SQL queries
What questions should I expect for a deskstop support in the nhs
For desktop support, they won’t get too technical. You should have experience with fixing and building computers, troubleshooting application issues, and working with the users. They will mostly ask you the common questions like where do you see youself in 5 years or what will you add to the company, to get a feel of [...]
View Answer
| April 15, 2009 2:54 AM
Careers, Desktop Support, IT careers, IT jobs
For desktop support, they won’t get too technical. You should have experience with fixing and building computers, troubleshooting application issues, and working with the users. They will mostly ask you the common questions like where do you see youself in 5 years or what will you add to the company, to get a feel of [...]
View Answer
| April 15, 2009 2:54 AM
Careers, Desktop Support, IT careers, IT jobs
where is there strong demand for jobs in the it sector
There are SO many variables to consider. What area of the country? What country for that matter? What area of insterest or expertise do you have? I doubt anyone can give you a definitive answer to such a broad question. Try posting your resume on dice or monster and see what the interest is for [...]
View Answer
| April 15, 2009 2:48 AM
Careers, IT careers, IT jobs
There are SO many variables to consider. What area of the country? What country for that matter? What area of insterest or expertise do you have? I doubt anyone can give you a definitive answer to such a broad question. Try posting your resume on dice or monster and see what the interest is for [...]
View Answer
| April 15, 2009 2:48 AM
Careers, IT careers, IT jobs
VB6: Getting List of records from one field of Microsoft Access Table in ComboBox
Well, a simple-minded person like myself (IQ 154) would just run the query wizard and select only the field you want to see. You can print your list of records from the query or do whatever you have in mind. Juju
View Answer
| April 14, 2009 5:29 PM
ComboBox, Microsoft Access, VB 6, VB error handling, Visual Basic 6, Visual Basic runtime errors
Well, a simple-minded person like myself (IQ 154) would just run the query wizard and select only the field you want to see. You can print your list of records from the query or do whatever you have in mind. Juju
View Answer
| April 14, 2009 5:29 PM
ComboBox, Microsoft Access, VB 6, VB error handling, Visual Basic 6, Visual Basic runtime errors
Meeting Invitation not updated in Calendar
Microsoft Outlook is the program designed for this task — it’s not just an e-mail software, it’s for planning and tracking meetings and places the meetings on the invitee’s calendars. You can easily see who has accepted or declined the meeting invitation and you can set it up to remind people 30 minutes (or whatever) [...]
View Answer
| April 14, 2009 5:11 PM
Beginner Access Programming, COM, Microsoft Access, VBA
Microsoft Outlook is the program designed for this task — it’s not just an e-mail software, it’s for planning and tracking meetings and places the meetings on the invitee’s calendars. You can easily see who has accepted or declined the meeting invitation and you can set it up to remind people 30 minutes (or whatever) [...]
View Answer
| April 14, 2009 5:11 PM
Beginner Access Programming, COM, Microsoft Access, VBA
SQL in an SQLRPGLE program
Alpfalpf I’m supposing that you had a good value for :SZIP and SINNME = %VALLEY% SELECT * FROM F0101JN WHERE ALADDZ = :SZIP C+ AND ABALPH LIKE :SINNME ORDER BY ABAN8 C/END-EXEC If I were doing it interactively I would have to type ‘%VALLEY%’ with the quotes so I expect the the value you need [...]
View Answer
| April 14, 2009 11:43 AM
C+, Embedded SQL, LIKE statement, SQL, SQL/400, SQLRPGLE
Alpfalpf I’m supposing that you had a good value for :SZIP and SINNME = %VALLEY% SELECT * FROM F0101JN WHERE ALADDZ = :SZIP C+ AND ABALPH LIKE :SINNME ORDER BY ABAN8 C/END-EXEC If I were doing it interactively I would have to type ‘%VALLEY%’ with the quotes so I expect the the value you need [...]
View Answer
| April 14, 2009 11:43 AM
C+, Embedded SQL, LIKE statement, SQL, SQL/400, SQLRPGLE
Oracle SQL question
Oracle does indeed have if-then-else constructs as well as many other programmatic functions available in PL/SQL. I suggest you get some documentation so that you can learn allthe available options you have as well as correct syntax, etc.
View Answer
| April 13, 2009 6:27 PM
CASE statement, IF THEN statement, IIF statement, Oracle developers, Oracle development, Oracle SQL, SQL
Oracle does indeed have if-then-else constructs as well as many other programmatic functions available in PL/SQL. I suggest you get some documentation so that you can learn allthe available options you have as well as correct syntax, etc.
View Answer
| April 13, 2009 6:27 PM
CASE statement, IF THEN statement, IIF statement, Oracle developers, Oracle development, Oracle SQL, SQL
How to automate getting the .CSV file from IFS folder to local desktop
I’m not sure I understand what you are asking. Are you asking how to open the file or how to get the file to the local PC? You can open the file on the IFS with Note pad, Word pad or Excel. If you are looking for how to get the file from the IFS [...]
View Answer
| April 13, 2009 2:55 PM
AS/400 import/export, CSV format, IFS Folder, RPG/400, RPGLE
I’m not sure I understand what you are asking. Are you asking how to open the file or how to get the file to the local PC? You can open the file on the IFS with Note pad, Word pad or Excel. If you are looking for how to get the file from the IFS [...]
View Answer
| April 13, 2009 2:55 PM
AS/400 import/export, CSV format, IFS Folder, RPG/400, RPGLE
