Best way to get first job in sap
I have been studying Sap modules FI-CO I have had hours of practice on dummy configurations, I have got to a point where l feel a lot confident that I can do this job. I just dont know where to start, all the job that I have seen they all asking for someone with lot [...]
Answer Question
| October 31, 2008 4:49 PM
IT careers, SAP careers, SAP jobs
I have been studying Sap modules FI-CO I have had hours of practice on dummy configurations, I have got to a point where l feel a lot confident that I can do this job. I just dont know where to start, all the job that I have seen they all asking for someone with lot [...]
Answer Question
| October 31, 2008 4:49 PM
IT careers, SAP careers, SAP jobs
Issue SQL Query with Localized String through PowerShell
Hello, I am attempting to execute a an SQL query through PowerShell against an MS Access database. My query works 99% of the time, but occasionally a localized string will cause an error beacuse it contains a single quote (‘) somewhere within the localized string. You can look at the following example to get a [...]
Answer Question
| November 5, 2008 11:51 AM
Database programming, Localized String, Microsoft Access, PowerShell, Scripting, SQL, SQL Query, Windows PowerShell, Windows scripting
Hello, I am attempting to execute a an SQL query through PowerShell against an MS Access database. My query works 99% of the time, but occasionally a localized string will cause an error beacuse it contains a single quote (‘) somewhere within the localized string. You can look at the following example to get a [...]
Answer Question
| November 5, 2008 11:51 AM
Database programming, Localized String, Microsoft Access, PowerShell, Scripting, SQL, SQL Query, Windows PowerShell, Windows scripting
Problem replication propagation
Hello, I explain my problem. I have 3 databases (CTS1, CTS2 and CTST) in multimaster replication. CTS1 and CTST first run without problem. CTS1 is master site definition. I have added master site CTS2 without quiescing replication. Now I have 3 master sites running. I have the following problem : A commit in CTS1 create [...]
Answer Question
| October 31, 2008 11:28 AM
Database propagation, Database replication, Deferred transaction, Multimaster replication, Replication
Hello, I explain my problem. I have 3 databases (CTS1, CTS2 and CTST) in multimaster replication. CTS1 and CTST first run without problem. CTS1 is master site definition. I have added master site CTS2 without quiescing replication. Now I have 3 master sites running. I have the following problem : A commit in CTS1 create [...]
Answer Question
| October 31, 2008 11:28 AM
Database propagation, Database replication, Deferred transaction, Multimaster replication, Replication
IT department administration integration
My company was just acquired by a larger one, and we are now preparing to combine our IT departments. What is the best way to do this and guarantee that everyone maintains access to the data/resources that they need? Should we create clusters based on who needs what? Can you recommend any visualization tools (or [...]
Answer Question
| November 3, 2008 8:24 PM
Acquisitions, Clustering, Data Center, Data center planning, IT administration, Scalability
My company was just acquired by a larger one, and we are now preparing to combine our IT departments. What is the best way to do this and guarantee that everyone maintains access to the data/resources that they need? Should we create clusters based on who needs what? Can you recommend any visualization tools (or [...]
Answer Question
| November 3, 2008 8:24 PM
Acquisitions, Clustering, Data Center, Data center planning, IT administration, Scalability
os on data base servers
do you need an os on a data base server if you have sql loaded
Answer Question
| October 31, 2008 7:09 PM
Database servers, OS, SQL Server database
do you need an os on a data base server if you have sql loaded
Answer Question
| October 31, 2008 7:09 PM
Database servers, OS, SQL Server database
Access 2007 Replace operation
In Access 2007, can a replace operation be performed using wildcard to replace a variable string with a known string.
Answer Question
| November 4, 2008 5:33 PM
Access 2007, Microsoft Access
In Access 2007, can a replace operation be performed using wildcard to replace a variable string with a known string.
Answer Question
| November 4, 2008 5:33 PM
Access 2007, Microsoft Access
Conditional Format – Access 97
Unfortunately, the company I work for uses Access 97, and the Conditional Format Wizard is not available in this version. Can you help me with building a macro/expression to create a conditional format for a form? I need to format the form’s background color based simply on whether the record is “Active” vs. “Inactive.” Thanks, [...]
Answer Question
| October 30, 2008 6:07 PM
Access 97, Conditional formatting, Microsoft Access
Unfortunately, the company I work for uses Access 97, and the Conditional Format Wizard is not available in this version. Can you help me with building a macro/expression to create a conditional format for a form? I need to format the form’s background color based simply on whether the record is “Active” vs. “Inactive.” Thanks, [...]
Answer Question
| October 30, 2008 6:07 PM
Access 97, Conditional formatting, Microsoft Access
Creating pop-up reminders
I am maintaining a data baase of living documents whic require a review every 2 years. I need a reminder before the 2 year anniversary arrives. The table currently has a “Effective Date” column. Please keep in mind that I am not well versed in macros. Thanx for any help,
Answer Question
| October 28, 2008 10:39 PM
Access 2007, Access 2007 pop-up reminder, Database programming, Microsoft Access
I am maintaining a data baase of living documents whic require a review every 2 years. I need a reminder before the 2 year anniversary arrives. The table currently has a “Effective Date” column. Please keep in mind that I am not well versed in macros. Thanx for any help,
Answer Question
| October 28, 2008 10:39 PM
Access 2007, Access 2007 pop-up reminder, Database programming, Microsoft Access
Problems from reindexing tables every day on a SQL Server
We have a daily job running to reindex all the tables for all the databases on our SQL Server. If I reindex selective reporting tables everyday, take a transaction log backup right after reindexing and check if the transaction log is greater than 1GB, I think I should invoke a stored procedure to shrink the [...]
Answer Question
| October 28, 2008 5:58 PM
Indexing (information management), SQL Server, tables
We have a daily job running to reindex all the tables for all the databases on our SQL Server. If I reindex selective reporting tables everyday, take a transaction log backup right after reindexing and check if the transaction log is greater than 1GB, I think I should invoke a stored procedure to shrink the [...]
Answer Question
| October 28, 2008 5:58 PM
Indexing (information management), SQL Server, tables
Oracle, MySQL connectivity by HSODBC
Hello, We have tried to connect with MySQL from Oracle 10g Rel.2 through HSODBC and getting the following error: ERROR at line 1: ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from MYSQLDB Both MySQL and Oracle are running on windows [...]
Answer Question
| October 27, 2008 6:04 AM
Database connectivity, HSODBC, MySQL, ORA-02063, ORA-28545, Oracle, Oracle 10g, Oracle error messages, Solaris
Hello, We have tried to connect with MySQL from Oracle 10g Rel.2 through HSODBC and getting the following error: ERROR at line 1: ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from MYSQLDB Both MySQL and Oracle are running on windows [...]
Answer Question
| October 27, 2008 6:04 AM
Database connectivity, HSODBC, MySQL, ORA-02063, ORA-28545, Oracle, Oracle 10g, Oracle error messages, Solaris
Run scheduled job on SQL Server
we do integrate SQL SERVER woth Oracle database, and its usually work withour problems. the last two days the intgration is not working and the following error displayed in the job history. Cannot create COM Server to load and execute DTS Package. Error -2147221008 (800401F0): CoInitialize has not been called. Process Exit Code -2147221008. The [...]
Answer Question
| October 27, 2008 6:20 AM
COM server, Database interoperability, DTS packages, Error 2147221008, Oracle interoperability, Runtime Errors, SQL Server 2000, SQL Server errors, SQL Server interoperability
we do integrate SQL SERVER woth Oracle database, and its usually work withour problems. the last two days the intgration is not working and the following error displayed in the job history. Cannot create COM Server to load and execute DTS Package. Error -2147221008 (800401F0): CoInitialize has not been called. Process Exit Code -2147221008. The [...]
Answer Question
| October 27, 2008 6:20 AM
COM server, Database interoperability, DTS packages, Error 2147221008, Oracle interoperability, Runtime Errors, SQL Server 2000, SQL Server errors, SQL Server interoperability
Linked Server Query Returns Incomplete Results
I have set up a linked server using Microsoft OLE DB Provider for ODBC Driver to an Oracle DB ODBC DSN. The Oracle table I’m querying has 865 rows but when I try to fetch all the rows I only get back 766 rows. Why am I not getting the complete results? Here is the [...]
Answer Question
| January 6, 2011 12:42 PM
Linked servers, ODBC, OLE DB, Oracle Database
I have set up a linked server using Microsoft OLE DB Provider for ODBC Driver to an Oracle DB ODBC DSN. The Oracle table I’m querying has 865 rows but when I try to fetch all the rows I only get back 766 rows. Why am I not getting the complete results? Here is the [...]
Answer Question
| January 6, 2011 12:42 PM
Linked servers, ODBC, OLE DB, Oracle Database
SAP career option
hi, i am a java developer (1 year experience). I wanted to join in SAP training. which module do you think is better? should i learn abap for future career in SAP?
Answer Question
| October 24, 2008 2:54 AM
ABAP, ABAP certifications, IT careers, SAP careers, SAP certifications, SAP training
hi, i am a java developer (1 year experience). I wanted to join in SAP training. which module do you think is better? should i learn abap for future career in SAP?
Answer Question
| October 24, 2008 2:54 AM
ABAP, ABAP certifications, IT careers, SAP careers, SAP certifications, SAP training
Database refresh
i want to refresh the database for every week from a cluster environment. could you please suggest a feasible option not back and recovery. I tried the following ways: 1. through SSIS database transfer task-but it failed 2. through copy database wizard-not working please tell us how to work through these options.
Answer Question
| October 23, 2008 6:04 PM
DBA, SSIS, SSIS database
i want to refresh the database for every week from a cluster environment. could you please suggest a feasible option not back and recovery. I tried the following ways: 1. through SSIS database transfer task-but it failed 2. through copy database wizard-not working please tell us how to work through these options.
Answer Question
| October 23, 2008 6:04 PM
DBA, SSIS, SSIS database
SAP Certification
I have a smally query. I am a BPCS consultant with 3 years experience. As of now in india, the developement projects for BPCS is reduced and we get Support projects only. Also nowdays people prefer to implement SAP than BPCS. So for people like me whats your advise. Isnt certification a break in for [...]
Answer Question
| November 4, 2008 9:36 AM
ABAP, BPCS, Career development, Certifications, IT careers, SAP careers, SAP certifications
I have a smally query. I am a BPCS consultant with 3 years experience. As of now in india, the developement projects for BPCS is reduced and we get Support projects only. Also nowdays people prefer to implement SAP than BPCS. So for people like me whats your advise. Isnt certification a break in for [...]
Answer Question
| November 4, 2008 9:36 AM
ABAP, BPCS, Career development, Certifications, IT careers, SAP careers, SAP certifications
Get all table names by SQL
Hi, How can I get all the table names of a bib by a SQL-query? Thank you.
Answer Question
| April 17, 2013 7:34 AM
Bib tables, SQL, SQL development, SQL Query
Hi, How can I get all the table names of a bib by a SQL-query? Thank you.
Answer Question
| April 17, 2013 7:34 AM
Bib tables, SQL, SQL development, SQL Query
Problem with slow loading database after delete record/data
currently facing problem in loading my database after i delete some record from the database..i have compact for the database but still have the slow accessing problem..kindly assist..many thanks
Answer Question
| October 21, 2008 7:31 AM
Database administration, Database management, Database performance
currently facing problem in loading my database after i delete some record from the database..i have compact for the database but still have the slow accessing problem..kindly assist..many thanks
Answer Question
| October 21, 2008 7:31 AM
Database administration, Database management, Database performance
Grouping the records in RPG
How to I group the records in the database based on one particular field?? When i try using a group by clause in the embedded SQL, it give me a ‘SQL precompile failed’ error. How do I handle this?? And i have to display the employee records grouped by their locations… how can this be [...]
Answer Question
| October 22, 2008 4:39 AM
AS/400 database, AS/400 development, AS/400 error messages, Embedded SQL, Report Program Generator, RPG, RPG/400, SQL precompile failed, SQL/400
How to I group the records in the database based on one particular field?? When i try using a group by clause in the embedded SQL, it give me a ‘SQL precompile failed’ error. How do I handle this?? And i have to display the employee records grouped by their locations… how can this be [...]
Answer Question
| October 22, 2008 4:39 AM
AS/400 database, AS/400 development, AS/400 error messages, Embedded SQL, Report Program Generator, RPG, RPG/400, SQL precompile failed, SQL/400
Not allowed to edit Microsoft Access forms
A previous employee built a very usable db, and has gone on to greener pastures. It isn’t password protected. When we try to edit the db with new fields or change wording in fields, it asks if we want to exit the app. if Yes is clicked, it exits the app and Access. We use [...]
Answer Question
| November 3, 2008 12:08 AM
Access 2003, Access forms, Microsoft Access, Microsoft Access forms, Microsoft Office 2003, Office 2003, VBA, Visual Basic for Applications
A previous employee built a very usable db, and has gone on to greener pastures. It isn’t password protected. When we try to edit the db with new fields or change wording in fields, it asks if we want to exit the app. if Yes is clicked, it exits the app and Access. We use [...]
Answer Question
| November 3, 2008 12:08 AM
Access 2003, Access forms, Microsoft Access, Microsoft Access forms, Microsoft Office 2003, Office 2003, VBA, Visual Basic for Applications
Special character in a PF
Hi, Is there any way to know if a file has any carriage return on any of the records? I have a file which is populated bby front end users and sometimes when they copy paste an item it also picks up the carriage return. any way to find out if file is having any [...]
Answer Question
| September 3, 2010 10:49 PM
Database, iSeries, iSeries database, PF/LF, Physical File
Hi, Is there any way to know if a file has any carriage return on any of the records? I have a file which is populated bby front end users and sometimes when they copy paste an item it also picks up the carriage return. any way to find out if file is having any [...]
Answer Question
| September 3, 2010 10:49 PM
Database, iSeries, iSeries database, PF/LF, Physical File
