Help with SQL
Are the dates in the table the primary key? If so, you can simply use the Access query designer to join the two tables on the date field. Drop the date from one of the tables in the first column, amountone from tableA in the second column and amounttwo from tableB in the third column. [...]
View Answer
| September 22, 2005 9:19 AM
Database, DB2, Development, Oracle
Are the dates in the table the primary key? If so, you can simply use the Access query designer to join the two tables on the date field. Drop the date from one of the tables in the first column, amountone from tableA in the second column and amounttwo from tableB in the third column. [...]
View Answer
| September 22, 2005 9:19 AM
Database, DB2, Development, Oracle
Setup an sms to email gateway
As SMS is controlled by mobile supplier, they are only ones who can supply e-mail gateway, a number of them do, some as a free service. Try “SMS to E-Mail” in search engine. Or contact your mobile supplier for details. I know a number will provide the service free to sending clients, but you may [...]
View Answer
| September 19, 2005 5:11 AM
3Com, Access, Availability, Avaya, Bandwidth, Benchmarking, Cabling, Career development, Certifications, Cisco, DataCenter, Dell, Desktops, Enterasys, Enterprise Desktop, Ethernet, Exchange, Fault isolation, FDDI, Foundry, Frame Relay, H.323, Hardware, Hewlett-Packard, Hubs, IPv4, IPv6, Juniper Networks, Linux, Looking for a job, Lucent, Management, Microsoft Office, Microsoft Windows, MPLS, MySQL, NetBIOS, Network applications management, Network management software, Network monitoring, Network protocols, Network testing, Networking, Nortel, Novell IPX/SPX, OS, Patch management, People problems at work -- Get advice here, Performance management, Post a link to your IT resume, Protocol analysis, Remote management, Routers, Security, Servers, SIP, SQL Server, Switches, TCP, Updates from SearchSQLServer.com staff, Updates from SearchWindowsSecurity.com staff, Windows
As SMS is controlled by mobile supplier, they are only ones who can supply e-mail gateway, a number of them do, some as a free service. Try “SMS to E-Mail” in search engine. Or contact your mobile supplier for details. I know a number will provide the service free to sending clients, but you may [...]
View Answer
| September 19, 2005 5:11 AM
3Com, Access, Availability, Avaya, Bandwidth, Benchmarking, Cabling, Career development, Certifications, Cisco, DataCenter, Dell, Desktops, Enterasys, Enterprise Desktop, Ethernet, Exchange, Fault isolation, FDDI, Foundry, Frame Relay, H.323, Hardware, Hewlett-Packard, Hubs, IPv4, IPv6, Juniper Networks, Linux, Looking for a job, Lucent, Management, Microsoft Office, Microsoft Windows, MPLS, MySQL, NetBIOS, Network applications management, Network management software, Network monitoring, Network protocols, Network testing, Networking, Nortel, Novell IPX/SPX, OS, Patch management, People problems at work -- Get advice here, Performance management, Post a link to your IT resume, Protocol analysis, Remote management, Routers, Security, Servers, SIP, SQL Server, Switches, TCP, Updates from SearchSQLServer.com staff, Updates from SearchWindowsSecurity.com staff, Windows
Microsoft Terminal Services and RPG socket programming
I know that all the clients have unique addresses between themselves and the server. You seem to say that the only address the ’400′ sees is that of the server itself. The server is supposed handle routing between client and outside world. If a client issues a request and the ’400′ responds does the data [...]
View Answer
| September 15, 2005 3:31 PM
AS/400, DB2 Universal Database, Desktops, Distribution/logistics applications, Management, Microsoft Windows, OS, RPG, Security, Servers, SQL Server
I know that all the clients have unique addresses between themselves and the server. You seem to say that the only address the ’400′ sees is that of the server itself. The server is supposed handle routing between client and outside world. If a client issues a request and the ’400′ responds does the data [...]
View Answer
| September 15, 2005 3:31 PM
AS/400, DB2 Universal Database, Desktops, Distribution/logistics applications, Management, Microsoft Windows, OS, RPG, Security, Servers, SQL Server
Passing PL/SQL Table As Parameter.
If you declare the array outside the Package with the “create type” command and still have the benfits of the BULK COLLECT. You can indeed pass the java a REFCURSOR which would look like a simple returnset to them. Just use a TABLE(CAST( construct in the FROM clause. MrO
View Answer
| September 14, 2005 2:45 PM
Database, DB2, Development, Oracle
If you declare the array outside the Package with the “create type” command and still have the benfits of the BULK COLLECT. You can indeed pass the java a REFCURSOR which would look like a simple returnset to them. Just use a TABLE(CAST( construct in the FROM clause. MrO
View Answer
| September 14, 2005 2:45 PM
Database, DB2, Development, Oracle
has anyone had issues with appliances getting cracked?
A computer is a computer is a computer, and by any other name still subject to the same smell. (apologies to Will.) I am not familiar with the appliance you have but do work at a Health Science Center. We have had recurring problems with embedded systems. Heart rate monitors, ventilators with Windows 2k as [...]
View Answer
| September 14, 2005 7:43 AM
Access control, Application security, backdoors, Browsers, configuration, Current threats, Database, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Secure Coding, Servers, Spyware, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
A computer is a computer is a computer, and by any other name still subject to the same smell. (apologies to Will.) I am not familiar with the appliance you have but do work at a Health Science Center. We have had recurring problems with embedded systems. Heart rate monitors, ventilators with Windows 2k as [...]
View Answer
| September 14, 2005 7:43 AM
Access control, Application security, backdoors, Browsers, configuration, Current threats, Database, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Secure Coding, Servers, Spyware, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Way to speed up first invocation of stored procedure?
John Paul Lamontre said this is not an easy question. He writes: First, run SQL under STRDBG (without any parameter). You will have a complete description of the SQL optimiser process. Inspect in detail each message, checking for a missing index or other requirements of SQL. If second runs are quicker, SQL has probably delayed [...]
View Answer
| September 13, 2005 9:19 PM
AS/400, DB2 Universal Database
John Paul Lamontre said this is not an easy question. He writes: First, run SQL under STRDBG (without any parameter). You will have a complete description of the SQL optimiser process. Inspect in detail each message, checking for a missing index or other requirements of SQL. If second runs are quicker, SQL has probably delayed [...]
View Answer
| September 13, 2005 9:19 PM
AS/400, DB2 Universal Database
CHGPF command
yes. works great. It is possible to run into problems if you try to convert an existing field to a different type.
View Answer
| September 13, 2005 9:51 AM
AS/400, DB2 Universal Database, RPG
yes. works great. It is possible to run into problems if you try to convert an existing field to a different type.
View Answer
| September 13, 2005 9:51 AM
AS/400, DB2 Universal Database, RPG
Network neigbhorhood
Application startup on a server can be slow, but an hour is ludicrous. If server has internet connection, my first guess would be a trojan, or other adware resource hog. Straight AV software is not likely to detect this. Suggest try Adware, or Spybot, free downloads to check this. Also HijackThis, but you will need [...]
View Answer
| September 13, 2005 5:19 AM
Access, Active Directory, AS/400, Bind, Database, DataCenter, DB2, Desktops, Development, DHCP, DNS, Exchange, Help Desk, Linux, Lotus Domino, Management, Manufacturing applications, Microsoft Office, Microsoft Windows, MySQL, Network applications management, Network management software, Network monitoring, Network testing, Networking, Networking services, Oracle, OS, Patch management, Performance management, Ping, Remote management, Security, Servers, SQL, SQL Server, TCP, VoIP
Application startup on a server can be slow, but an hour is ludicrous. If server has internet connection, my first guess would be a trojan, or other adware resource hog. Straight AV software is not likely to detect this. Suggest try Adware, or Spybot, free downloads to check this. Also HijackThis, but you will need [...]
View Answer
| September 13, 2005 5:19 AM
Access, Active Directory, AS/400, Bind, Database, DataCenter, DB2, Desktops, Development, DHCP, DNS, Exchange, Help Desk, Linux, Lotus Domino, Management, Manufacturing applications, Microsoft Office, Microsoft Windows, MySQL, Network applications management, Network management software, Network monitoring, Network testing, Networking, Networking services, Oracle, OS, Patch management, Performance management, Ping, Remote management, Security, Servers, SQL, SQL Server, TCP, VoIP
Use of %Lookup BIF in Free form RPG – V5R3?
Can you submit a sample of the code you are using?
View Answer
| September 12, 2005 12:29 PM
AS/400, Database, DB2 Universal Database, RPG, RPG ILE
Can you submit a sample of the code you are using?
View Answer
| September 12, 2005 12:29 PM
AS/400, Database, DB2 Universal Database, RPG, RPG ILE
Bad response time for first invocation of stored procedures in DB2400
iSeries DB2 (SQL) is very sensitive to access paths. With response times like you describe that’s the first place I look. Try creating an index over the file with the same columns as either your ORDER BY or your WITH clause (in the same order).
View Answer
| September 12, 2005 8:14 AM
DB2 Universal Database
iSeries DB2 (SQL) is very sensitive to access paths. With response times like you describe that’s the first place I look. Try creating an index over the file with the same columns as either your ORDER BY or your WITH clause (in the same order).
View Answer
| September 12, 2005 8:14 AM
DB2 Universal Database
How to disable export option in 11.5.9 thru applications.
Noticed you haven’t had a reply. I don’t know of a profile but you might consider using the custom form library to disable this. HTH Ken F.
View Answer
| September 9, 2005 9:50 AM
Database, DB2, E-business, Oracle, Security, Windows
Noticed you haven’t had a reply. I don’t know of a profile but you might consider using the custom form library to disable this. HTH Ken F.
View Answer
| September 9, 2005 9:50 AM
Database, DB2, E-business, Oracle, Security, Windows
Restoring patch from 8.1.7.4 to 8.1.7.2. Verify steps
I’ve patched from 8.1.7 to 8.1.7.4 directly and all that changed was the binaries, my enterprise edition software for oracle worked fine after upgrade. I see no need for and upgrade of data dictionary or a restore of 8.1.7.2 binaries. Unless there is a history to this question I am not aware of.
View Answer
| September 9, 2005 3:31 AM
Database, DB2, Oracle
I’ve patched from 8.1.7 to 8.1.7.4 directly and all that changed was the binaries, my enterprise edition software for oracle worked fine after upgrade. I see no need for and upgrade of data dictionary or a restore of 8.1.7.2 binaries. Unless there is a history to this question I am not aware of.
View Answer
| September 9, 2005 3:31 AM
Database, DB2, Oracle
sqlloader problem while loading from a huge csv file
I would try to investigate the 3000000 number that is referenced in the error message, could a number this size fit into a type ‘integer’ column? Perhaps, the column in question needs a size change…
View Answer
| September 6, 2005 4:18 PM
Database, DB2, Oracle
I would try to investigate the 3000000 number that is referenced in the error message, could a number this size fit into a type ‘integer’ column? Perhaps, the column in question needs a size change…
View Answer
| September 6, 2005 4:18 PM
Database, DB2, Oracle
tutorials
Start on this site. You can also Google using +tutorials +”your operating system” +”language of interest” Worked for me.
View Answer
| September 1, 2005 4:01 PM
ABAP, ActiveX, ADA, AppleScript, ASP, ASP.NET, BASIC, Billing and customer care, Billing Support Systems, C, CGI, COBOL, ColdFusion, Computer Associates, Delphi, Development, Distribution/logistics applications, Enterprise Desktop, Forth, Fortran, HTML, J#, J2EE, Java, JavaScript, JSP, Linux, Lotus Domino, LotusScript, Microsoft Windows, MySQL, Networking, Oracle, Pascal, Perl, PHP, Platform Issues, PowerBuilder, Programming Languages, Python, REXX, RPG, Ruby, Smalltalk, Software Quality Assurance, Software testing, SQL, T-SQL, Tcl-Tkl, VB.NET, VBA, VBScript, Visual Basic, XML
Start on this site. You can also Google using +tutorials +”your operating system” +”language of interest” Worked for me.
View Answer
| September 1, 2005 4:01 PM
ABAP, ActiveX, ADA, AppleScript, ASP, ASP.NET, BASIC, Billing and customer care, Billing Support Systems, C, CGI, COBOL, ColdFusion, Computer Associates, Delphi, Development, Distribution/logistics applications, Enterprise Desktop, Forth, Fortran, HTML, J#, J2EE, Java, JavaScript, JSP, Linux, Lotus Domino, LotusScript, Microsoft Windows, MySQL, Networking, Oracle, Pascal, Perl, PHP, Platform Issues, PowerBuilder, Programming Languages, Python, REXX, RPG, Ruby, Smalltalk, Software Quality Assurance, Software testing, SQL, T-SQL, Tcl-Tkl, VB.NET, VBA, VBScript, Visual Basic, XML
Creation of a new schema in Oracle
User/Schema are essentially the same thing. A schema is a user account that owns database objects such as tables, views, indexes, procedures, etc. Other user accounts would probably then be created that are granted privileges on the owning user/schema’s objects in order to run an application. Each user account will have a specific default and [...]
View Answer
| September 1, 2005 11:43 AM
Database, DB2, Oracle
User/Schema are essentially the same thing. A schema is a user account that owns database objects such as tables, views, indexes, procedures, etc. Other user accounts would probably then be created that are granted privileges on the owning user/schema’s objects in order to run an application. Each user account will have a specific default and [...]
View Answer
| September 1, 2005 11:43 AM
Database, DB2, Oracle
SqlDumpExceptionHandler Error Message In MS SQL Server 7.0
Error – c0000005 – access denied For what ever reason at least part of the file you are trying to restore does NOT belong to the account you are using for the restore. 1 – is this a new instance of SQL server and you are transferring the database? 2 – is this a repaired [...]
View Answer
| September 1, 2005 8:49 AM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, Software, SQL, SQL Server, Tech support, Updates from SearchSQLServer.com staff
Error – c0000005 – access denied For what ever reason at least part of the file you are trying to restore does NOT belong to the account you are using for the restore. 1 – is this a new instance of SQL server and you are transferring the database? 2 – is this a repaired [...]
View Answer
| September 1, 2005 8:49 AM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, Software, SQL, SQL Server, Tech support, Updates from SearchSQLServer.com staff
Windows 2000 Server logs
If you are looking for a covert way to monitor then you might want to look at a product called Track4Win. I’m not sure if it will do everything you want but I know you can get a free trial. There are probably a million other products that do the same thing out there, this [...]
View Answer
| September 1, 2005 8:16 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
If you are looking for a covert way to monitor then you might want to look at a product called Track4Win. I’m not sure if it will do everything you want but I know you can get a free trial. There are probably a million other products that do the same thing out there, this [...]
View Answer
| September 1, 2005 8:16 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
AS400 configuration management tools
You need to set Security Auditing. Good start is www.iseriesnework.com, but you must register as a Pro member (and it must be paid). Direct link: http://www.iseriesnetwork.com/artarchive/index.cfm?fuseaction=viewNewsletterArticle&articleID=51323&webID=1001&override=0 For first article: “Security Auditing — How Else Can You Know?” Second article (also good for start): “Common Sense Security Auditing”
View Answer
| September 1, 2005 4:10 AM
AS/400, Data analysis, Database
You need to set Security Auditing. Good start is www.iseriesnework.com, but you must register as a Pro member (and it must be paid). Direct link: http://www.iseriesnetwork.com/artarchive/index.cfm?fuseaction=viewNewsletterArticle&articleID=51323&webID=1001&override=0 For first article: “Security Auditing — How Else Can You Know?” Second article (also good for start): “Common Sense Security Auditing”
View Answer
| September 1, 2005 4:10 AM
AS/400, Data analysis, Database
Moving Log Files in Oracle 9.2.0
What you need to do is take the database down cleanly i.e. not shutdown abort. Using filesystem commands move the log files to the correct location Mount the database – startup mount Then use – alter database rename file ‘old name’ to ‘new name’ for each log file then open the database – alter database [...]
View Answer
| September 1, 2005 4:00 AM
Database, DB2, Oracle
What you need to do is take the database down cleanly i.e. not shutdown abort. Using filesystem commands move the log files to the correct location Mount the database – startup mount Then use – alter database rename file ‘old name’ to ‘new name’ for each log file then open the database – alter database [...]
View Answer
| September 1, 2005 4:00 AM
Database, DB2, Oracle
