Data centre certification course
You can always opt for any of the following Certifications from Cisco The Cisco Data Center certifications validate proficiency in designing, installing, and supporting a data center networking solution. Data Center Networking Infrastructure Cisco Data Center Networking Infrastructure Design Specialist Cisco Data Center Networking Infrastructure Support Specialist Cisco Data Center Networking Sales Specialist Data Center [...]
View Answer
| September 9, 2008 7:16 AM
Data center certification, IT careers
You can always opt for any of the following Certifications from Cisco The Cisco Data Center certifications validate proficiency in designing, installing, and supporting a data center networking solution. Data Center Networking Infrastructure Cisco Data Center Networking Infrastructure Design Specialist Cisco Data Center Networking Infrastructure Support Specialist Cisco Data Center Networking Sales Specialist Data Center [...]
View Answer
| September 9, 2008 7:16 AM
Data center certification, IT careers
Need career advise ORACLE or SAP?
I would go online and check if there are more opportunities in Oracle Financials or in SAP, regardless you have to learn a new software package as all companies use an Accounting software package these days. The sooner you learn the better it is for you. I can talk about SAP as don’t know Oracle [...]
View Answer
| September 9, 2008 6:58 AM
IT careers, Oracle certifications, SAP careers
I would go online and check if there are more opportunities in Oracle Financials or in SAP, regardless you have to learn a new software package as all companies use an Accounting software package these days. The sooner you learn the better it is for you. I can talk about SAP as don’t know Oracle [...]
View Answer
| September 9, 2008 6:58 AM
IT careers, Oracle certifications, SAP careers
Pivot Table Error Field Message
Obviously your initial connection is lost. Not knowing which versions of Excel & Access you are using – here are my comments on Access 2007 & Excel 2007. You may try to re-connect the fields from access database (Of course this assumes you know the table name or the query name!). Click on the Excel [...]
View Answer
| September 8, 2008 4:15 PM
Access Database, Microsoft Access, Pivot tables
Obviously your initial connection is lost. Not knowing which versions of Excel & Access you are using – here are my comments on Access 2007 & Excel 2007. You may try to re-connect the fields from access database (Of course this assumes you know the table name or the query name!). Click on the Excel [...]
View Answer
| September 8, 2008 4:15 PM
Access Database, Microsoft Access, Pivot tables
returnning to IT
You can get an associates degree in IT from many places. But generally more involved degrees like MIS will take 4 years to complete (depending on the school). Hope this helps! -Schmidtw ************************************************ Adding Comptia certifications, such as A+, Network+, ans Security+ will help you out. They are not that expensive, though you DO have [...]
View Answer
| September 8, 2008 3:44 PM
IT careers
You can get an associates degree in IT from many places. But generally more involved degrees like MIS will take 4 years to complete (depending on the school). Hope this helps! -Schmidtw ************************************************ Adding Comptia certifications, such as A+, Network+, ans Security+ will help you out. They are not that expensive, though you DO have [...]
View Answer
| September 8, 2008 3:44 PM
IT careers
How to create Dynamic DDS for a PF(Physical File In AS/400)
Frequently this is done in SQL with a Drop table and Create table commands. But an RPG program could open the QDDSSRC member, alter the file description, close the file and then issue the crtpf or chgPF command.
View Answer
| September 8, 2008 3:39 PM
CREATE TABLE statement, DDS, Physical File
Frequently this is done in SQL with a Drop table and Create table commands. But an RPG program could open the QDDSSRC member, alter the file description, close the file and then issue the crtpf or chgPF command.
View Answer
| September 8, 2008 3:39 PM
CREATE TABLE statement, DDS, Physical File
Community Update: New Member Contest Win a XBox 360 this month for your participation.
<b>Update 9/8</b> Things are close after the first week and it is still anybody’s contest to win After the first week the standings are: MrDenny 645 SchmidtW 625 Labnuke99 435 WRobinson 435 There is still time for other to gain Knowledge Points by asking, answering and discussing questions.
View Answer
| September 8, 2008 1:42 PM
AS/400, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, Storage, Virtualization, Virtualization and the hypervisor, VoIP
<b>Update 9/8</b> Things are close after the first week and it is still anybody’s contest to win After the first week the standings are: MrDenny 645 SchmidtW 625 Labnuke99 435 WRobinson 435 There is still time for other to gain Knowledge Points by asking, answering and discussing questions.
View Answer
| September 8, 2008 1:42 PM
AS/400, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, Storage, Virtualization, Virtualization and the hypervisor, VoIP
Sum Values Of A Particular Column In A Tilde Delimited File on Solaris
<pre>awk -F~ ‘{total+=$3} END{print total}’ /tmp/foo</pre> assuming your file is /tmp/foo. You may have to use gawk instead of awk on Solaris. I don’t have a solaris box to try it on.
View Answer
| September 6, 2008 1:43 AM
Database, DataManagement, Development, Unix
<pre>awk -F~ ‘{total+=$3} END{print total}’ /tmp/foo</pre> assuming your file is /tmp/foo. You may have to use gawk instead of awk on Solaris. I don’t have a solaris box to try it on.
View Answer
| September 6, 2008 1:43 AM
Database, DataManagement, Development, Unix
Access 2007 Complex Calculations
You could use Make table queries to do your calculations. This would perform the calculations and make the Post-Calculation tables at the same time. Keep in mind that each time you run Make Table queries, the destination table is always deleted first. Otherwise, make the tables first and then append the calculated rows into those [...]
View Answer
| September 5, 2008 6:27 PM
Complex Database Calculations, Database, Database design, Linear trends, Microsoft Access
You could use Make table queries to do your calculations. This would perform the calculations and make the Post-Calculation tables at the same time. Keep in mind that each time you run Make Table queries, the destination table is always deleted first. Otherwise, make the tables first and then append the calculated rows into those [...]
View Answer
| September 5, 2008 6:27 PM
Complex Database Calculations, Database, Database design, Linear trends, Microsoft Access
Salary range or Hr paygrade
Salary range questions are very hard to answer as there are a lot of variables. 1. Experience 2. Environment Size 3. Location 4. Job Market Your best bet will be to go to a job survey site such as salary.com.
View Answer
| September 4, 2008 4:33 PM
CTMS, IT careers, Telecom, Telecom Careers
Salary range questions are very hard to answer as there are a lot of variables. 1. Experience 2. Environment Size 3. Location 4. Job Market Your best bet will be to go to a job survey site such as salary.com.
View Answer
| September 4, 2008 4:33 PM
CTMS, IT careers, Telecom, Telecom Careers
Converting from System 36 to iSeries V5R4
I recently finished a project exactly like that. First always start with the file structures. Go thru your ocl and see where they build files on the fly and those should be modified. All files should be converted to DDS and appropriate logical files if needed. For logical files, look at your ocl and see [...]
View Answer
| September 4, 2008 2:43 PM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, RPG, RPGLE
I recently finished a project exactly like that. First always start with the file structures. Go thru your ocl and see where they build files on the fly and those should be modified. All files should be converted to DDS and appropriate logical files if needed. For logical files, look at your ocl and see [...]
View Answer
| September 4, 2008 2:43 PM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, RPG, RPGLE
converting files Lotus to Microsoft
I don’t have any specific understanding of Lotus Approach 97, but can tell you what technologists do to extract data from one system and import to another, if that will help. In Lotus Approach, in a screen that shows all the information you want extract, look for an export function (in Lotus Notes, this is [...]
View Answer
| September 4, 2008 2:42 PM
Data Coversion, Lotus Approach, Microsoft Access
I don’t have any specific understanding of Lotus Approach 97, but can tell you what technologists do to extract data from one system and import to another, if that will help. In Lotus Approach, in a screen that shows all the information you want extract, look for an export function (in Lotus Notes, this is [...]
View Answer
| September 4, 2008 2:42 PM
Data Coversion, Lotus Approach, Microsoft Access
Should we use Web services to develop this integrated application?
Web service will give you the most portable solution and allow you the most flexible solution in the long run.
View Answer
| September 4, 2008 5:56 AM
Access Database, Microsoft Excel, PDAs, Research Assistant, SOA and Web services, Visual Basic, Visual Basic 2005, Web services
Web service will give you the most portable solution and allow you the most flexible solution in the long run.
View Answer
| September 4, 2008 5:56 AM
Access Database, Microsoft Excel, PDAs, Research Assistant, SOA and Web services, Visual Basic, Visual Basic 2005, Web services
Adding prefix to records
Yes, you can add prefix with UPDATE statement, however syntax may slightly differ in different RDBMS This is how you can do in Oracle: <pre> UPDATE table1 SET colomnnameSKU =’GF-’ || SKU WHERE upper(colomnnameSKU) like ‘SKU%’;</pre> The Access syntax will look slightly different. <pre>UPDATE YourTable Set Sku ‘GF-’ + Sku WHERE Sku NOT LIKE ‘GF-%’</pre>
View Answer
| September 4, 2008 5:45 AM
Database programming, Microsoft Access, UPDATE statement
Yes, you can add prefix with UPDATE statement, however syntax may slightly differ in different RDBMS This is how you can do in Oracle: <pre> UPDATE table1 SET colomnnameSKU =’GF-’ || SKU WHERE upper(colomnnameSKU) like ‘SKU%’;</pre> The Access syntax will look slightly different. <pre>UPDATE YourTable Set Sku ‘GF-’ + Sku WHERE Sku NOT LIKE ‘GF-%’</pre>
View Answer
| September 4, 2008 5:45 AM
Database programming, Microsoft Access, UPDATE statement
Job Outlook for Software Testers
Good luck with your continued job hunt. I’ve been there myself (in-between assignments), it’s never fun. When you say you have sent out 150 resumes, I have to ask if you are working with any IT staffing firms…recruiters, consulting companies, etc., or whether you are just on-line applying to every Career Builder and Monster job [...]
View Answer
| September 3, 2008 4:02 PM
IT careers, Software testing
Good luck with your continued job hunt. I’ve been there myself (in-between assignments), it’s never fun. When you say you have sent out 150 resumes, I have to ask if you are working with any IT staffing firms…recruiters, consulting companies, etc., or whether you are just on-line applying to every Career Builder and Monster job [...]
View Answer
| September 3, 2008 4:02 PM
IT careers, Software testing
parallel port
This post should give you the answer to your problems: http://www.computer-u.com/FoxPro26USB.htm Hope this helps. CG._
View Answer
| September 3, 2008 3:13 PM
FoxPro 2.6, Printing, USB, USB ports
This post should give you the answer to your problems: http://www.computer-u.com/FoxPro26USB.htm Hope this helps. CG._
View Answer
| September 3, 2008 3:13 PM
FoxPro 2.6, Printing, USB, USB ports
Error message during database mirroring on SQL Server 2005
All three instances are hosted on the same machine, so the ALTER DATABASE command for each database should be the same, with only the port number being changed.
View Answer
| September 2, 2008 9:36 PM
Database mirroring, SQL Server 2005, SQL Server errors
All three instances are hosted on the same machine, so the ALTER DATABASE command for each database should be the same, with only the port number being changed.
View Answer
| September 2, 2008 9:36 PM
Database mirroring, SQL Server 2005, SQL Server errors
Lacking a FQDN during database mirroring on SQL Server 2005
If SQL is telling you that it can’t see the FQDN then either it can’t see the internal DNS server, or the SQL Server can not be found in the domains DNS server. Use the nslookup command line tool to check that DNS is setup correctly for the machine. <pre>nslookup SQLServer.yourdomain.local</pre> Or check with your [...]
View Answer
| September 2, 2008 9:34 PM
Database mirroring, FQDN, SQL Server 2005, SQL Server errors, TCP
If SQL is telling you that it can’t see the FQDN then either it can’t see the internal DNS server, or the SQL Server can not be found in the domains DNS server. Use the nslookup command line tool to check that DNS is setup correctly for the machine. <pre>nslookup SQLServer.yourdomain.local</pre> Or check with your [...]
View Answer
| September 2, 2008 9:34 PM
Database mirroring, FQDN, SQL Server 2005, SQL Server errors, TCP
AS400-DML
The SQL creates a file with the record format named the same as the file. The RPG F spec should include RENAME(Employee : EmpRec) Then when you are adding a record you Write EmpRec.
View Answer
| September 2, 2008 6:20 PM
DML, RNF2109 Error, RPGLE
The SQL creates a file with the record format named the same as the file. The RPG F spec should include RENAME(Employee : EmpRec) Then when you are adding a record you Write EmpRec.
View Answer
| September 2, 2008 6:20 PM
DML, RNF2109 Error, RPGLE
Compile Error
Is it possible that you mean <pre>If Not IsNull(DLookup(“[PositionType]“, “JobOrderInfo”, “[EmployerID] = ” & Me.EmployerID & ” AND [PositionType] = “”" & Me.PositionType & “”"”) )Then </pre> as the intended code?
View Answer
| August 30, 2008 9:05 AM
Compile error, Database programming, Microsoft Access
Is it possible that you mean <pre>If Not IsNull(DLookup(“[PositionType]“, “JobOrderInfo”, “[EmployerID] = ” & Me.EmployerID & ” AND [PositionType] = “”" & Me.PositionType & “”"”) )Then </pre> as the intended code?
View Answer
| August 30, 2008 9:05 AM
Compile error, Database programming, Microsoft Access
AUTO INCREMENT
Hi, There is no equivalent to Auto Increment Field in DDS – you may however be able to implement something which will give the same result if you create a trigger program for your file which updates a newly added record with the next available number. Regards, Martin Gilbert. Hi from PGMBOB, In an RPG [...]
View Answer
| August 30, 2008 2:55 AM
Auto increment, DDS, MySQL, PHP
Hi, There is no equivalent to Auto Increment Field in DDS – you may however be able to implement something which will give the same result if you create a trigger program for your file which updates a newly added record with the next available number. Regards, Martin Gilbert. Hi from PGMBOB, In an RPG [...]
View Answer
| August 30, 2008 2:55 AM
Auto increment, DDS, MySQL, PHP
