pl/sql ref cursor question
Hi, I’m trying to figure out if this is possible in Java OPTION 1 ================== 1. Obtain a ResultSet by querying a non-oracle database 2. Cast the resultSet into an OracleResultSet 3. Pass the OracleResultSet into a pl/sql stored procedure for processing OPTION 2 ================= 1. Obtain a ResultSet by querying a non-oracle database 2. [...]

Answer Question   |  August 2, 2006  6:11 PM
Database, DB2, DB2 Universal Database, Oracle, SQL

Network Connection Freezes
For some reason, at random, among 20 PCs on my network, in the morning or during the day, the network connection stops responding for both intranet and internet communications. The only solution thus far is to remove the NIC from the Device Manager, reboot the PC, and let Windows XP Pro find the network card [...]

Answer Question   |  September 1, 2010  11:31 AM
3Com, Access, Access control, Active Directory, Application security, Availability, Avaya, backdoors, Bandwidth, Bind, Biometrics, Browsers, Cabling, Cisco, Compliance, configuration, CRM, Current threats, Database, DataCenter, Dell, Desktops, DHCP, Digital certificates, Disaster Recovery, DNS, Encryption, Enterasys, Ethernet, Exchange, FDDI, filtering, Firewalls, Forensics, Foundry, Frame Relay, General Directories, H.323, Hacking, Hardware, Hewlett-Packard, Hubs, human factors, Identity & Access Management, Incident response, Instant Messaging, Interoperability, Intrusion management, IPv4, IPv6, Juniper Networks, LDAP, Lotus Domino, Lucent, Management, Microprocessors, Microsoft Office, Microsoft Windows, MPLS, NetBIOS, Network monitoring, Network protocols, Network security, Networking, Networking services, NFS, NIC, Nortel, Novell IPX/SPX, Novell NDS, OS, Patch management, patching, PEN testing, Performance management, Ping, Platform Security, Policies, Printers, provisioning, Risk management, Routers, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, SIP, Software, Spyware, SQL Server, SSL/TLS, Switches, TCP, Tech support, Trojans, Viruses, VPN, vulnerability management, Web security, WINS, Wireless, worms

Job Schedule Entries Migration
Hi All, We are migrating from an 820 to a new 550 i5 this weekend. Does anyone know how we can migrate the current Job Schedule Entries on the 820 to the 550? Is there an API to the database that holds the Job Schedule Entry details that we can use to extract the info [...]

Answer Question   |  December 13, 2009  9:18 AM
Application development, AS/400, Backup & recovery, CLP, DataCenter, DB2 Universal Database, RPG, RPGLE

USB Flash Drives Not Installing On XP
Hello All! I’ve been noticing recently that certain USB drives have not been installing automatically to windows XP pro. I’m working on one right now and have not found a solution to it yet. A user needs to install a Sandisk Cruzer Mini USB Drive to her machine which uses XP Pro. Instead of installing [...]

Answer Question   |  July 28, 2006  8:57 PM
Access control, Application security, Availability, backdoors, Backup & recovery, Browsers, Career development, Current threats, Database, DataCenter, Desktop management applications, Desktops, Development, Encryption, Exchange, filtering, Hacking, Hardware, Hewlett-Packard, human factors, Instant Messaging, Management, Microsoft Office, Microsoft Windows, Networking, OS, Patch management, SCSI, Secure Coding, Security, Servers, Software, Software testing, Spyware, SQL Server, SSL/TLS, Storage, Storage management, Storage products and equipment, Tape drives/Libraries, Tech support, Training, Trojans, Viruses, Web security, worms

DB2 not making the FINAL CALL to my user-defined function
UDF is written in RPGLE, and the CREATE FUNCTION specifies SCRATCHPAD and FINAL CALL. When I do an INSERT statement with the UDF specified for one of the columns, I get called twice. The first has a CALLTYPE of -1, and the second CALLTYPE is 0. I’m expecting a third invocation with a CALLTYPE of [...]

Answer Question   |  July 24, 2006  10:48 AM
DB2 Universal Database

Tracking the computer or source of an email
system: Ex 2003 back-end cluster, Ex 2003 Network Load Balanced Front end. Hi there, A user’s account has become comprimised. They have since changed their password, but there are a few mails sent from their account that they did not send. Is it possible to find out the source ie PC hostname or IP address [...]

Answer Question   |  August 11, 2011  3:55 AM
Application security, Biometrics, Database, Digital certificates, Encryption, Exchange, Exchange security, Firewalls, Forensics, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, provisioning, Secure Coding, Security tokens, Single sign-on, VPN, Wireless

Resticting QPGMR from selected objects (SOX related)
Our security level is 30, but I have not found a way to restrict QPGMR from deleting a member in an audit file. Any help on this.

Answer Question   |  July 21, 2006  8:11 PM
Application security, Database, DataCenter, Encryption, Exchange, Instant Messaging, Secure Coding

Oracle Application or Database on its own server.
Which would increase performance more. Moving an Oracle demand planning and forcasting application or an Oracle database onto its own server and or a faster server? There is some debate among myself and a couple of coworkers. I feel that the workhorse of Oracle is the database and that it should be on its own [...]

Answer Question   |  July 14, 2006  10:47 AM
Database, DB2, Oracle, Performance/Tuning, Windows

SQLCOD = -7008 when doing an insert into file using SQLRPGLE-2
Hi, I’m trying to insert selective records from one file into the same file in another library. I have to do this for many file. Am building the query dynamically using SQLRPGLE. Am using a PREPARE statement and an EXECUTE statement to run the query. While the PREPARE statement ends fine, am getting an SQLCOD [...]

