IT infrastruture
Hi, I have gone thru you mail and question? The course what u are doing now is also good and helps u in your present work. and If you ask me more then ……What I feel is you better go for network administration complete course in any good institute which is near to your home [...]
View Answer
| October 30, 2009 4:15 PM
Careers, CCNA, Certifications, IT careers, IT infrastruture
Hi, I have gone thru you mail and question? The course what u are doing now is also good and helps u in your present work. and If you ask me more then ……What I feel is you better go for network administration complete course in any good institute which is near to your home [...]
View Answer
| October 30, 2009 4:15 PM
Careers, CCNA, Certifications, IT careers, IT infrastruture
How to prepare for IT interview?
Just like any other kind of interview you want to dress professionally (we had a man interview wearing black shoes and white sports socks, YES your dress code matters! Yuck!) Do what you need to feel confident and act confident, not nervous. Be confident when asked something you don’t know and don’t be afraid to [...]
View Answer
| October 30, 2009 4:09 PM
Careers, Interviews, IT careers
Just like any other kind of interview you want to dress professionally (we had a man interview wearing black shoes and white sports socks, YES your dress code matters! Yuck!) Do what you need to feel confident and act confident, not nervous. Be confident when asked something you don’t know and don’t be afraid to [...]
View Answer
| October 30, 2009 4:09 PM
Careers, Interviews, IT careers
Error message in window subfile
I don’t see anything in your message subfile definition that tells it to associate with the window. Try adding this line to your subfile control record: <pre> A WINDOW( ZAH002WB )</pre> Tom
View Answer
| October 28, 2009 10:48 PM
AS/400, Database, DB2 Universal Database, RPG
I don’t see anything in your message subfile definition that tells it to associate with the window. Try adding this line to your subfile control record: <pre> A WINDOW( ZAH002WB )</pre> Tom
View Answer
| October 28, 2009 10:48 PM
AS/400, Database, DB2 Universal Database, RPG
AS400, SQL and COBOL anomalies
Are you sure the library list is the same? Is the COBOL program doing any overrides? I’d do a CHGJOB LOG(4 00 *SECLVL) and run the COBOL program again. Then check your joblog to see what shows up there.
View Answer
| October 28, 2009 2:25 PM
AS/400, COBOL, Embedded SQL, iSeries
Are you sure the library list is the same? Is the COBOL program doing any overrides? I’d do a CHGJOB LOG(4 00 *SECLVL) and run the COBOL program again. Then check your joblog to see what shows up there.
View Answer
| October 28, 2009 2:25 PM
AS/400, COBOL, Embedded SQL, iSeries
UDS and DS
Hi, The link to explain it is <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/books/c092508602.htm”></a> http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/books/c092508602.htm Wilson Reading the manual again, it may be difficult to understand… The U just indicate that the DS is associated to a Data Area and this Data Area must be read automatically at program initialization and write back at it’s end. The association can be [...]
View Answer
| October 27, 2009 3:20 PM
AS/400, AS/400 database, Data structures
Hi, The link to explain it is <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/books/c092508602.htm”></a> http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/books/c092508602.htm Wilson Reading the manual again, it may be difficult to understand… The U just indicate that the DS is associated to a Data Area and this Data Area must be read automatically at program initialization and write back at it’s end. The association can be [...]
View Answer
| October 27, 2009 3:20 PM
AS/400, AS/400 database, Data structures
What are the points to be taken care of when designing a database on Linux?
The same as designing a database on any other platform. On the hardware side make sure that you have enough RAM and CPU power. Make sure that you have enough disk space, and that the storage is fast enough. Make sure you have a way to back everything up. Within the database, use the correct [...]
View Answer
| October 27, 2009 3:43 AM
Database design, Database replication, Linux databases
The same as designing a database on any other platform. On the hardware side make sure that you have enough RAM and CPU power. Make sure that you have enough disk space, and that the storage is fast enough. Make sure you have a way to back everything up. Within the database, use the correct [...]
View Answer
| October 27, 2009 3:43 AM
Database design, Database replication, Linux databases
MS Access – Create Median Aggregate Function
Yes, There is a secret median function built into access. You tap your left mouse button 5 times as fast as you can, and then, very quickly, left click 6 times… bam! you have median function.
View Answer
| October 27, 2009 2:38 AM
Access 2007, Access 2007 functions, Access Functions, Aggregate function, Median, Microsoft Access
Yes, There is a secret median function built into access. You tap your left mouse button 5 times as fast as you can, and then, very quickly, left click 6 times… bam! you have median function.
View Answer
| October 27, 2009 2:38 AM
Access 2007, Access 2007 functions, Access Functions, Aggregate function, Median, Microsoft Access
SQL query help
Roughly this: Select partNo, max(Module), count(PartNbr) as “Numbers” from Myfile Group by partNo Phil
View Answer
| October 26, 2009 10:35 PM
SQL, SQL queries, SQL Query
Roughly this: Select partNo, max(Module), count(PartNbr) as “Numbers” from Myfile Group by partNo Phil
View Answer
| October 26, 2009 10:35 PM
SQL, SQL queries, SQL Query
MySQL database size
Yes, for sure it will effect performance. and u will have to tune it for great performance and add more memory for more space and fast running.
View Answer
| October 25, 2009 8:33 PM
MySQL, PHP, PHP Coding, SQL, SQL Database
Yes, for sure it will effect performance. and u will have to tune it for great performance and add more memory for more space and fast running.
View Answer
| October 25, 2009 8:33 PM
MySQL, PHP, PHP Coding, SQL, SQL Database
New To the Industry
http://technet.microsoft.com/en-ca/library/dd282984(WS.10).aspx http://www.computerperformance.co.uk/w2k3/W2K3_server_roles.htm
View Answer
| October 25, 2009 2:01 PM
Careers, IT careers, Networking careers, Networking certifications
http://technet.microsoft.com/en-ca/library/dd282984(WS.10).aspx http://www.computerperformance.co.uk/w2k3/W2K3_server_roles.htm
View Answer
| October 25, 2009 2:01 PM
Careers, IT careers, Networking careers, Networking certifications
get a anr record from databse by using max (one Field) and orderby (one filed) desc
There are several ways to do this using basic MAX and GROUP BY. Here are a couple of examples. <pre>create table temp1 ( secid number , atimestamp date , acode varchar2(1) ) / insert into temp1 values (1,sysdate-1,’a'); insert into temp1 select secid,atimestamp,’b’ from temp1; alter session set nls_date_format = ‘dd-mon-rrrr hh24:mi:ss’; select * from [...]
View Answer
| October 22, 2009 6:49 PM
Database issues, JOIN statement, Oracle Database
There are several ways to do this using basic MAX and GROUP BY. Here are a couple of examples. <pre>create table temp1 ( secid number , atimestamp date , acode varchar2(1) ) / insert into temp1 values (1,sysdate-1,’a'); insert into temp1 select secid,atimestamp,’b’ from temp1; alter session set nls_date_format = ‘dd-mon-rrrr hh24:mi:ss’; select * from [...]
View Answer
| October 22, 2009 6:49 PM
Database issues, JOIN statement, Oracle Database
SAP or Mainframe
Hey Buddy.. Dont think anything else except SAP. SAP ABAP is meant for science graduate or PG, since you are B.E then ABAP will be a definite choice to go ahead. all the best learning ABAP, but dont learn from who teach for 2-3 days a week an just 1.5 to 2 months coz if [...]
View Answer
| October 22, 2009 6:10 PM
Careers, COBOL, IT careers, Mainframe careers, SAP ABAP, SAP careers
Hey Buddy.. Dont think anything else except SAP. SAP ABAP is meant for science graduate or PG, since you are B.E then ABAP will be a definite choice to go ahead. all the best learning ABAP, but dont learn from who teach for 2-3 days a week an just 1.5 to 2 months coz if [...]
View Answer
| October 22, 2009 6:10 PM
Careers, COBOL, IT careers, Mainframe careers, SAP ABAP, SAP careers
Interview questions for an ATG commerce developer
Hi, What type of developers u need ,i can provide some type of questions let me explain what level ur interview .Junior developer or senior ..etc Mahaatg – how can I get the questions from you? I’m going to be interviewing some senior level people myself?
View Answer
| October 22, 2009 4:05 PM
ATG Commerce, ATG Commerce Development, Developers, Interviews, IT careers
Hi, What type of developers u need ,i can provide some type of questions let me explain what level ur interview .Junior developer or senior ..etc Mahaatg – how can I get the questions from you? I’m going to be interviewing some senior level people myself?
View Answer
| October 22, 2009 4:05 PM
ATG Commerce, ATG Commerce Development, Developers, Interviews, IT careers
The most-watched IT questions this week: Oct. 20, 2009
I haven’t looked at any of those !!
View Answer
| October 21, 2009 1:54 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
I haven’t looked at any of those !!
View Answer
| October 21, 2009 1:54 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
DB2/400 SQL Sub Query Performance?
Tip: The mentioned sub part: (EVHYY*10000 + EVHMM*100 + EVHDD)= 20040617 Can be set up in a more optimised way via: EVHYY = 2004 and EVHMM = 06 and EVHDD = 17 In case the first condition is not true, rest of condition(s) is/are not tested anymore….. Another option to optimise is to introduce a [...]
View Answer
| October 20, 2009 4:01 PM
Data warehousing/Business intelligence, Database Management Systems, DB2, DB2 Universal Database, UDB for iSeries/i5
Tip: The mentioned sub part: (EVHYY*10000 + EVHMM*100 + EVHDD)= 20040617 Can be set up in a more optimised way via: EVHYY = 2004 and EVHMM = 06 and EVHDD = 17 In case the first condition is not true, rest of condition(s) is/are not tested anymore….. Another option to optimise is to introduce a [...]
View Answer
| October 20, 2009 4:01 PM
Data warehousing/Business intelligence, Database Management Systems, DB2, DB2 Universal Database, UDB for iSeries/i5
SQL related tables
I do not know about putting in the XML tags – I know some version of DB2 will do it. But ignoring the XML, I see two different ways to get the data. 1) are you in a program? if so, open a cursor against product table and for every row open a cursor against [...]
View Answer
| October 19, 2009 8:26 PM
MySQL, MySQL 5.0, PHP, SQL Related Tables, SQL tables
I do not know about putting in the XML tags – I know some version of DB2 will do it. But ignoring the XML, I see two different ways to get the data. 1) are you in a program? if so, open a cursor against product table and for every row open a cursor against [...]
View Answer
| October 19, 2009 8:26 PM
MySQL, MySQL 5.0, PHP, SQL Related Tables, SQL tables
Triggers
QADBXTRIGB – but you cannot use ezview on it. ==================================================== Try the SYSTRIGGER view. You might need to specify the QSYS2 schema, depending on how you access it. Tom
View Answer
| October 19, 2009 10:24 AM
Architecture/Design, Database Management Systems, DB2, DB2 Implementation, i5, iSeries, OS/400, tips and tricks, Tools
QADBXTRIGB – but you cannot use ezview on it. ==================================================== Try the SYSTRIGGER view. You might need to specify the QSYS2 schema, depending on how you access it. Tom
View Answer
| October 19, 2009 10:24 AM
Architecture/Design, Database Management Systems, DB2, DB2 Implementation, i5, iSeries, OS/400, tips and tricks, Tools
ms sql query problem with a case statement
I assume the problem is with parenthesis placing the “As” inside. SUM(CASE WHEN passengers.pass_engers > passship.passship_size THEN ROUND((passship.passship_size * passengers.pass_price) / (hyperjump.hops * passship.passship_speed), 0) ELSE ROUND((passengers.pass_engers * passengers.pass_price) / (hyperjump.hops * passship.passship_speed), 0) END) AS ptprofit I still get errors trying to use the SUM This is what I ended up using and it [...]
View Answer
| October 18, 2009 5:25 AM
CASE statement, MSSQL, SQL
I assume the problem is with parenthesis placing the “As” inside. SUM(CASE WHEN passengers.pass_engers > passship.passship_size THEN ROUND((passship.passship_size * passengers.pass_price) / (hyperjump.hops * passship.passship_speed), 0) ELSE ROUND((passengers.pass_engers * passengers.pass_price) / (hyperjump.hops * passship.passship_speed), 0) END) AS ptprofit I still get errors trying to use the SUM This is what I ended up using and it [...]
View Answer
| October 18, 2009 5:25 AM
CASE statement, MSSQL, SQL
SQL query for same phone number
Something like this. <pre>SELECT * FROM YourTable JOIN (SELECT Phone, count(*) ct FROM YourTable GROUP BY Phone HAVING count(*) <> 1) a ON YourTable.Phone = a.Phone</pre> ————- kccrosser I am assuming that your question is: How do I list, by phone number, all those people where two or more people have called the same phone [...]
View Answer
| October 16, 2009 7:05 PM
SQL, SQL queries, SQL Query, SQL statements
Something like this. <pre>SELECT * FROM YourTable JOIN (SELECT Phone, count(*) ct FROM YourTable GROUP BY Phone HAVING count(*) <> 1) a ON YourTable.Phone = a.Phone</pre> ————- kccrosser I am assuming that your question is: How do I list, by phone number, all those people where two or more people have called the same phone [...]
View Answer
| October 16, 2009 7:05 PM
SQL, SQL queries, SQL Query, SQL statements
VB
You will need an additional component, since vb’s combo does not have that functionality. I have used the SolarWinds Auto Completion Combobox 2.1 (SWAutoCombo21IPAT.ocx), which <b>I think</b> gets installed when you install the SolarWinds free Ip Address Tracker. Here’s the link to download the tool, if you want to give it a try: <a href=”http://www.solarwinds.com/register/registration.aspx?program=912&c=70150000000Ehqn”>Free [...]
View Answer
| October 16, 2009 2:28 PM
Microsoft Access, VB, VB 6.0, Visual Basic
You will need an additional component, since vb’s combo does not have that functionality. I have used the SolarWinds Auto Completion Combobox 2.1 (SWAutoCombo21IPAT.ocx), which <b>I think</b> gets installed when you install the SolarWinds free Ip Address Tracker. Here’s the link to download the tool, if you want to give it a try: <a href=”http://www.solarwinds.com/register/registration.aspx?program=912&c=70150000000Ehqn”>Free [...]
View Answer
| October 16, 2009 2:28 PM
Microsoft Access, VB, VB 6.0, Visual Basic
