Changing Server Name Where ORACLE is Loaded
Good morning, Sam. Well, it may not be quite that straight forward. Part will depend on the version of Oracle you’re using, which type(s) of SQL authentication, which platform you’re on, which modules you may have implemented (Apps, RAC, etc.) and lastly, your backup solution. (I’m probably missing some, but this is all I can [...]
View Answer
| September 13, 2006 8:52 AM
Database, DB2, Oracle
Good morning, Sam. Well, it may not be quite that straight forward. Part will depend on the version of Oracle you’re using, which type(s) of SQL authentication, which platform you’re on, which modules you may have implemented (Apps, RAC, etc.) and lastly, your backup solution. (I’m probably missing some, but this is all I can [...]
View Answer
| September 13, 2006 8:52 AM
Database, DB2, Oracle
CPYFRMIMPF issue
There’s a message thread on the problem at http://archive.midrange.com/midrange-l/200409/msg00801.html which should help. The thread talks about CCSID’s and CCSID 65535 and that prior to v5r3 the system used to use an interim file for the copy to get around the CCSID issue. Jonathan www.astradyne-uk.com
View Answer
| September 8, 2006 4:28 AM
AS/400, DB2 Universal Database, RPG, RPGLE
There’s a message thread on the problem at http://archive.midrange.com/midrange-l/200409/msg00801.html which should help. The thread talks about CCSID’s and CCSID 65535 and that prior to v5r3 the system used to use an interim file for the copy to get around the CCSID issue. Jonathan www.astradyne-uk.com
View Answer
| September 8, 2006 4:28 AM
AS/400, DB2 Universal Database, RPG, RPGLE
OSDB Connection to AS/400
What is your setup.. How are you running Worldship from the AS400..
View Answer
| September 7, 2006 8:16 AM
AS/400, DB2 Universal Database
What is your setup.. How are you running Worldship from the AS400..
View Answer
| September 7, 2006 8:16 AM
AS/400, DB2 Universal Database
Data migration strategies-2
Hi We have brought on live data from 9 seperate companies onto our iseries. We loaded the data into excel and then used MS access to link the data to the iseries files using ODBC drivers. This meant that the field names are cross referenced within access. The only difficulty we did have was with [...]
View Answer
| September 5, 2006 6:43 AM
Application development, AS/400, Data analysis, DataCenter, DB2 Universal Database, Project management
Hi We have brought on live data from 9 seperate companies onto our iseries. We loaded the data into excel and then used MS access to link the data to the iseries files using ODBC drivers. This meant that the field names are cross referenced within access. The only difficulty we did have was with [...]
View Answer
| September 5, 2006 6:43 AM
Application development, AS/400, Data analysis, DataCenter, DB2 Universal Database, Project management
please solve this query
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you [...]
View Answer
| May 13, 2013 5:08 AM
Database, DB2, Oracle, Oracle development, SQL
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you [...]
View Answer
| May 13, 2013 5:08 AM
Database, DB2, Oracle, Oracle development, SQL
Data migration strategies
The strategy you propose is error-prone. Instead, write a script to do one or more INSERT SELECTs from one schema into the other. Check your work. If the second schema was loaded properly, COMMIT it. If not, ROLL it BACK, modify your script, and execute again. — Sheldon Linker (sol@linker.com) Linker Systems, Inc. (www.linker.com) 800-315-1174 [...]
View Answer
| September 5, 2006 4:23 AM
Application development, AS/400, Data analysis, DataCenter, DB2 Universal Database, Project management
The strategy you propose is error-prone. Instead, write a script to do one or more INSERT SELECTs from one schema into the other. Check your work. If the second schema was loaded properly, COMMIT it. If not, ROLL it BACK, modify your script, and execute again. — Sheldon Linker (sol@linker.com) Linker Systems, Inc. (www.linker.com) 800-315-1174 [...]
View Answer
| September 5, 2006 4:23 AM
Application development, AS/400, Data analysis, DataCenter, DB2 Universal Database, Project management
SECURE FTP SITE ON Windows 2003
You’ve stumbled across something that a lot of us deal with in the MS world when trying to accomplish this. From my personal experience with it I would do one of two things: 1)Consider using a standard FTP server with pgp encrypted files. 2)Consider using a third party product as you already have one of [...]
View Answer
| September 1, 2006 9:14 AM
3Com, Access, Access control, Application security, Availability, backdoors, Bandwidth, BEA, Biometrics, BroadVision, Browsers, Cabling, Cisco, Citrix Systems, Compliance, configuration, Corporate portal applications, CRM, Current threats, Database, DataCenter, Desktops, Development, Digital certificates, Disaster Recovery, Encryption, Epicentric, Exchange, filtering, Firewalls, Forensics, Hacking, Hardware, Hubs, human factors, IBM, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Management, Microsoft Office, Microsoft Windows, Network security, Networking, Oracle, OS, Patch management, patching, PEN testing, PeopleSoft, Performance management, Ping, Platform Security, Plumtree, Policies, provisioning, Risk management, Routers, SAP, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SQL Server, SSL/TLS, Switches, Sybase, TIBCO, Trojans, Viruses, VPN, vulnerability management, Web security, Web services, Web Services Standards, Web site design & management, Wireless, worms
You’ve stumbled across something that a lot of us deal with in the MS world when trying to accomplish this. From my personal experience with it I would do one of two things: 1)Consider using a standard FTP server with pgp encrypted files. 2)Consider using a third party product as you already have one of [...]
View Answer
| September 1, 2006 9:14 AM
3Com, Access, Access control, Application security, Availability, backdoors, Bandwidth, BEA, Biometrics, BroadVision, Browsers, Cabling, Cisco, Citrix Systems, Compliance, configuration, Corporate portal applications, CRM, Current threats, Database, DataCenter, Desktops, Development, Digital certificates, Disaster Recovery, Encryption, Epicentric, Exchange, filtering, Firewalls, Forensics, Hacking, Hardware, Hubs, human factors, IBM, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Management, Microsoft Office, Microsoft Windows, Network security, Networking, Oracle, OS, Patch management, patching, PEN testing, PeopleSoft, Performance management, Ping, Platform Security, Plumtree, Policies, provisioning, Risk management, Routers, SAP, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SQL Server, SSL/TLS, Switches, Sybase, TIBCO, Trojans, Viruses, VPN, vulnerability management, Web security, Web services, Web Services Standards, Web site design & management, Wireless, worms
DB2 ?
Yes, you may use Data Description Specifications (DDS) to create DB2/400 files on the AS/400, iSeries, and System i5. This includes physical, logical, display, and printer files.
View Answer
| August 25, 2006 1:02 PM
DB2 Universal Database
Yes, you may use Data Description Specifications (DDS) to create DB2/400 files on the AS/400, iSeries, and System i5. This includes physical, logical, display, and printer files.
View Answer
| August 25, 2006 1:02 PM
DB2 Universal Database
need help in vb code
You could make this work right in the SQL statement: select id, @res:= case when price > @previous then 1 when price < @previous then 0 else if(@res is not NULL,@res,0 ) end as res, @previous as last_price, @previous:=price as this_price from tt; – end sql Produces: id res last_price this_price 1 1 905 905 [...]
View Answer
| August 24, 2006 12:58 AM
Database, DB2, Oracle
You could make this work right in the SQL statement: select id, @res:= case when price > @previous then 1 when price < @previous then 0 else if(@res is not NULL,@res,0 ) end as res, @previous as last_price, @previous:=price as this_price from tt; – end sql Produces: id res last_price this_price 1 1 905 905 [...]
View Answer
| August 24, 2006 12:58 AM
Database, DB2, Oracle
Microsoft Access Query Question
To show several authors for one paper you could group your report by paper. Place the paper in the group header and the author name in the group details. For your second question, you can pull in all resumes for one person by creating a report that utilizes a parameter. Ask for the name or [...]
View Answer
| August 21, 2006 11:26 AM
Database, DB2, Oracle
To show several authors for one paper you could group your report by paper. Place the paper in the group header and the author name in the group details. For your second question, you can pull in all resumes for one person by creating a report that utilizes a parameter. Ask for the name or [...]
View Answer
| August 21, 2006 11:26 AM
Database, DB2, Oracle
Caching of previous Internet Passwords on Domino Server
Hello, internet password cache is not orbey cache clearing time in Notes.ini. password clearing time is cache maintenance token even 5 minutes. longest 5 minutes, shortest time at internet password cache maintenance token were ran. Sorry, second question are cannot understood. (I’m a litte english understood.) regards
View Answer
| August 18, 2006 8:34 AM
Application security, Database, Encryption, Exchange, Instant Messaging, Lotus Domino, Secure Coding
Hello, internet password cache is not orbey cache clearing time in Notes.ini. password clearing time is cache maintenance token even 5 minutes. longest 5 minutes, shortest time at internet password cache maintenance token were ran. Sorry, second question are cannot understood. (I’m a litte english understood.) regards
View Answer
| August 18, 2006 8:34 AM
Application security, Database, Encryption, Exchange, Instant Messaging, Lotus Domino, Secure Coding
CPF5152
Not much code to draw any conclusions on, but let’s give it a whirl. I assume you have an RPG program that has an F-spec with file OUTRRX as an output file. Is this described as an externally defined file and is that file a source physical file? When a source file is created it [...]
View Answer
| August 17, 2006 12:28 PM
Application development, CLP, DB2 Universal Database, RPG
Not much code to draw any conclusions on, but let’s give it a whirl. I assume you have an RPG program that has an F-spec with file OUTRRX as an output file. Is this described as an externally defined file and is that file a source physical file? When a source file is created it [...]
View Answer
| August 17, 2006 12:28 PM
Application development, CLP, DB2 Universal Database, RPG
terminal server and gpo
I have been using a program called ScriptLogic that addresses what you wish to accomplish. I am able to set up desktops, outlook settings and other profile type settings that you can customize by user, groups, and even the type of login source (OS, workstation, server, etc… ) Check it out at ScriptLogic.com. I am [...]
View Answer
| August 6, 2006 9:49 AM
Access control, Application security, backdoors, Biometrics, Brightmail, Browsers, Business/IT alignment, Career development, CipherTrust, ClearSwift, Compliance, configuration, CRM, Current threats, Data analysis, Database, Digital certificates, Disaster Recovery, E-business, Encryption, Exchange, Exchange security, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, McAfee, MessageLabs, Network security, Outsourcing, Partner facing, patching, PEN testing, Platform Security, Policies, Postini, Project management, provisioning, Risk management, Rockliffe, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spam, SpamAssassin, Spyware, SSL/TLS, SurfControl, Symantec, TrendMicro, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
I have been using a program called ScriptLogic that addresses what you wish to accomplish. I am able to set up desktops, outlook settings and other profile type settings that you can customize by user, groups, and even the type of login source (OS, workstation, server, etc… ) Check it out at ScriptLogic.com. I am [...]
View Answer
| August 6, 2006 9:49 AM
Access control, Application security, backdoors, Biometrics, Brightmail, Browsers, Business/IT alignment, Career development, CipherTrust, ClearSwift, Compliance, configuration, CRM, Current threats, Data analysis, Database, Digital certificates, Disaster Recovery, E-business, Encryption, Exchange, Exchange security, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, McAfee, MessageLabs, Network security, Outsourcing, Partner facing, patching, PEN testing, Platform Security, Policies, Postini, Project management, provisioning, Risk management, Rockliffe, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spam, SpamAssassin, Spyware, SSL/TLS, SurfControl, Symantec, TrendMicro, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
DB2 Stored Procedure V4R4 without ILE C/400
You have to install ILE C/400. You are trying to implement functionality that does not exist in your old system. The only solution we have found that works reliably is for the remote server to call an SQL stored procedure. RPG and CL do not return result sets. You can go back to FTPing batch [...]
View Answer
| August 4, 2006 11:20 AM
AS/400, CLP, Database, DB2, DB2 Universal Database, Oracle, SQL, SQL Server
You have to install ILE C/400. You are trying to implement functionality that does not exist in your old system. The only solution we have found that works reliably is for the remote server to call an SQL stored procedure. RPG and CL do not return result sets. You can go back to FTPing batch [...]
View Answer
| August 4, 2006 11:20 AM
AS/400, CLP, Database, DB2, DB2 Universal Database, Oracle, SQL, SQL Server
Installation and updates
Are your clients all Win XP? If so, you could install the software using Group Policy then use Microsoft update on them all to download and install the Office 2003 updates automatically (that would mean setting up each machine individually though). The alternative to Microsoft Update is to use WSUS on a server which you [...]
View Answer
| August 3, 2006 6:52 AM
Access control, Active Directory, Application security, backdoors, Bandwidth, Browsers, Cabling, Cisco, Compliance, configuration, CRM, Current threats, Database, DataCenter, Desktop management applications, Desktops, Development, DHCP, Disaster Recovery, Distribution/logistics applications, DNS, Encryption, Ethernet, Exchange, filtering, Firewalls, Forensics, General Directories, Hacking, Hardware, Help Desk, Hubs, human factors, Incident response, Instant Messaging, Intrusion management, Lotus Domino, Management, Microsoft Office, Microsoft Operations Manager, Microsoft Systems Management Server, Microsoft Windows, Network applications management, Network management software, Network monitoring, Network protocols, Network security, Networking, Networking services, OS, Patch management, patching, PEN testing, Platform Security, Policies, Project management, Protocol analysis, Remote management, Risk management, Routers, Secure Coding, Security, Security Program Management, Servers, Software, Software testing, Spyware, SQL Server, SSL/TLS, Switches, Systems management software, TCP, Tech support, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Are your clients all Win XP? If so, you could install the software using Group Policy then use Microsoft update on them all to download and install the Office 2003 updates automatically (that would mean setting up each machine individually though). The alternative to Microsoft Update is to use WSUS on a server which you [...]
View Answer
| August 3, 2006 6:52 AM
Access control, Active Directory, Application security, backdoors, Bandwidth, Browsers, Cabling, Cisco, Compliance, configuration, CRM, Current threats, Database, DataCenter, Desktop management applications, Desktops, Development, DHCP, Disaster Recovery, Distribution/logistics applications, DNS, Encryption, Ethernet, Exchange, filtering, Firewalls, Forensics, General Directories, Hacking, Hardware, Help Desk, Hubs, human factors, Incident response, Instant Messaging, Intrusion management, Lotus Domino, Management, Microsoft Office, Microsoft Operations Manager, Microsoft Systems Management Server, Microsoft Windows, Network applications management, Network management software, Network monitoring, Network protocols, Network security, Networking, Networking services, OS, Patch management, patching, PEN testing, Platform Security, Policies, Project management, Protocol analysis, Remote management, Risk management, Routers, Secure Coding, Security, Security Program Management, Servers, Software, Software testing, Spyware, SQL Server, SSL/TLS, Switches, Systems management software, TCP, Tech support, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
pl/sql ref cursor question
To give a vague answer to a vague question, probably. It depends, to a large extent, on what type of resultset you’re starting with. Check these out for more details. http://www.samspublishing.com/articles/article.asp?p=26251&seqNum=7&rl=1 http://www.csee.umbc.edu/help/oracle8/java.815/a64685/oraext3.htm
View Answer
| August 2, 2006 11:57 AM
Database, DB2, DB2 Universal Database, Oracle, SQL
To give a vague answer to a vague question, probably. It depends, to a large extent, on what type of resultset you’re starting with. Check these out for more details. http://www.samspublishing.com/articles/article.asp?p=26251&seqNum=7&rl=1 http://www.csee.umbc.edu/help/oracle8/java.815/a64685/oraext3.htm
View Answer
| August 2, 2006 11:57 AM
Database, DB2, DB2 Universal Database, Oracle, SQL
Network Connection Freezes
Does the switch reports any activity when the network freezes? It looks like you have either a cable short or a bad NIC producing a broadcast storm.
View Answer
| July 28, 2006 12:41 PM
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
Does the switch reports any activity when the network freezes? It looks like you have either a cable short or a bad NIC producing a broadcast storm.
View Answer
| July 28, 2006 12:41 PM
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
USB Flash Drives Not Installing On XP
Hi, My pc is a few years old, so only has USB 1.1 I installed a card to take USB 2 devices. It is very ‘flaky’, working sometimes and not others. If I plug my USB drive into the 1.1 slot, that always works. I am using XP Pro. Does your machine in question have [...]
View Answer
| July 26, 2006 11:06 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
Hi, My pc is a few years old, so only has USB 1.1 I installed a card to take USB 2 devices. It is very ‘flaky’, working sometimes and not others. If I plug my USB drive into the 1.1 slot, that always works. I am using XP Pro. Does your machine in question have [...]
View Answer
| July 26, 2006 11:06 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
Not sure from the snippet from the UDF code if this was addressed, but… from the iSeries DB2 Universal Database for iSeries SQL Reference Version 5 Release 3 “…FINAL CALL is only allowed with PARAMETER STYLE DB2SQL or PARAMETER STYLE DB2GENERAL…”
View Answer
| July 24, 2006 8:32 AM
DB2 Universal Database
Not sure from the snippet from the UDF code if this was addressed, but… from the iSeries DB2 Universal Database for iSeries SQL Reference Version 5 Release 3 “…FINAL CALL is only allowed with PARAMETER STYLE DB2SQL or PARAMETER STYLE DB2GENERAL…”
View Answer
| July 24, 2006 8:32 AM
DB2 Universal Database