Answer Question   |  December 11, 2009  12:45 PM
Application development, AS/400, Backup & recovery, CLP, DB2 Universal Database, RPG, RPGLE

SQLCOD = -7008 when doing an insert into file using SQLRPGLE
Hi, I’m trying to insert selective records from one file into the same file in another library. I have to do this for many file. Am building the query dynamically using SQLRPGLE. Am using a PREPARE statement and an EXECUTE statement to run the query. While the PREPARE statement ends fine, am getting an SQLCOD [...]

Answer Question   |  January 29, 2010  12:44 PM
Application development, AS/400, Backup & recovery, CLP, DB2 Universal Database, RPG, RPGLE

Passwords
Hi all, What do you recommend for initial password issue, that is, provided a new user with a password for the first time without compromising it. I find the entire help desk giving password initially or sysadmins doing that is not save enough even though the user will be prompted to change it at first [...]

Answer Question   |  November 24, 2007  8:11 AM
Access control, Application security, backdoors, Biometrics, Browsers, Business/IT alignment, Compliance, configuration, CRM, Current threats, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, Exchange security, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms

Deleted Users
Hi Is there any way we can know about deleted userprofiles in AS400? We have an audit process wherein the auditor have asked for a list of all the users deleted. Can any one suggest where can I get such a list? pgsdeb

Answer Question   |  November 22, 2010  7:44 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Security

Can’t login as Administrator
Hello Everybody, I can’t login to adminstrator profile in my standalone win 2000 adv server. I use this system for my study purposes. What happened actually is when I was shuting my system, it got powered off because of some UPS problem and the next time when I logged in using Administrator, it showed me [...]

Answer Question   |  June 29, 2006  7:29 AM
Backup & recovery, Cabling, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DataManagement, DB2, Desktop management applications, Desktops, DHCP, DNS, Ecommerce applications, Enterprise Desktop, Exchange, Hardware, Hewlett-Packard, Hubs, Instant Messaging, Lotus Domino, Management, Microsoft Systems Management Server, Microsoft Windows, Network management software, Networking, Networking services, Oracle, OS, PC/Windows Connectivity, Power management, Routers, Security, Servers, Software, SQL Server, Switches, Systems management software, Tech support, Training

Operating Console
Hi I have operations console running on a laptop which is directly connected to my I-Series. All runs okay until the laptop powers down(for variety of reasons), when i power it on again it will not connect to the I-Series without doing an IPL of the I-Series. I get the message “Connecting Console” and it [...]

Answer Question   |  July 5, 2006  2:52 AM
AS/400, Backup & recovery, DataCenter, DB2 Universal Database, Security

Port 1894
Hi, Our port scanner has detected ’1894′ as an open port. We know 1894 is an ‘O2Server’ port. Could you please throw some light on the port ’1894′? Thanks kbs

Answer Question   |  June 27, 2006  8:02 AM
Access control, Application security, backdoors, Biometrics, Browsers, Compliance, configuration, CRM, Current threats, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms

Laptop Security…
Hi, I am the head of my department and by the nature of the job I hold some confidential information on my laptop. How do I ensure that 1. Nobody can access any files on my laptop from the LAN or the internet (not even sys admins) 2. If somebody tries to access, can I [...]

Answer Question   |  June 27, 2006  9:31 AM
Access control, Application security, backdoors, Biometrics, Browsers, Compliance, configuration, CRM, Current threats, Database, DataCenter, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms

Data mapping errors when reading records with time fields…
I’m trying to access records from a file that has eight fields defined with the time attibute. When I examine the data held in these fields they are mostly set to *LOVAL i.e. 00.00.00 in *ISO format which according to the RPGLE reference manual is an allowable value. However, when my program attempts to read [...]

Answer Question   |  November 22, 2010  9:51 AM
Application development, DB2 Universal Database, RPGLE

SQL Alias visibility
We have found that creating an SQL alias works for accessing file members in embedded and interactive SQL. But if we create an ALIAS in our live libraries with the intention of keeping it for frequent use, how do we know it exists other than WRKOBJ? It doesn’t show up in DSPDBR. And is there [...]

Answer Question   |  June 23, 2006  4:17 PM
Application development, DB2 Universal Database, SQL

CLASP guidelines
My company is considering implementing the CLASP (Comprehensive, Lightweight, Application, Security Process) in our development cycle. Has anyone done this? How was it handled? How did it affect production? Any info you can share would be extremely helpful.

Answer Question   |  August 3, 2006  3:42 PM
Application security, Database, Development, Encryption, Exchange, Instant Messaging, Lifecycle development, Project management, Secure Coding

Opinions about firewalls and VPN
I currently have watchguard firewalls and IPSec tunnels between them and the other watchguard firewalls. We also have remote users VPN into the firewall for access to our network. Our firewalls are fine but we haven’t been that happy with the support over the last 5 or so years. We are joining together with another [...]

Answer Question   |  June 28, 2006  9:56 AM
Active Directory, Application security, Budgeting, Cabling, Cisco, Database, Dell, Desktops, DHCP, DNS, Encryption, Exchange, Firewalls, Forensics, Foundry, Hardware, Hubs, Incident response, Instant Messaging, Intrusion management, Juniper Networks, Management, Microsoft Windows, Network security, Networking, Networking services, OS, Project management, Routers, Secure Coding, Security, Servers, SQL Server, Switches, VPN, Wireless