Bachelor of CSE vs Certifications
In my opinion there is no comparison between the two. The certifications can be accomplished thru boot camps which prep you for passing a test. The degrees demonstrate much more aptitude and cover much more material over many more hours of study and education. I personally see certifications necessary for government which requires such and [...]
View Answer
| August 4, 2009 9:27 PM
A+, A+ Certification, Careers, CCNA, Certifications, IT careers, MCSE
In my opinion there is no comparison between the two. The certifications can be accomplished thru boot camps which prep you for passing a test. The degrees demonstrate much more aptitude and cover much more material over many more hours of study and education. I personally see certifications necessary for government which requires such and [...]
View Answer
| August 4, 2009 9:27 PM
A+, A+ Certification, Careers, CCNA, Certifications, IT careers, MCSE
Qualified Data Structures
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/rzajp/rzajphoststrucirpg.htm By Qualifying datastructures, u could use different datastructures with same subfield definition To access a datasturcture subfield, u need to use “dsname.subfieldname”. Pramod
View Answer
| August 4, 2009 11:22 AM
Data structures, IBM RedBooks, Programming, Qualified Data Structures, RPG IV
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/rzajp/rzajphoststrucirpg.htm By Qualifying datastructures, u could use different datastructures with same subfield definition To access a datasturcture subfield, u need to use “dsname.subfieldname”. Pramod
View Answer
| August 4, 2009 11:22 AM
Data structures, IBM RedBooks, Programming, Qualified Data Structures, RPG IV
tablespace
in DB2, ALTER TABLESPACE … TRACKMOD yes/no would become effective immediately.
View Answer
| August 3, 2009 4:15 PM
DB2, TABLESPACES
in DB2, ALTER TABLESPACE … TRACKMOD yes/no would become effective immediately.
View Answer
| August 3, 2009 4:15 PM
DB2, TABLESPACES
Oracle 9i migration
I have never done that migration exactly, but have migrated Oracle DBs from / to AIX and MVS (OS/390, z/OS). Several approaches come to mind. > EXPORT / IMPORT. > If the two platforms can communicate, you might create the DB on the receiving platform and INSERT INTO new … SELECT … FROM old …
View Answer
| August 3, 2009 4:08 PM
Database migration, Oracle 9i migration, Oracle interoperability, Oracle migration, Oracle on Solaris, Oracle on Windows 2000 Server
I have never done that migration exactly, but have migrated Oracle DBs from / to AIX and MVS (OS/390, z/OS). Several approaches come to mind. > EXPORT / IMPORT. > If the two platforms can communicate, you might create the DB on the receiving platform and INSERT INTO new … SELECT … FROM old …
View Answer
| August 3, 2009 4:08 PM
Database migration, Oracle 9i migration, Oracle interoperability, Oracle migration, Oracle on Solaris, Oracle on Windows 2000 Server
Access – Bound sub form trying to set the value of an unbound field
This is not possible with a bound form. Access does not associate an unbound item with the bound record set so the result is the same value being displayed for all rows. The only way to display the value is to place the unbound field in the main form or the sub form’s header section [...]
View Answer
| July 31, 2009 2:25 PM
Access Database, Access Datasheet, Microsoft Access, Microsoft Access subforms, VBA
This is not possible with a bound form. Access does not associate an unbound item with the bound record set so the result is the same value being displayed for all rows. The only way to display the value is to place the unbound field in the main form or the sub form’s header section [...]
View Answer
| July 31, 2009 2:25 PM
Access Database, Access Datasheet, Microsoft Access, Microsoft Access subforms, VBA
MySQL Database – Multiple Images
With this design, if your requirements about the max number of images per user change in the future, you would have to add (or remove) columns to (from) your table, so I would probably not recommend this approach. How about something like this for the second table: <pre>User_id Image_no Image_url</pre> This way, you could have [...]
View Answer
| July 30, 2009 8:35 PM
MySQL, MySQL Database
With this design, if your requirements about the max number of images per user change in the future, you would have to add (or remove) columns to (from) your table, so I would probably not recommend this approach. How about something like this for the second table: <pre>User_id Image_no Image_url</pre> This way, you could have [...]
View Answer
| July 30, 2009 8:35 PM
MySQL, MySQL Database
learning-sql-part-2
Any book on SQL — Access supports 85% of the standard. This isn’t the best way to go. I think it will be very slow – SQL is running on you PC and every record from the 400 must be sent even if it’s eventually excluded by your Query. You can run SQL from your [...]
View Answer
| October 9, 2012 3:48 PM
AS/400, AS/400 SQL, Microsoft Access, SQL, SQL Training
Any book on SQL — Access supports 85% of the standard. This isn’t the best way to go. I think it will be very slow – SQL is running on you PC and every record from the 400 must be sent even if it’s eventually excluded by your Query. You can run SQL from your [...]
View Answer
| October 9, 2012 3:48 PM
AS/400, AS/400 SQL, Microsoft Access, SQL, SQL Training
After trigger select from other tables using joins
The most likely reason your trigger is doing jack is because of this: EXCEPTION – If an exception is raised, exit gracefully WHEN OTHERS THEN NULL; Do not take this as an offence, but this is considered by the oracle community to be the stupidest piece of code anyone can write. Many people do it. [...]
View Answer
| July 30, 2009 3:47 AM
LEFT OUTER JOIN statement, Oracle, Oracle triggers, Triggers
The most likely reason your trigger is doing jack is because of this: EXCEPTION – If an exception is raised, exit gracefully WHEN OTHERS THEN NULL; Do not take this as an offence, but this is considered by the oracle community to be the stupidest piece of code anyone can write. Many people do it. [...]
View Answer
| July 30, 2009 3:47 AM
LEFT OUTER JOIN statement, Oracle, Oracle triggers, Triggers
Database modeling question
Based on the information you have provided, I would choose the first model. It is more flexible, scalable, <b>and it is normalized</b>. Let’s talk about the second model. In the CONTEXTS table, the name column is going to refer to the context name, or the property name ? Maybe he wants to add another ‘name’ [...]
View Answer
| July 30, 2009 3:12 AM
Database, Modeling, Normalization
Based on the information you have provided, I would choose the first model. It is more flexible, scalable, <b>and it is normalized</b>. Let’s talk about the second model. In the CONTEXTS table, the name column is going to refer to the context name, or the property name ? Maybe he wants to add another ‘name’ [...]
View Answer
| July 30, 2009 3:12 AM
Database, Modeling, Normalization
How to implement row level security
Hello, as the moderator said you could have added some additional info, but in general one can implement row level locking by specifying locksize parm on the CREATE TABLESPACE or CREATED TABLE statement (depending on which RDBMS you are using.)
View Answer
| July 29, 2009 4:10 PM
Database security, Row Level Security
Hello, as the moderator said you could have added some additional info, but in general one can implement row level locking by specifying locksize parm on the CREATE TABLESPACE or CREATED TABLE statement (depending on which RDBMS you are using.)
View Answer
| July 29, 2009 4:10 PM
Database security, Row Level Security
Inner join Solution
Hi – Are the columns involved in the join indexed? What is the cardinality of these columns (are they unique)? Do you have current statistics on these tables? Have you explained the access path for this statement? EXPLAIN will give you lots of information about how the data is being accessed and with that you [...]
View Answer
| July 29, 2009 3:10 PM
INNER JOIN statement, SQL
Hi – Are the columns involved in the join indexed? What is the cardinality of these columns (are they unique)? Do you have current statistics on these tables? Have you explained the access path for this statement? EXPLAIN will give you lots of information about how the data is being accessed and with that you [...]
View Answer
| July 29, 2009 3:10 PM
INNER JOIN statement, SQL
Tables in DB2 z/OS
Your question is not very specific, and I do not know what you mean by the “default tables”. but let me try to address the topic. DB2 z/OS consists of many datasets. Each tablespace and each index space will be made up of one (or more) VSAM LINEAR datasets. The naming convention for these datasets [...]
View Answer
| July 28, 2009 4:09 PM
DB2, DB2 Everyplace, Mainframe Datasets, Mobile development, z/OS
Your question is not very specific, and I do not know what you mean by the “default tables”. but let me try to address the topic. DB2 z/OS consists of many datasets. Each tablespace and each index space will be made up of one (or more) VSAM LINEAR datasets. The naming convention for these datasets [...]
View Answer
| July 28, 2009 4:09 PM
DB2, DB2 Everyplace, Mainframe Datasets, Mobile development, z/OS
new to IT looking to improve & make career in networking
The <a href=”http://www.comptia.org/certifications/listed/network.aspx”>Comptia Network+ certification</a> is a good baseline for network knowledge. As others say here, nothing can replace experience. So practice networking on your own network or volunteer for some organization needing assistance with theirs.
View Answer
| July 24, 2009 5:27 PM
IT careers, Network administration, Networking careers, Systems administration
The <a href=”http://www.comptia.org/certifications/listed/network.aspx”>Comptia Network+ certification</a> is a good baseline for network knowledge. As others say here, nothing can replace experience. So practice networking on your own network or volunteer for some organization needing assistance with theirs.
View Answer
| July 24, 2009 5:27 PM
IT careers, Network administration, Networking careers, Systems administration
Did anyone use DATA structures In CL
It isn’t a data structure exactly, its just a new tag against a memory location. so a 20 byte field can be addressed at the start, for 10 bytes, or at position 11, for 10 bytes. You would have to pass your ‘data structure’ as a field of length = DS length, then assign the [...]
View Answer
| July 24, 2009 4:15 PM
CL, CLLE, Data structures
It isn’t a data structure exactly, its just a new tag against a memory location. so a 20 byte field can be addressed at the start, for 10 bytes, or at position 11, for 10 bytes. You would have to pass your ‘data structure’ as a field of length = DS length, then assign the [...]
View Answer
| July 24, 2009 4:15 PM
CL, CLLE, Data structures
Access 2003 default record locking
I would have thought so also. I found an interesting tidbit while looking at the Access Help for record locking. At the very end of the Help topic it says, “This setting takes effect the next time you open the Access database, but you must use the Open command on the File menu rather than [...]
View Answer
| July 23, 2009 2:17 PM
Access 2003
I would have thought so also. I found an interesting tidbit while looking at the Access Help for record locking. At the very end of the Help topic it says, “This setting takes effect the next time you open the Access database, but you must use the Open command on the File menu rather than [...]
View Answer
| July 23, 2009 2:17 PM
Access 2003
what is rack awareness of HDFS?
“…Large HDFS instances run on a cluster of computers that commonly spread across many racks. Communication between two nodes in different racks has to go through switches. In most cases, network bandwidth between machines in the same rack is greater than network bandwidth between machines in different racks…”. The idea is that the rack id [...]
View Answer
| July 21, 2009 8:18 PM
Database optimization, HDFS, Network performance, Rack Awareness
“…Large HDFS instances run on a cluster of computers that commonly spread across many racks. Communication between two nodes in different racks has to go through switches. In most cases, network bandwidth between machines in the same rack is greater than network bandwidth between machines in different racks…”. The idea is that the rack id [...]
View Answer
| July 21, 2009 8:18 PM
Database optimization, HDFS, Network performance, Rack Awareness
How to pull a query on a particular table based on form selection
How about the posibility of a design change ? It would be better to have one table for students, and a field to identify what class the student is in. If that’s not an option, have a look to this Microsoft article, which might help you: <a href=”http://support.microsoft.com/kb/304302″>How to build a dynamic query with values [...]
View Answer
| July 21, 2009 6:51 PM
Access forms, Microsoft Access
How about the posibility of a design change ? It would be better to have one table for students, and a field to identify what class the student is in. If that’s not an option, have a look to this Microsoft article, which might help you: <a href=”http://support.microsoft.com/kb/304302″>How to build a dynamic query with values [...]
View Answer
| July 21, 2009 6:51 PM
Access forms, Microsoft Access
Improving the initial speed of a SQL query
I think this is the same question as <a href=”http://itknowledgeexchange.techtarget.com/itanswers/sql-server-2005-query-very-slow-in-the-first-run/”>this one</a>, which was already answered by Kccrosser.
View Answer
| July 21, 2009 6:21 PM
SQL queries, SQL Query, SQL query optimization
I think this is the same question as <a href=”http://itknowledgeexchange.techtarget.com/itanswers/sql-server-2005-query-very-slow-in-the-first-run/”>this one</a>, which was already answered by Kccrosser.
View Answer
| July 21, 2009 6:21 PM
SQL queries, SQL Query, SQL query optimization
Storage Career Info. needed
I’ve always been partial to vendor-neutral certifications that you can use anywhere you work. I’d recommend looking into <a href=”http://www.snia.org/education/certification/”>SNIA’s offerings</a>. Also, check out Greg Shulz’s article on this <a href=”http://searchstorage.techtarget.com/tip/0,289483,sid5_gci1193307,00.html”>here</a>. Don’t get too caught up in certification though as I discuss in <a href=”http://searchsoftwarequality.techtarget.com/news/column/0,294698,sid92_gci1334513,00.html”>this TechTarget article</a> and in the other bits on my <a [...]
View Answer
| July 20, 2009 3:35 PM
IT careers, Storage careers, Storage certifications
I’ve always been partial to vendor-neutral certifications that you can use anywhere you work. I’d recommend looking into <a href=”http://www.snia.org/education/certification/”>SNIA’s offerings</a>. Also, check out Greg Shulz’s article on this <a href=”http://searchstorage.techtarget.com/tip/0,289483,sid5_gci1193307,00.html”>here</a>. Don’t get too caught up in certification though as I discuss in <a href=”http://searchsoftwarequality.techtarget.com/news/column/0,294698,sid92_gci1334513,00.html”>this TechTarget article</a> and in the other bits on my <a [...]
View Answer
| July 20, 2009 3:35 PM
IT careers, Storage careers, Storage certifications
SQL Server 2005 Query Very Slow in the first run
It isn’t the query plan that is getting cached – it is the actual data and indexes which are being cached. This is common behavior of any database. If you ran the query, then waited a while and ran again (keeping the session active), you would see the query take longer again, based on the [...]
View Answer
| July 17, 2009 4:59 PM
SQL queries, SQL query optimization, SQL Server 2005
It isn’t the query plan that is getting cached – it is the actual data and indexes which are being cached. This is common behavior of any database. If you ran the query, then waited a while and ran again (keeping the session active), you would see the query take longer again, based on the [...]
View Answer
| July 17, 2009 4:59 PM
SQL queries, SQL query optimization, SQL Server 2005
