Mainframe to SAP
Hi, I’m a cobol programmer working on Mainframes with a work exp. of 2 yrs. I’ve worked in technologies like JCL, COBOL, VSAM, DB2, IMS DB/DC, IDMS, FOCUS etc. I have an opportunity to get into SAP technical(ABAP/4) as a programmer in my organisation. Looking at the future prospects of the Industry, do you think [...]
Answer Question
| October 31, 2011 6:40 AM
390, ABAP, Application development, AS/400, AS/400 careers, Backup & recovery, Basis, Billing and customer care, Billing Support Systems, Career development, Certifications, CLP, CO, Database, DB2, DB2 Universal Database, Development, ED, Email, Enterprise Desktop, FI, Financials, IBM Marketing Sound Off, Industry solutions, IS-B, IS-H, IS-Ill, IS-P, IS-Retail, IS-T, Linux, Mainframe, MySAP, MySQL, NetWeaver, Oracle, PC/Windows Connectivity, RIVA, RPG, RPGLE, SAP, SAP APO, SAP careers, SEM, TR, Training, Upgrades / implementations, Windows, zSeries
Hi, I’m a cobol programmer working on Mainframes with a work exp. of 2 yrs. I’ve worked in technologies like JCL, COBOL, VSAM, DB2, IMS DB/DC, IDMS, FOCUS etc. I have an opportunity to get into SAP technical(ABAP/4) as a programmer in my organisation. Looking at the future prospects of the Industry, do you think [...]
Answer Question
| October 31, 2011 6:40 AM
390, ABAP, Application development, AS/400, AS/400 careers, Backup & recovery, Basis, Billing and customer care, Billing Support Systems, Career development, Certifications, CLP, CO, Database, DB2, DB2 Universal Database, Development, ED, Email, Enterprise Desktop, FI, Financials, IBM Marketing Sound Off, Industry solutions, IS-B, IS-H, IS-Ill, IS-P, IS-Retail, IS-T, Linux, Mainframe, MySAP, MySQL, NetWeaver, Oracle, PC/Windows Connectivity, RIVA, RPG, RPGLE, SAP, SAP APO, SAP careers, SEM, TR, Training, Upgrades / implementations, Windows, zSeries
Doubts regarding speed in data access
y name is Yahya. I am working as a Project Leader in an IT Industry in India I am working on a new project with J2EE technology. I am using Weblogic Application Server and Iplanet Web server for this project. It is for a bank. I will have to write a program in the server [...]
Answer Question
| March 10, 2006 1:31 AM
Database, DB2, Java/J2EE, Oracle, SQL, Windows
y name is Yahya. I am working as a Project Leader in an IT Industry in India I am working on a new project with J2EE technology. I am using Weblogic Application Server and Iplanet Web server for this project. It is for a bank. I will have to write a program in the server [...]
Answer Question
| March 10, 2006 1:31 AM
Database, DB2, Java/J2EE, Oracle, SQL, Windows
Oracle Client 7.3.4 installation on Windows server 2003
hi, I need to install oracle client 7.3.4 on windows 2003 server.When I tried ,seemed like there is product available latest for only windows NT. Is there any work around for this ? ———— If there is no way we can install ora client 7.3.4 on windows 2003. How do I handle the OCI calls [...]
Answer Question
| March 1, 2006 1:26 AM
Oracle, Windows
hi, I need to install oracle client 7.3.4 on windows 2003 server.When I tried ,seemed like there is product available latest for only windows NT. Is there any work around for this ? ———— If there is no way we can install ora client 7.3.4 on windows 2003. How do I handle the OCI calls [...]
Answer Question
| March 1, 2006 1:26 AM
Oracle, Windows
Zebra printer will not print CORRECTLY through Oracle application(s)
Glad to see that some of you all have experience with Zebra printers!!! My problem is that I cannot get my custom Oracle application to print correctly to a Zebra TLP 2742 printer. The problem started when an (older) hand held “pistol” scanner failed. Connected to a laboratory balance via Omnilink box and two “Y” [...]
Answer Question
| March 1, 2006 9:19 AM
Aspen Technology, Baan, Billing and customer care, Billing Support Systems, Database, DataCenter, DB2, Desktop management applications, Desktops, Development, Distribution/logistics applications, Hardware, i2 Technologies, IBM, Interoperability, Management, Manufacturing applications, Manugistics, Microsoft .NET, Microsoft BizTalk Server, Microsoft Internet Information Server, Microsoft Windows, NCR, Online transaction processing, Oracle, Oracle Application Server, Oracle Manufacturing, OS, PeopleSoft, Printers, QAD, SalesLogix, SAP, SAS Institute, SDRC/EDS, Security, Servers, Siebel, SQL Server, Supply chain management applications, Tech support, Windows
Glad to see that some of you all have experience with Zebra printers!!! My problem is that I cannot get my custom Oracle application to print correctly to a Zebra TLP 2742 printer. The problem started when an (older) hand held “pistol” scanner failed. Connected to a laboratory balance via Omnilink box and two “Y” [...]
Answer Question
| March 1, 2006 9:19 AM
Aspen Technology, Baan, Billing and customer care, Billing Support Systems, Database, DataCenter, DB2, Desktop management applications, Desktops, Development, Distribution/logistics applications, Hardware, i2 Technologies, IBM, Interoperability, Management, Manufacturing applications, Manugistics, Microsoft .NET, Microsoft BizTalk Server, Microsoft Internet Information Server, Microsoft Windows, NCR, Online transaction processing, Oracle, Oracle Application Server, Oracle Manufacturing, OS, PeopleSoft, Printers, QAD, SalesLogix, SAP, SAS Institute, SDRC/EDS, Security, Servers, Siebel, SQL Server, Supply chain management applications, Tech support, Windows
Installing Oracle 8i and 10g on Same machine
I want to Install Oracle 8i and Oracle 10g on Same machine. Which version of Oracle to install first? Is there any precedence of installing different versions of Oracle on same machine? If the precedence change, will it cause any problem? Kindly Suggest. Thanks in advance, Karthik
Answer Question
| August 29, 2010 1:50 AM
Oracle, Windows
I want to Install Oracle 8i and Oracle 10g on Same machine. Which version of Oracle to install first? Is there any precedence of installing different versions of Oracle on same machine? If the precedence change, will it cause any problem? Kindly Suggest. Thanks in advance, Karthik
Answer Question
| August 29, 2010 1:50 AM
Oracle, Windows
Oracle Sql Tuning
Hi everybody. I need some help with Sql Tuning. I have a query that returns information from many tables (let’s say 5 for the example). 2 of that tables are big tables (20 million rows each one). I usually write ‘where’ clauses putting first the join conditions and after them, the table specific conditions, but [...]
Answer Question
| February 6, 2006 2:03 PM
Database, DB2, Oracle, Windows
Hi everybody. I need some help with Sql Tuning. I have a query that returns information from many tables (let’s say 5 for the example). 2 of that tables are big tables (20 million rows each one). I usually write ‘where’ clauses putting first the join conditions and after them, the table specific conditions, but [...]
Answer Question
| February 6, 2006 2:03 PM
Database, DB2, Oracle, Windows
16 bit application connection to ORACLE 9
Our company has previously developed 2 old software 16-bit applications that connect to ORACLE v7. Q: Is it possible to get these apps to connect to ORACLE 9? I’m told that this may be generally regarded as a 16 Bit to 32 bit issue, and that we may need some an interface/translation from 16 Bit [...]
Answer Question
| January 25, 2006 10:15 AM
Development, Oracle, Windows
Our company has previously developed 2 old software 16-bit applications that connect to ORACLE v7. Q: Is it possible to get these apps to connect to ORACLE 9? I’m told that this may be generally regarded as a 16 Bit to 32 bit issue, and that we may need some an interface/translation from 16 Bit [...]
Answer Question
| January 25, 2006 10:15 AM
Development, Oracle, Windows
DataBase Administration
Hello everybody. We have an Oracle 8i DataBase of aprox. 30 GigaBytes. There are 3 big tables using about 50 % of that space, and our DBA is planning to move these tables to another database, to make the administration and backup procedure easier… but I’m not sure about that. Is that a good idea [...]
Answer Question
| January 23, 2006 12:39 PM
Oracle, SQL, Windows
Hello everybody. We have an Oracle 8i DataBase of aprox. 30 GigaBytes. There are 3 big tables using about 50 % of that space, and our DBA is planning to move these tables to another database, to make the administration and backup procedure easier… but I’m not sure about that. Is that a good idea [...]
Answer Question
| January 23, 2006 12:39 PM
Oracle, SQL, Windows
Oracle Longops Queries.
Hi, Does anyone know the criteria based on which oracle defines a query/transaction to become a candidate for longoops.
Answer Question
| January 18, 2006 2:34 PM
Database, DB2, Oracle, Windows
Hi, Does anyone know the criteria based on which oracle defines a query/transaction to become a candidate for longoops.
Answer Question
| January 18, 2006 2:34 PM
Database, DB2, Oracle, Windows
ORA-01000 error even if all statements and resultsets are closed in finally
I am getting ORA-01000 error even if I have closed all statements and resultsets in finally for all query (not using prepared statements). Also OPEN_CURSOR is set to 500. We are using Oracle 8.1.7 and in JDBC driver ‘Enable Resultset’ is ON and ‘Enable Closing cursors’ is OFF Please suggest how to solve is issue. [...]
Answer Question
| December 29, 2005 11:22 PM
Database, DB2, Java, Oracle, Software, SQL, Tech support, Windows
I am getting ORA-01000 error even if I have closed all statements and resultsets in finally for all query (not using prepared statements). Also OPEN_CURSOR is set to 500. We are using Oracle 8.1.7 and in JDBC driver ‘Enable Resultset’ is ON and ‘Enable Closing cursors’ is OFF Please suggest how to solve is issue. [...]
Answer Question
| December 29, 2005 11:22 PM
Database, DB2, Java, Oracle, Software, SQL, Tech support, Windows
Print Numbers in words
By using a single SQL Query Is it possible to print numbers in words. Example : To print “5,550 Dollars” in words Expected Query result : “Five Thousand Five Hundred and Fifty Dollars Only” Is it Posssible by a single query
Answer Question
| December 29, 2005 10:11 PM
Career development, Certifications, CRM, Database, DataManagement, DB2, Desktops, Development, Functional, Lifecycle development, Management, Microsoft Windows, Oracle, OS, Performance/Load, Security, Servers, Software, Software Quality Assurance, Software testing tools, SQL, SQL Server, Tech support, Windows
By using a single SQL Query Is it possible to print numbers in words. Example : To print “5,550 Dollars” in words Expected Query result : “Five Thousand Five Hundred and Fifty Dollars Only” Is it Posssible by a single query
Answer Question
| December 29, 2005 10:11 PM
Career development, Certifications, CRM, Database, DataManagement, DB2, Desktops, Development, Functional, Lifecycle development, Management, Microsoft Windows, Oracle, OS, Performance/Load, Security, Servers, Software, Software Quality Assurance, Software testing tools, SQL, SQL Server, Tech support, Windows
Reading, Deleting, Writing Rows to Oracle Data Base
We have a 3rd party warehouse package that utilizes Oracle. In order for us communicate with our I5 to this package, we need to read/delete rows from an Oracle database file on a PC running Windows 2003, and also write records to another Oracle database file running on the same PC. Any pointers in getting [...]
Answer Question
| November 28, 2005 10:42 AM
Windows
We have a 3rd party warehouse package that utilizes Oracle. In order for us communicate with our I5 to this package, we need to read/delete rows from an Oracle database file on a PC running Windows 2003, and also write records to another Oracle database file running on the same PC. Any pointers in getting [...]
Answer Question
| November 28, 2005 10:42 AM
Windows
Regarding Oracle connectivity issues
I have Oracle 7i and 9i installed on my PC under C:/ORANT and C:/ORA9 respectively. When i try to connect to Oracle from a front end application (Visual Basic v6)that takes as input the Database domain name and Database schema name as input and tries to establish a connection to Oracle using the OLE DB [...]
Answer Question
| November 29, 2005 7:51 PM
Database, DB2, Oracle, SQL, Windows
I have Oracle 7i and 9i installed on my PC under C:/ORANT and C:/ORA9 respectively. When i try to connect to Oracle from a front end application (Visual Basic v6)that takes as input the Database domain name and Database schema name as input and tries to establish a connection to Oracle using the OLE DB [...]
Answer Question
| November 29, 2005 7:51 PM
Database, DB2, Oracle, SQL, Windows
Date conversion (to_char) behavior
Hi everybody. We are experiencing a strange behavior with a “to_char” conversion: We are using Oracle 8i and Developer 6i. An application need to know the day of the week (number of day) of a given date, and we are doing that with “to_char(given_date,’D')”. This returns a 1 for sunday, and 7 for saturday, but [...]
Answer Question
| December 15, 2010 2:01 PM
Oracle, SQL, Windows
Hi everybody. We are experiencing a strange behavior with a “to_char” conversion: We are using Oracle 8i and Developer 6i. An application need to know the day of the week (number of day) of a given date, and we are doing that with “to_char(given_date,’D')”. This returns a 1 for sunday, and 7 for saturday, but [...]
Answer Question
| December 15, 2010 2:01 PM
Oracle, SQL, Windows
SQL Server 2005 adoption
My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. I am interested in your thoughts on SQL Server 2005 adoption. Based on your knowledge of SQL Server 2005, what hurdles do you foresee in using the new DBMS? Do you think Management Studio will be more difficult to use than [...]
Answer Question
| November 23, 2005 3:36 PM
Access, Database, DataCenter, DB2, Desktops, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server, Windows
My name is Nick Bellistri and I am the assistant site editor for SearchSQLServer.com. I am interested in your thoughts on SQL Server 2005 adoption. Based on your knowledge of SQL Server 2005, what hurdles do you foresee in using the new DBMS? Do you think Management Studio will be more difficult to use than [...]
Answer Question
| November 23, 2005 3:36 PM
Access, Database, DataCenter, DB2, Desktops, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server, Windows
Seeking white papers on .NET connector and JCo
Where can I find white papers with information on .NET connectors and Java connectors for SAP? I have searched many Websites but I can’t find the right information. Thanks for sharing your ideas.
Answer Question
| November 24, 2005 10:52 AM
ABAP, Basis, CO, Development, ED, FI, Financials, Industry solutions, IS-B, IS-H, IS-Ill, IS-P, IS-Retail, IS-T, MySAP, NetWeaver, RIVA, SAP, SAP APO, SAP careers, SEM, TR, Upgrades / implementations, Windows
Where can I find white papers with information on .NET connectors and Java connectors for SAP? I have searched many Websites but I can’t find the right information. Thanks for sharing your ideas.
Answer Question
| November 24, 2005 10:52 AM
ABAP, Basis, CO, Development, ED, FI, Financials, Industry solutions, IS-B, IS-H, IS-Ill, IS-P, IS-Retail, IS-T, MySAP, NetWeaver, RIVA, SAP, SAP APO, SAP careers, SEM, TR, Upgrades / implementations, Windows
Understanding SAP security risks
What is a good resource to help me understand the risks of assigning the &NC& authorization group to a table? I am worried about these tables being accessed by “unauthorized” users? Please post your thoughts. Thank you!
Answer Question
| November 24, 2005 10:50 AM
ABAP, Basis, CO, Development, ED, FI, Financials, Industry solutions, IS-B, IS-H, IS-Ill, IS-P, IS-Retail, IS-T, MySAP, NetWeaver, RIVA, SAP, SAP APO, SAP careers, SEM, TR, Upgrades / implementations, Windows
What is a good resource to help me understand the risks of assigning the &NC& authorization group to a table? I am worried about these tables being accessed by “unauthorized” users? Please post your thoughts. Thank you!
Answer Question
| November 24, 2005 10:50 AM
ABAP, Basis, CO, Development, ED, FI, Financials, Industry solutions, IS-B, IS-H, IS-Ill, IS-P, IS-Retail, IS-T, MySAP, NetWeaver, RIVA, SAP, SAP APO, SAP careers, SEM, TR, Upgrades / implementations, Windows
SQL Query Perfomance Issue.
Hi All, This is Wasim Ahmed. I basically wanted a kick start to tune my SQL Queries for performance. I have a huge query which is taking an average of 30seconds for records in thousands. I want to improve the efficiency of the Query. Can any one help me in this. I am pasting my [...]
Answer Question
| November 18, 2005 8:31 AM
Automated, ERP, Oracle, Performance/Load, Software testing, Software testing tools, Windows
Hi All, This is Wasim Ahmed. I basically wanted a kick start to tune my SQL Queries for performance. I have a huge query which is taking an average of 30seconds for records in thousands. I want to improve the efficiency of the Query. Can any one help me in this. I am pasting my [...]
Answer Question
| November 18, 2005 8:31 AM
Automated, ERP, Oracle, Performance/Load, Software testing, Software testing tools, Windows
Question about a frequently changing column as primary key
Thank you for taking take to read my question. We have a live J2EE application using Oracle 8i. Now we are doing v2 to add some modules. We found it has a frequently changing column (status_code) as part of the composite primary keys in some major tables. We know it can cause future proformance issues, [...]
Answer Question
| December 12, 2005 9:27 AM
Data analysis, Database, DB2, Development, E-business, Ecommerce applications, J2EE, Java, Lifecycle development, Oracle, Programming Languages, SQL, Windows
Thank you for taking take to read my question. We have a live J2EE application using Oracle 8i. Now we are doing v2 to add some modules. We found it has a frequently changing column (status_code) as part of the composite primary keys in some major tables. We know it can cause future proformance issues, [...]
Answer Question
| December 12, 2005 9:27 AM
Data analysis, Database, DB2, Development, E-business, Ecommerce applications, J2EE, Java, Lifecycle development, Oracle, Programming Languages, SQL, Windows
Performance degraded after changing optimizer mode
Hi all, I facing a strange problem. Please help me. Server = Windows 2003 Oracle version – oracle 9.2.0.1.0 (standard edition) I have done the some changes at my client side. I done changes as follows.. 1) Tunning has done on dated 22/10/05 i) The database archive log mode has changed to Archive log mode. [...]
Answer Question
| November 3, 2005 2:49 AM
Oracle, Windows
Hi all, I facing a strange problem. Please help me. Server = Windows 2003 Oracle version – oracle 9.2.0.1.0 (standard edition) I have done the some changes at my client side. I done changes as follows.. 1) Tunning has done on dated 22/10/05 i) The database archive log mode has changed to Archive log mode. [...]
Answer Question
| November 3, 2005 2:49 AM
Oracle, Windows
