how to restart my career after 5 years gap with SAP
Just start the 1st try with Mr. Vishal from Delhi. Talk to him regarding you SAP plans. I hope he can help you. You can reach him on +91 9910101444. Regards
View Answer
| December 21, 2009 7:38 PM
IT careers, SAP, SAP careers
Just start the 1st try with Mr. Vishal from Delhi. Talk to him regarding you SAP plans. I hope he can help you. You can reach him on +91 9910101444. Regards
View Answer
| December 21, 2009 7:38 PM
IT careers, SAP, SAP careers
odbc data source
In ODBC data source System DSN Add new DSN Name = test Desc = test server = lksql Next user login id and password enterer by user check Connect to sql server to obtain default setting enter user name and pw next change the default database to: only has the default db the user is [...]
View Answer
| December 21, 2009 5:27 PM
ODBC, ODBC Errors, SQL 2000, SQL 2008
In ODBC data source System DSN Add new DSN Name = test Desc = test server = lksql Next user login id and password enterer by user check Connect to sql server to obtain default setting enter user name and pw next change the default database to: only has the default db the user is [...]
View Answer
| December 21, 2009 5:27 PM
ODBC, ODBC Errors, SQL 2000, SQL 2008
SQL server production virtualization – to do or not to do
Typically large high transaction SQL Servers are not typically good candidates for virtualization. First when you virtualize a server you can’t assign as more cores to the VM as you currently have. The most cores you can assign are the number of cores on a single physical CPU. So if your VMware server has 4 [...]
View Answer
| December 16, 2009 3:24 AM
Database, Database administration, Enterprise Virtualization, SQL Server Virtualization
Typically large high transaction SQL Servers are not typically good candidates for virtualization. First when you virtualize a server you can’t assign as more cores to the VM as you currently have. The most cores you can assign are the number of cores on a single physical CPU. So if your VMware server has 4 [...]
View Answer
| December 16, 2009 3:24 AM
Database, Database administration, Enterprise Virtualization, SQL Server Virtualization
SAP certification?
Probably not, as Demir Barlas writes on <a href=”http://itknowledgeexchange.techtarget.com/sap-watch/sap-certification-not-worth-much/”>SAP Watch</a>: <i>Anyone who follows SAP forums or mail groups will be intimately acquainted with variations on this message: Which certification will get me an SAP job? The question gets asked over and over because the answer is too unpleasant for people to accept: <b>Only actual SAP [...]
View Answer
| December 15, 2009 6:04 PM
Careers, CCNA, Certifications, IT careers, ITIL, SAP, SAP careers, SAP certifications
Probably not, as Demir Barlas writes on <a href=”http://itknowledgeexchange.techtarget.com/sap-watch/sap-certification-not-worth-much/”>SAP Watch</a>: <i>Anyone who follows SAP forums or mail groups will be intimately acquainted with variations on this message: Which certification will get me an SAP job? The question gets asked over and over because the answer is too unpleasant for people to accept: <b>Only actual SAP [...]
View Answer
| December 15, 2009 6:04 PM
Careers, CCNA, Certifications, IT careers, ITIL, SAP, SAP careers, SAP certifications
Using Right() inside SQL Join
What hardware and software are you using? ———– Yes, you can do that on MySql. Remember that aplying functions to fields in the where clause, prevents the database system from using indexes. -CarlosDL
View Answer
| December 15, 2009 5:06 PM
MySQL functions, RIGHT JOIN, SQL join
What hardware and software are you using? ———– Yes, you can do that on MySql. Remember that aplying functions to fields in the where clause, prevents the database system from using indexes. -CarlosDL
View Answer
| December 15, 2009 5:06 PM
MySQL functions, RIGHT JOIN, SQL join
Authorization problem on DDM file in RPG program
I dont think special authority *SECOFR will help in this case. You need a user profile on the target machine that has specific authority to the object. View the authority to the object with DSPOBJAUT. ===================================================== It will depend on how your DDM is configured, SNA or IP. Nowadays, DDM over IP will be easier. [...]
View Answer
| December 15, 2009 8:17 AM
DB2 Universal Database, RPG, Security
I dont think special authority *SECOFR will help in this case. You need a user profile on the target machine that has specific authority to the object. View the authority to the object with DSPOBJAUT. ===================================================== It will depend on how your DDM is configured, SNA or IP. Nowadays, DDM over IP will be easier. [...]
View Answer
| December 15, 2009 8:17 AM
DB2 Universal Database, RPG, Security
embedded sql update
A couple of thoughts. 1. do you need to use COMMIT(NC). It could be changing the data but because of no commit, it does a rollback. 2. If you run the statement with STRSAL does it change any data/
View Answer
| December 14, 2009 6:04 PM
Embedded SQL, RPGLE, SQL
A couple of thoughts. 1. do you need to use COMMIT(NC). It could be changing the data but because of no commit, it does a rollback. 2. If you run the statement with STRSAL does it change any data/
View Answer
| December 14, 2009 6:04 PM
Embedded SQL, RPGLE, SQL
Access Oracle/Sybase/Informix from RPG
I know you don’t want to use Java but I believe you could setup the JDBC driver and use RPG ILE api’s to access it. And have the JDBC driver on your external computers. We are currently looking at that now but have not went any further than discovery. ======================================================== It isn’t the opposite of [...]
View Answer
| December 14, 2009 7:52 AM
Application development, AS/400, Database, DataCenter, DB2, DB2 Universal Database, Oracle, RPG, RPGLE, SQL, Web development
I know you don’t want to use Java but I believe you could setup the JDBC driver and use RPG ILE api’s to access it. And have the JDBC driver on your external computers. We are currently looking at that now but have not went any further than discovery. ======================================================== It isn’t the opposite of [...]
View Answer
| December 14, 2009 7:52 AM
Application development, AS/400, Database, DataCenter, DB2, DB2 Universal Database, Oracle, RPG, RPGLE, SQL, Web development
Stored Procedures on AS/400
It depends on how you measure efficiency. For example the generated C code is not as fast as well crafted code. However the user response time difference is likely to be trivial. For developer efficiency, I can build, test and deploy 3 SQL stored procedures in a half hour while an RPG developer takes 2 [...]
View Answer
| December 14, 2009 1:52 AM
Application development, AS/400, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, RPG, RPGLE, SQL, SQL Server, Web development, Web development tools, WebSphere Studio
It depends on how you measure efficiency. For example the generated C code is not as fast as well crafted code. However the user response time difference is likely to be trivial. For developer efficiency, I can build, test and deploy 3 SQL stored procedures in a half hour while an RPG developer takes 2 [...]
View Answer
| December 14, 2009 1:52 AM
Application development, AS/400, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, RPG, RPGLE, SQL, SQL Server, Web development, Web development tools, WebSphere Studio
Retrieval of Extended Source Library Information
If I undestand correctly, all you have to do is copy the source to a regular physical file, big enough to hold all the information. You can do it using the command CPYSRCF. ============================================================ FTP is not an OS/400 facility — it’s a standard cross-platform TCP/IP utility. As such, it has no knowledge of platform [...]
View Answer
| December 14, 2009 12:40 AM
AS/400, DB2 Universal Database, PC/Windows Connectivity
If I undestand correctly, all you have to do is copy the source to a regular physical file, big enough to hold all the information. You can do it using the command CPYSRCF. ============================================================ FTP is not an OS/400 facility — it’s a standard cross-platform TCP/IP utility. As such, it has no knowledge of platform [...]
View Answer
| December 14, 2009 12:40 AM
AS/400, DB2 Universal Database, PC/Windows Connectivity
Help with converting Mainframe file on iSeries
Hi Not sure I understand the difference fully, but the ILE Cobol Reference Manual for v5r2 says that COMP is used for representing Packed Decimal values and also that COMP-3 is for packed decimals too. The difference seems to be whether the length is odd or even, COMP-3 seems to be the one to use [...]
View Answer
| December 13, 2009 10:06 PM
AS/400, DB2 Universal Database, PC/Windows Connectivity
Hi Not sure I understand the difference fully, but the ILE Cobol Reference Manual for v5r2 says that COMP is used for representing Packed Decimal values and also that COMP-3 is for packed decimals too. The difference seems to be whether the length is odd or even, COMP-3 seems to be the one to use [...]
View Answer
| December 13, 2009 10:06 PM
AS/400, DB2 Universal Database, PC/Windows Connectivity
Job Schedule Entries Migration
IBM OS/400 and IBM i5/OS? Job Schedule Entries Technote What file contains job schedule entries for the standard job scheduler (WRKJOBSCDE)? Answer: Object QDFTJOBSCD in library QUSRSYS, object type *JOBSCD contains job schedule entries. This object may be restored from a backup. ====================================================== The job scheduler object can be saved and restored. If you’re migrating [...]
View Answer
| December 13, 2009 12:04 PM
Application development, AS/400, Backup & recovery, CLP, DataCenter, DB2 Universal Database, RPG, RPGLE
IBM OS/400 and IBM i5/OS? Job Schedule Entries Technote What file contains job schedule entries for the standard job scheduler (WRKJOBSCDE)? Answer: Object QDFTJOBSCD in library QUSRSYS, object type *JOBSCD contains job schedule entries. This object may be restored from a backup. ====================================================== The job scheduler object can be saved and restored. If you’re migrating [...]
View Answer
| December 13, 2009 12:04 PM
Application development, AS/400, Backup & recovery, CLP, DataCenter, DB2 Universal Database, RPG, RPGLE
What is difference between RDBMS & ORDBMS?
RDBMS = Remote DataBase Management System ORDBMD = Oracle Remote DataBase Management System (I would assume) ———-msi77 RDBMS = Relational DataBase Management System ORDBMS = Object-Relational DataBase Management System
View Answer
| December 11, 2009 6:25 PM
ORDBMS, RDBMS
RDBMS = Remote DataBase Management System ORDBMD = Oracle Remote DataBase Management System (I would assume) ———-msi77 RDBMS = Relational DataBase Management System ORDBMS = Object-Relational DataBase Management System
View Answer
| December 11, 2009 6:25 PM
ORDBMS, RDBMS
The most-watched IT questions this week: Dec. 1, 2009
Oh what a disappointment, there must be a lot more people curious about Foxpro than the AS/400. Phil What I feel is that if we start time limit in which a question can be answered, then we will have vastly reduced the effectiveness of this site.
View Answer
| December 11, 2009 4:42 AM
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
Oh what a disappointment, there must be a lot more people curious about Foxpro than the AS/400. Phil What I feel is that if we start time limit in which a question can be answered, then we will have vastly reduced the effectiveness of this site.
View Answer
| December 11, 2009 4:42 AM
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
Edit .accdb from multiple workstations
You do need a SQL server but rather you need a server where other persons have access. Then just place the Access database on that server. You can also set the options of Read/Write/Update authority for individual people who will be accessing this database. Hope I followed your question, if not please provide more details. [...]
View Answer
| December 8, 2009 4:01 AM
Access 2007, Access Database, Microsoft Access, Windows XP, Windows XP SP2
You do need a SQL server but rather you need a server where other persons have access. Then just place the Access database on that server. You can also set the options of Read/Write/Update authority for individual people who will be accessing this database. Hope I followed your question, if not please provide more details. [...]
View Answer
| December 8, 2009 4:01 AM
Access 2007, Access Database, Microsoft Access, Windows XP, Windows XP SP2
Want to be a Sun Solaris Administrator.
Try looking through tags like <a href=”http://itknowledgeexchange.techtarget.com/itanswers/tag/it-careers/”>IT Careers</a> to see other people’s experiences and answers, and feel free to stop by and leave Ed Tittel a comment on his <a href=”http://itknowledgeexchange.techtarget.com/it-jobs/”>IT jobs blog</a>. For Solaris specific careers, I can also recommend SearchDataCenter’s <a href=”http://searchdatacenter.techtarget.com/topics/0,295493,sid80_tax300191,00.html”>job and training guides</a>.
View Answer
| December 7, 2009 8:36 PM
IT careers, Solaris certifications, Sun Solaris
Try looking through tags like <a href=”http://itknowledgeexchange.techtarget.com/itanswers/tag/it-careers/”>IT Careers</a> to see other people’s experiences and answers, and feel free to stop by and leave Ed Tittel a comment on his <a href=”http://itknowledgeexchange.techtarget.com/it-jobs/”>IT jobs blog</a>. For Solaris specific careers, I can also recommend SearchDataCenter’s <a href=”http://searchdatacenter.techtarget.com/topics/0,295493,sid80_tax300191,00.html”>job and training guides</a>.
View Answer
| December 7, 2009 8:36 PM
IT careers, Solaris certifications, Sun Solaris
Performance issue
I normally work with SQL, but, the same tactics should apply to query as well. In SQL if you do a STRDBG before opening SQL, you can view the job log to see any temporary access paths that the system built, as well as what logicals it considered, which it used, and why it ruled [...]
View Answer
| December 7, 2009 3:09 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
I normally work with SQL, but, the same tactics should apply to query as well. In SQL if you do a STRDBG before opening SQL, you can view the job log to see any temporary access paths that the system built, as well as what logicals it considered, which it used, and why it ruled [...]
View Answer
| December 7, 2009 3:09 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
souce file listing
DSPFD FILE(QCLSRC) TYPE(*MBRLIST) Or, more elegantly, use this API: QUSLMBR. ===================================================== The simple answer above is correct. But why would you want to store the list in a database file? The connection to a “subfile” doesn’t provide any useful information since you can build a subfile from a *MBRLIST member list ‘on the fly’ or [...]
View Answer
| December 7, 2009 1:32 AM
Application development, AS/400, CLP, DB2 Universal Database, RPG, RPGLE
DSPFD FILE(QCLSRC) TYPE(*MBRLIST) Or, more elegantly, use this API: QUSLMBR. ===================================================== The simple answer above is correct. But why would you want to store the list in a database file? The connection to a “subfile” doesn’t provide any useful information since you can build a subfile from a *MBRLIST member list ‘on the fly’ or [...]
View Answer
| December 7, 2009 1:32 AM
Application development, AS/400, CLP, DB2 Universal Database, RPG, RPGLE
Performance Problem
Sorry, I don’t think we can understand what you’re asking until you give us more information. Performance in what — your mail server? What is the architecture in your system. By ’400′ do you mean an AS400? What part does your mail server play in this issue and what kind of mail server? Is the [...]
View Answer
| December 6, 2009 11:40 AM
AS/400, Data analysis, Database, DataCenter, DB2, Exchange, Oracle, SQL, Storage, Tech support
Sorry, I don’t think we can understand what you’re asking until you give us more information. Performance in what — your mail server? What is the architecture in your system. By ’400′ do you mean an AS400? What part does your mail server play in this issue and what kind of mail server? Is the [...]
View Answer
| December 6, 2009 11:40 AM
AS/400, Data analysis, Database, DataCenter, DB2, Exchange, Oracle, SQL, Storage, Tech support
Prompting for and passing partial search criteria to queries
Jimmer: you need to build a from/to range parms to pass to the STRQMQRY — you’ll need a CL pgm to do this. The FROM field value will be what the user keyed in and the TO field value will be the what the user keyed in with “9999″s being concatenated to the end of [...]
View Answer
| December 6, 2009 11:23 AM
AS/400, DB2 Universal Database
Jimmer: you need to build a from/to range parms to pass to the STRQMQRY — you’ll need a CL pgm to do this. The FROM field value will be what the user keyed in and the TO field value will be the what the user keyed in with “9999″s being concatenated to the end of [...]
View Answer
| December 6, 2009 11:23 AM
AS/400, DB2 Universal Database
