Partitioning a large financial table
i hv a large table (GL details that is abt 30-50mb) that contains financial data. i want to partition it by these fields 1) company code 2) Quarter (based on the financial periods) 3) Year Eg, data Select GLCO, GLYEAR, (TO_CHAR(GLYEAR) ||’/'||TO_CHAR(GLMNTH)) As Yrmth, GLMNTH, GLAMT FROM GLPGL; GLCO GLYEAR Yrmth GKMNTH GLAMT 110 2004 [...]
Answer Question
| January 16, 2006 3:20 AM
Database, DB2, Oracle
i hv a large table (GL details that is abt 30-50mb) that contains financial data. i want to partition it by these fields 1) company code 2) Quarter (based on the financial periods) 3) Year Eg, data Select GLCO, GLYEAR, (TO_CHAR(GLYEAR) ||’/'||TO_CHAR(GLMNTH)) As Yrmth, GLMNTH, GLAMT FROM GLPGL; GLCO GLYEAR Yrmth GKMNTH GLAMT 110 2004 [...]
Answer Question
| January 16, 2006 3:20 AM
Database, DB2, Oracle
Oracle Developer 6i and 9i database connection problems
I cannot connect to a 9i database patched to 9.2.0.6 (I can if the server is patched to 9.2.0.5) from a 6i Developer client on XP. Tnsping80 is OK but not SQL. I get kicked out of SQL and the error report references ora805.dll. When I install the 9i client I can connect with it [...]
Answer Question
| January 14, 2006 9:08 AM
Database, DB2, Oracle
I cannot connect to a 9i database patched to 9.2.0.6 (I can if the server is patched to 9.2.0.5) from a 6i Developer client on XP. Tnsping80 is OK but not SQL. I get kicked out of SQL and the error report references ora805.dll. When I install the 9i client I can connect with it [...]
Answer Question
| January 14, 2006 9:08 AM
Database, DB2, Oracle
Deleting old userids
I used to display the last signon date on a specific user profile to know if it was still used, if it was older than 3 months, it was deleted. Now there are more & more user profiles defined to the system for other applications than the “green screen”, like FTP, ISeries Navigator, ODBC, etc…. [...]
Answer Question
| January 13, 2006 5:55 PM
Application security, Biometrics, Database, Digital certificates, Encryption, Exchange, Firewalls, Forensics, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, provisioning, Secure Coding, Security, Security tokens, Single sign-on, VPN, Wireless
I used to display the last signon date on a specific user profile to know if it was still used, if it was older than 3 months, it was deleted. Now there are more & more user profiles defined to the system for other applications than the “green screen”, like FTP, ISeries Navigator, ODBC, etc…. [...]
Answer Question
| January 13, 2006 5:55 PM
Application security, Biometrics, Database, Digital certificates, Encryption, Exchange, Firewalls, Forensics, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, provisioning, Secure Coding, Security, Security tokens, Single sign-on, VPN, Wireless
data encryption/decryption
We are in the process of building encryption/decryption applications. We are using the IBM QC3ENCDT AND QC3DECDT API’S. I’ve starting testing against our database using apprx 3000 records to encrypt and then decrypt. Out of that 3000 records, there are 17 instances of failure to decrypt to clear data and it is always the same [...]
Answer Question
| January 11, 2006 10:39 AM
Application development, Application security, Database, Encryption, Exchange, Instant Messaging, Secure Coding
We are in the process of building encryption/decryption applications. We are using the IBM QC3ENCDT AND QC3DECDT API’S. I’ve starting testing against our database using apprx 3000 records to encrypt and then decrypt. Out of that 3000 records, there are 17 instances of failure to decrypt to clear data and it is always the same [...]
Answer Question
| January 11, 2006 10:39 AM
Application development, Application security, Database, Encryption, Exchange, Instant Messaging, Secure Coding
read only user
I’ve got an Oracle 9.2.0.5 database and I need to create a read only user that can view any table, view, package, etc. I’ve created the user but I can’t figure out how to give it read only access to packages, procedures and functions. The only option seems to be granting execute any procedure. I [...]
Answer Question
| January 12, 2006 9:04 AM
Database, DB2, Oracle, SQL
I’ve got an Oracle 9.2.0.5 database and I need to create a read only user that can view any table, view, package, etc. I’ve created the user but I can’t figure out how to give it read only access to packages, procedures and functions. The only option seems to be granting execute any procedure. I [...]
Answer Question
| January 12, 2006 9:04 AM
Database, DB2, Oracle, SQL
problem related paper size (Crystal Report 9)
My project (in VB & Crystal Report 9) needs different shaped bills (10?X12?, 6?X12?, 15?X12?) to print through DMP. But I am facing problem to control paper size through code.
Answer Question
| January 11, 2006 5:15 AM
Data analysis, Database, DB2, Oracle
My project (in VB & Crystal Report 9) needs different shaped bills (10?X12?, 6?X12?, 15?X12?) to print through DMP. But I am facing problem to control paper size through code.
Answer Question
| January 11, 2006 5:15 AM
Data analysis, Database, DB2, Oracle
To retrieve data from a remote system
Hi, I have to retrieve data from a remote system (May be of any operating system) and shall put into AS/400. This process should be automated and there can’t be any manual intervention. We can not use FTP commands here. Is there any other way this can be achieved. Can?t go for MQ Series either [...]
Answer Question
| November 23, 2009 11:11 AM
390, Application development, AS/400, AS/400 careers, Backup & recovery, Billing and customer care, Billing Support Systems, CLP, DataCenter, DB2, DB2 Universal Database, Development, Email, IBM Marketing Sound Off, Mainframe, Mobile, Mobile security, Network protocols, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, VoIP, Web development, Wireless, zSeries
Hi, I have to retrieve data from a remote system (May be of any operating system) and shall put into AS/400. This process should be automated and there can’t be any manual intervention. We can not use FTP commands here. Is there any other way this can be achieved. Can?t go for MQ Series either [...]
Answer Question
| November 23, 2009 11:11 AM
390, Application development, AS/400, AS/400 careers, Backup & recovery, Billing and customer care, Billing Support Systems, CLP, DataCenter, DB2, DB2 Universal Database, Development, Email, IBM Marketing Sound Off, Mainframe, Mobile, Mobile security, Network protocols, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, VoIP, Web development, Wireless, zSeries
Symantec Resources
Our company has just partnered with Symantec and being new to their products, I’m finding myself a bit overwhelmed. Are there any websites that offer mailing lists or online forums that can help with some of the issues I’m running into? This seems like an interesting concept for user-to-user support, but it’s not the friendliest [...]
Answer Question
| January 13, 2006 10:14 PM
Access control, Application security, backdoors, Backup & recovery, Brightmail, Browsers, Compliance, configuration, CRM, Current threats, Database, DataCenter, Desktop management applications, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Incident response, Instant Messaging, Intrusion management, McAfee, Microsoft Windows, Network security, Patch management, patching, PEN testing, Platform Security, Policies, Risk management, Secure Coding, Security, Security Program Management, Servers, Software, Spam, Spyware, SSL/TLS, Symantec, Systems management software, Trojans, Veritas, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Our company has just partnered with Symantec and being new to their products, I’m finding myself a bit overwhelmed. Are there any websites that offer mailing lists or online forums that can help with some of the issues I’m running into? This seems like an interesting concept for user-to-user support, but it’s not the friendliest [...]
Answer Question
| January 13, 2006 10:14 PM
Access control, Application security, backdoors, Backup & recovery, Brightmail, Browsers, Compliance, configuration, CRM, Current threats, Database, DataCenter, Desktop management applications, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Incident response, Instant Messaging, Intrusion management, McAfee, Microsoft Windows, Network security, Patch management, patching, PEN testing, Platform Security, Policies, Risk management, Secure Coding, Security, Security Program Management, Servers, Software, Spam, Spyware, SSL/TLS, Symantec, Systems management software, Trojans, Veritas, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Email encryption
Dear Colleagues: What is the best way of detecting whether email messages are transmitted as cleartext? I want to determine whether our company email messages are encrypted or not when they are transmitted within and out of the corporate network. Thank you very much!
Answer Question
| January 9, 2006 8:26 AM
Application security, Database, Encryption, Exchange, Instant Messaging, Secure Coding, Security
Dear Colleagues: What is the best way of detecting whether email messages are transmitted as cleartext? I want to determine whether our company email messages are encrypted or not when they are transmitted within and out of the corporate network. Thank you very much!
Answer Question
| January 9, 2006 8:26 AM
Application security, Database, Encryption, Exchange, Instant Messaging, Secure Coding, Security
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
Educating database users
Database administrators must always be prepared to handle users’ database problems and concerns — even if those users are quick to blame for every small thing that goes wrong and rarely praise when big things go right. It may be a lack of education; users just don’t understand the work involved with managing and maintaining [...]
Answer Question
| January 11, 2006 12:00 AM
Data analysis, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server
Database administrators must always be prepared to handle users’ database problems and concerns — even if those users are quick to blame for every small thing that goes wrong and rarely praise when big things go right. It may be a lack of education; users just don’t understand the work involved with managing and maintaining [...]
Answer Question
| January 11, 2006 12:00 AM
Data analysis, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server
64 bit Oracle
Hi, I’d like your opinion on migrating to 64 bit platforms. Right now our Oracle 9 databases are on Windows 2003 32 bit HP servers. We re running into memory and performance limitations and are thinking about moving to 64 bit. IBM’s Power servers are tempting, even with the added expense of learning Linux. Bit [...]
Answer Question
| December 27, 2005 4:03 PM
Database, DB2, Oracle
Hi, I’d like your opinion on migrating to 64 bit platforms. Right now our Oracle 9 databases are on Windows 2003 32 bit HP servers. We re running into memory and performance limitations and are thinking about moving to 64 bit. IBM’s Power servers are tempting, even with the added expense of learning Linux. Bit [...]
Answer Question
| December 27, 2005 4:03 PM
Database, DB2, Oracle
ANNOUNCEMENT ? MORE NEW CATEGORIES ADDED TO THE ISERIES CATEGORY
UPDATE YOUR AREAS OF EXPERIENCE The following categories have been added to the AS400 ? iSeries section. Application development Systems management PC/Windows connectivity groupware & e-mail Career Opportunities for iSeries These categories were added last week: Backup & recovery Security Printing & Output Web Development – Debra Tart, associate editor, Search400.com
Answer Question
| December 23, 2005 6:47 AM
AS/400, Backup & recovery, CLP, DB2 Universal Database, Printing, RPG, RPGLE, Security, Web development
UPDATE YOUR AREAS OF EXPERIENCE The following categories have been added to the AS400 ? iSeries section. Application development Systems management PC/Windows connectivity groupware & e-mail Career Opportunities for iSeries These categories were added last week: Backup & recovery Security Printing & Output Web Development – Debra Tart, associate editor, Search400.com
Answer Question
| December 23, 2005 6:47 AM
AS/400, Backup & recovery, CLP, DB2 Universal Database, Printing, RPG, RPGLE, Security, Web development
A DBA is required for the big iSeries server
Search400.com member Fred wrote in with this statement recently: “Despite what IBM marketings says, I think that a DBA is required for the big iSeries servers.” Do you agree or disagree?” — Debra Tart, associate editor, Search400.com
Answer Question
| December 22, 2005 6:32 PM
DB2 Universal Database
Search400.com member Fred wrote in with this statement recently: “Despite what IBM marketings says, I think that a DBA is required for the big iSeries servers.” Do you agree or disagree?” — Debra Tart, associate editor, Search400.com
Answer Question
| December 22, 2005 6:32 PM
DB2 Universal Database
Methods used to maintain the access path of a file
Sarang wrote in with this question recently: “Can someone please name and define the three methods used to maintain the access path of a file?” Do you know the methods? – Debra Tart, associate editor, Search400.com
Answer Question
| December 22, 2005 4:20 PM
DB2 Universal Database
Sarang wrote in with this question recently: “Can someone please name and define the three methods used to maintain the access path of a file?” Do you know the methods? – Debra Tart, associate editor, Search400.com
Answer Question
| December 22, 2005 4:20 PM
DB2 Universal Database
Advice needed to move from DB2/400 flat-file system to Oracle
Koteswararao wrote in with this question recently: “We are planning to move from a DB2/400 flat-file system to Oracle. We do not have any relations in DB2/400. I want to extract the metamodel(total DDL scripts) from DB2/400 and go to datamodeling. Initially I thought Oracle Migration Workbench (OMWB). Unfortunately, it is not supported by V5R4 [...]
Answer Question
| December 23, 2005 9:59 AM
DB2 Universal Database
Koteswararao wrote in with this question recently: “We are planning to move from a DB2/400 flat-file system to Oracle. We do not have any relations in DB2/400. I want to extract the metamodel(total DDL scripts) from DB2/400 and go to datamodeling. Initially I thought Oracle Migration Workbench (OMWB). Unfortunately, it is not supported by V5R4 [...]
Answer Question
| December 23, 2005 9:59 AM
DB2 Universal Database
Looking for good HIP.
Hi, I am looking for a good Host-based Intrusion Prevention System to be implemented on Intel Servers in my Company. Is there anything you would recommend…?
Answer Question
| January 2, 2006 9:49 AM
Application security, backdoors, Biometrics, Compliance, CRM, Current threats, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Single sign-on, Spyware, Trojans, Viruses, VPN, Wireless, worms
Hi, I am looking for a good Host-based Intrusion Prevention System to be implemented on Intel Servers in my Company. Is there anything you would recommend…?
Answer Question
| January 2, 2006 9:49 AM
Application security, backdoors, Biometrics, Compliance, CRM, Current threats, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Single sign-on, Spyware, Trojans, Viruses, VPN, Wireless, worms
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
Outlook Express compacting
Hi All, I am currently facing a problem with outlook express compacting folders option. One of my colleague complained that last 3 months of emails are removed from Deleted Emails folder after Outlook Express finished compacting the folders. However there is no option is selected to delete the messages while compacting in maintinance tab page [...]
Answer Question
| December 15, 2005 8:50 AM
Application security, Backup & recovery, Database, Encryption, Exchange, Exchange security, Instant Messaging, Secure Coding, Tech support
Hi All, I am currently facing a problem with outlook express compacting folders option. One of my colleague complained that last 3 months of emails are removed from Deleted Emails folder after Outlook Express finished compacting the folders. However there is no option is selected to delete the messages while compacting in maintinance tab page [...]
Answer Question
| December 15, 2005 8:50 AM
Application security, Backup & recovery, Database, Encryption, Exchange, Exchange security, Instant Messaging, Secure Coding, Tech support
