Anyone ever use the SNDRPY command in CL?
Hi Dale In your CL program you can monitor for the message and then use the RCVMSG command to retrieve the key (if I remember correctly, it’s the KEYVAR parameter). An alternative method would be for your out of hours job to add an entry to the system reply list (ADDRPYLE) to add the “I” [...]
View Answer
| December 12, 2005 5:19 PM
AS/400, CLP, DB2 Universal Database, RPG, RPGLE
Hi Dale In your CL program you can monitor for the message and then use the RCVMSG command to retrieve the key (if I remember correctly, it’s the KEYVAR parameter). An alternative method would be for your out of hours job to add an entry to the system reply list (ADDRPYLE) to add the “I” [...]
View Answer
| December 12, 2005 5:19 PM
AS/400, CLP, DB2 Universal Database, RPG, RPGLE
Procedure Error
look for ***** modifications or comments Create or replace procedure proc_name IS Pwd varchar2(8); user varchar2(8); v_email varchar2(40); FUNCTION new_password RETURN VARCHAR IS only_alpha_characters CONSTANT VARCHAR2 (1) := ‘A’; BEGIN –Provide hard-coded password for test purposes ****** the variable or I imagine constants below are ****** not declared anywhere!! ****** (c_test_mode,c_test_mode_password ) IF c_test_mode THEN [...]
View Answer
| December 8, 2005 10:32 AM
Database, DB2, Oracle
look for ***** modifications or comments Create or replace procedure proc_name IS Pwd varchar2(8); user varchar2(8); v_email varchar2(40); FUNCTION new_password RETURN VARCHAR IS only_alpha_characters CONSTANT VARCHAR2 (1) := ‘A’; BEGIN –Provide hard-coded password for test purposes ****** the variable or I imagine constants below are ****** not declared anywhere!! ****** (c_test_mode,c_test_mode_password ) IF c_test_mode THEN [...]
View Answer
| December 8, 2005 10:32 AM
Database, DB2, Oracle
Outlook – creating Contact Lists under one main List
I would think you could make up your group list for each office and then when you make up your main you do so by adding the office groups instead of the individual email entries.
View Answer
| December 8, 2005 9:53 AM
Automated, Call Centers, Career development, Certifications, CRM, Database, DB2, Development, E-business, Exchange, Exchange security, Oracle, Partner facing, Project management, Software, Software testing, Tech support, Training
I would think you could make up your group list for each office and then when you make up your main you do so by adding the office groups instead of the individual email entries.
View Answer
| December 8, 2005 9:53 AM
Automated, Call Centers, Career development, Certifications, CRM, Database, DB2, Development, E-business, Exchange, Exchange security, Oracle, Partner facing, Project management, Software, Software testing, Tech support, Training
Encrypted files on External HD, host machine formatted but recoverable
if the files were encrypted using software you purchased you should just be able to reinstall the software and keys to access the data. i need more info to give a more detailed answer
View Answer
| December 7, 2005 5:27 PM
Application security, Biometrics, Database, Digital certificates, Encryption, Exchange, Identity & Access Management, Instant Messaging, provisioning, Secure Coding, Security, Security tokens, Single sign-on
if the files were encrypted using software you purchased you should just be able to reinstall the software and keys to access the data. i need more info to give a more detailed answer
View Answer
| December 7, 2005 5:27 PM
Application security, Biometrics, Database, Digital certificates, Encryption, Exchange, Identity & Access Management, Instant Messaging, provisioning, Secure Coding, Security, Security tokens, Single sign-on
Procedure Compilation
If you are going to embed a FUNCTION in a PROCEDURE, then it doesn’t have “CREATE OR REPLACE” and it must be in the declaration section: Create or replace procedure proc_name IS Pwd varchar2(8); user varchar2(8); v_email varchar2(40); FUNCTION new_password RETURN VARCHAR IS only_alpha_characters CONSTANT VARCHAR2 (1) := ‘A’; BEGIN –Get a random alphanumeric string [...]
View Answer
| December 7, 2005 7:32 AM
Database, DB2, Oracle
If you are going to embed a FUNCTION in a PROCEDURE, then it doesn’t have “CREATE OR REPLACE” and it must be in the declaration section: Create or replace procedure proc_name IS Pwd varchar2(8); user varchar2(8); v_email varchar2(40); FUNCTION new_password RETURN VARCHAR IS only_alpha_characters CONSTANT VARCHAR2 (1) := ‘A’; BEGIN –Get a random alphanumeric string [...]
View Answer
| December 7, 2005 7:32 AM
Database, DB2, Oracle
Performance Optimisations
There are two parts to this answer: First, views: Nobody needs views, except as a convenience. Views are macros that expand to queries. Thus, Example A: CREATE VIEW myView AS SELECT account, SUM(amount) FROM accounts GROUP BY account; SELECT * FROM myView; Example B: SELECT account, SUM(amount) FROM accounts GROUP BY account; Both of these [...]
View Answer
| December 4, 2005 7:38 PM
MySQL
There are two parts to this answer: First, views: Nobody needs views, except as a convenience. Views are macros that expand to queries. Thus, Example A: CREATE VIEW myView AS SELECT account, SUM(amount) FROM accounts GROUP BY account; SELECT * FROM myView; Example B: SELECT account, SUM(amount) FROM accounts GROUP BY account; Both of these [...]
View Answer
| December 4, 2005 7:38 PM
MySQL
iSeries any beyond
Hi. You didn’t say much about the database but let’s assume it’s AS/400 DB2. You have many options, even if you are using Oracle, MySQL etc.. If DB2 you can use DB2 Connect, it requires a separate license if not already owned. You can use SQL Server DTS on a PC as a go between. [...]
View Answer
| December 3, 2005 12:27 AM
AS/400, Data analysis, Database, DB2, Development, Oracle
Hi. You didn’t say much about the database but let’s assume it’s AS/400 DB2. You have many options, even if you are using Oracle, MySQL etc.. If DB2 you can use DB2 Connect, it requires a separate license if not already owned. You can use SQL Server DTS on a PC as a go between. [...]
View Answer
| December 3, 2005 12:27 AM
AS/400, Data analysis, Database, DB2, Development, Oracle
rpg
Doug Englander wrote the editors of Search400.com with two ideas: 1. Check the library list the program is compiling under. It could be that the file he THINKS he is compiling against is not the one he is compiling against. If that is the case, the keys could be defined differently. 2. Can we see [...]
View Answer
| December 2, 2005 8:18 AM
AS/400, CLP, DB2 Universal Database, RPG, RPGLE
Doug Englander wrote the editors of Search400.com with two ideas: 1. Check the library list the program is compiling under. It could be that the file he THINKS he is compiling against is not the one he is compiling against. If that is the case, the keys could be defined differently. 2. Can we see [...]
View Answer
| December 2, 2005 8:18 AM
AS/400, CLP, DB2 Universal Database, RPG, RPGLE
How to operating with Multiple Member PF in RPG ?
Hi Alok The secret is to override the member name before opening the file in the RPG program. The easiest way to do this is to have a CL program that accepts the PGMNAME parameter and have that perform the override before calling the RPG program. For example, something along the lines of: PGM PARM(&PGMNAME) [...]
View Answer
| December 1, 2005 6:42 PM
AS/400, CLP, DB2 Universal Database, RPG, RPGLE
Hi Alok The secret is to override the member name before opening the file in the RPG program. The easiest way to do this is to have a CL program that accepts the PGMNAME parameter and have that perform the override before calling the RPG program. For example, something along the lines of: PGM PARM(&PGMNAME) [...]
View Answer
| December 1, 2005 6:42 PM
AS/400, CLP, DB2 Universal Database, RPG, RPGLE
How to solve lock problem in Oracle 9i on Linux
A little bit more info would help What’s getting locked, how often? Any foreign key? Table structure … deadlocking in 9i is more often than not caused by bad programming in the application causing the deadlock
View Answer
| December 1, 2005 7:58 AM
Database, DB2, Oracle
A little bit more info would help What’s getting locked, how often? Any foreign key? Table structure … deadlocking in 9i is more often than not caused by bad programming in the application causing the deadlock
View Answer
| December 1, 2005 7:58 AM
Database, DB2, Oracle
SET verb in COBOL
This may seem too easy, but how about SET WS-SWITCH TO ‘B’. – Sheldon Linker Linker Systems, Inc. www.linkersystems.com sol@linker.com 800-315-1174 +1-949-552-1904
View Answer
| December 1, 2005 4:00 AM
AS/400, CLP, DB2 Universal Database, RPG, RPGLE
This may seem too easy, but how about SET WS-SWITCH TO ‘B’. – Sheldon Linker Linker Systems, Inc. www.linkersystems.com sol@linker.com 800-315-1174 +1-949-552-1904
View Answer
| December 1, 2005 4:00 AM
AS/400, CLP, DB2 Universal Database, RPG, RPGLE
Cannot connect to Database Oracle Error -1033.
First thing to do is to check the alert log. Look for any messages in there. Do you a backup of the database?
View Answer
| November 30, 2005 3:41 PM
Database, DB2, Hardware, Oracle, Software, Tech support
First thing to do is to check the alert log. Look for any messages in there. Do you a backup of the database?
View Answer
| November 30, 2005 3:41 PM
Database, DB2, Hardware, Oracle, Software, Tech support
Data Integration
You can turn the RPG program into a stored procedure: Here’s a typical SQL statement to do the link: CREATE PROCEDURE &CURRENTLIB/pr_utlfiledownloadACH( IN v_fileDir VARCHAR(200), IN v_fileName VARCHAR(50)) LANGUAGE C NOT DETERMINISTIC MODIFIES SQL DATA EXTERNAL NAME &CURRENTLIB/S_PUFDLACH PARAMETER STYLE GENERAL WITH NULLS; You will probably need less code than shown above. When you call [...]
View Answer
| November 30, 2005 3:03 PM
DB2 Universal Database, SQL Server
You can turn the RPG program into a stored procedure: Here’s a typical SQL statement to do the link: CREATE PROCEDURE &CURRENTLIB/pr_utlfiledownloadACH( IN v_fileDir VARCHAR(200), IN v_fileName VARCHAR(50)) LANGUAGE C NOT DETERMINISTIC MODIFIES SQL DATA EXTERNAL NAME &CURRENTLIB/S_PUFDLACH PARAMETER STYLE GENERAL WITH NULLS; You will probably need less code than shown above. When you call [...]
View Answer
| November 30, 2005 3:03 PM
DB2 Universal Database, SQL Server
Remore RS232 Control
Jon, Any application that gives you web-based control of the desktop PC should allow you to exercise control of the devices connected to it. A good example is a program called VNC (Virtual Network Connection). Here’s a link: http://www.realvnc.com/documentation.html If your OS is new enough, you can even do remote desktop with Windows. As a [...]
View Answer
| November 30, 2005 1:56 PM
Cabling, Database, DataCenter, DB2, Desktops, Development, DHCP, DNS, Exchange, Hardware, Management, Microsoft Office, Microsoft Windows, Mobile, Networking, Networking services, Oracle, OS, Project management, Security, Servers, Software, SQL, SQL Server, Tech support, Wireless
Jon, Any application that gives you web-based control of the desktop PC should allow you to exercise control of the devices connected to it. A good example is a program called VNC (Virtual Network Connection). Here’s a link: http://www.realvnc.com/documentation.html If your OS is new enough, you can even do remote desktop with Windows. As a [...]
View Answer
| November 30, 2005 1:56 PM
Cabling, Database, DataCenter, DB2, Desktops, Development, DHCP, DNS, Exchange, Hardware, Management, Microsoft Office, Microsoft Windows, Mobile, Networking, Networking services, Oracle, OS, Project management, Security, Servers, Software, SQL, SQL Server, Tech support, Wireless
Using Query returned values in Oracle Graphics 6i
Hi mphani.. which version of Oracle are you using? Can you please explain me a bit more of ur problem.. I did try the same thing, but i am not able to get thru ur problem clearly. with rgds. itsnexgen
View Answer
| November 28, 2005 4:40 AM
Billing and customer care, Billing Support Systems, Business/IT alignment, Career development, Database, DB2, Desktops, Development, Financials, Human Resources, Intelligence, Interaction Center Technology, Maintenance Management, Management, Manufacturing, Marketing/Sales, Microsoft Windows, Oracle, Order Management, OS, Procurement, Product Lifecycle Management, Project management, Projects, Security, Servers, Service, Software, SQL, SQL Server, Supply Chain Planning, Training
Hi mphani.. which version of Oracle are you using? Can you please explain me a bit more of ur problem.. I did try the same thing, but i am not able to get thru ur problem clearly. with rgds. itsnexgen
View Answer
| November 28, 2005 4:40 AM
Billing and customer care, Billing Support Systems, Business/IT alignment, Career development, Database, DB2, Desktops, Development, Financials, Human Resources, Intelligence, Interaction Center Technology, Maintenance Management, Management, Manufacturing, Marketing/Sales, Microsoft Windows, Oracle, Order Management, OS, Procurement, Product Lifecycle Management, Project management, Projects, Security, Servers, Service, Software, SQL, SQL Server, Supply Chain Planning, Training
VPn solution required for remote IP telephony
Since you will be connecting the phone through a VPN, I don’t see any problems IP-wise presuming the tunnel isstarted from the remote site. The only thing I am not sure of, since I’ve not had to deal with it before, is if you have teh VPN always up, how it would react when the [...]
View Answer
| November 27, 2005 5:47 PM
Application security, Availability, Cabling, Database, Encryption, Exchange, Firewalls, Forensics, Hardware, Hubs, Incident response, Instant Messaging, Intrusion management, Network security, Networking, Nortel, Routers, Secure Coding, Security, Switches, VoIP, VPN, Wireless
Since you will be connecting the phone through a VPN, I don’t see any problems IP-wise presuming the tunnel isstarted from the remote site. The only thing I am not sure of, since I’ve not had to deal with it before, is if you have teh VPN always up, how it would react when the [...]
View Answer
| November 27, 2005 5:47 PM
Application security, Availability, Cabling, Database, Encryption, Exchange, Firewalls, Forensics, Hardware, Hubs, Incident response, Instant Messaging, Intrusion management, Network security, Networking, Nortel, Routers, Secure Coding, Security, Switches, VoIP, VPN, Wireless
Regarding Oracle connectivity issues
So I am assuming you have 2 tnsnames, one in each Oracle_Home directory. Have you tried just opening a sqlplus connection and see if you could connect to the Oracle9i db. I would also try opening sqlplus from the Start->Run so as to also see which one it brings up…the 7 or 9 version. I [...]
View Answer
| November 26, 2005 12:22 PM
Database, DB2, Oracle, SQL, Windows
So I am assuming you have 2 tnsnames, one in each Oracle_Home directory. Have you tried just opening a sqlplus connection and see if you could connect to the Oracle9i db. I would also try opening sqlplus from the Start->Run so as to also see which one it brings up…the 7 or 9 version. I [...]
View Answer
| November 26, 2005 12:22 PM
Database, DB2, Oracle, SQL, Windows
DB2 Joins
There are two parts to your question: (1) Physically: Why should you care? The optimizer will arrange for it to happen in any order it likes. (2) Logically: It will happen as if in the order you specify it. Think of commutability. To some extent, the relationship is commutable. To that extent, you can’t say [...]
View Answer
| November 23, 2005 5:45 PM
DB2 Universal Database
There are two parts to your question: (1) Physically: Why should you care? The optimizer will arrange for it to happen in any order it likes. (2) Logically: It will happen as if in the order you specify it. Think of commutability. To some extent, the relationship is commutable. To that extent, you can’t say [...]
View Answer
| November 23, 2005 5:45 PM
DB2 Universal Database
Indexing on Large table
Everything else being equal, the response times for querying these two tables individually should be nearly identical. The difference would only be whatever time it takes to package the additional 50 fields for routing. That will take some time, probably uncalculable per row; But if you are returning 1,000,000 or so rows, that might be [...]
View Answer
| November 23, 2005 10:03 AM
Database, DB2, Oracle
Everything else being equal, the response times for querying these two tables individually should be nearly identical. The difference would only be whatever time it takes to package the additional 50 fields for routing. That will take some time, probably uncalculable per row; But if you are returning 1,000,000 or so rows, that might be [...]
View Answer
| November 23, 2005 10:03 AM
Database, DB2, Oracle
SQL Server 2005 adoption
I only just installed the SQL Server 2005 a few days ago, and haven’t had very much time to look at the setups yet. However it seems to me, that the Management Studio works quite better and is at the first look very easy to use. The basic functions for backing up, attaching and altering [...]
View Answer
| November 23, 2005 4:31 AM
Access, Database, DataCenter, DB2, Desktops, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server, Windows
I only just installed the SQL Server 2005 a few days ago, and haven’t had very much time to look at the setups yet. However it seems to me, that the Management Studio works quite better and is at the first look very easy to use. The basic functions for backing up, attaching and altering [...]
View Answer
| November 23, 2005 4:31 AM
Access, Database, DataCenter, DB2, Desktops, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server, Windows
