Assessing Security Appliances
We have several appliances performing specialized tasks in our environment. I’ve been asked to perform an audit of these appliances. Since most of these appliances run a version of Linux/Unix I’ve decided to audit in a two phase process. First looking at the OS/Kernel and then the application. My question is there an auditing framework [...]
Answer Question
| February 25, 2007 4:36 PM
Application security, Database, Encryption, Exchange, Instant Messaging, Secure Coding
We have several appliances performing specialized tasks in our environment. I’ve been asked to perform an audit of these appliances. Since most of these appliances run a version of Linux/Unix I’ve decided to audit in a two phase process. First looking at the OS/Kernel and then the application. My question is there an auditing framework [...]
Answer Question
| February 25, 2007 4:36 PM
Application security, Database, Encryption, Exchange, Instant Messaging, Secure Coding
Lotus Domino Database Structure
Hi I am trying to map a Lotus Domino Database into tables. Is is true that Views are like tables and documents are like rows in the view? Is this the right way to do it? If not, please could you explain how to do the mapping? Thank you in advance Mirkia Sadler
Answer Question
| February 23, 2007 12:56 PM
Architecture/Design, Availability, Database, DB2, Desktops, Development, Installation, Management, Microsoft Windows, Oracle, Oracle administration, OS, Security, Servers, Software testing, SQL, SQL Server
Hi I am trying to map a Lotus Domino Database into tables. Is is true that Views are like tables and documents are like rows in the view? Is this the right way to do it? If not, please could you explain how to do the mapping? Thank you in advance Mirkia Sadler
Answer Question
| February 23, 2007 12:56 PM
Architecture/Design, Availability, Database, DB2, Desktops, Development, Installation, Management, Microsoft Windows, Oracle, Oracle administration, OS, Security, Servers, Software testing, SQL, SQL Server
Correlated Subquery – NOT EXIST
Hi - I’m trying to add a not exist subquery in my where statement and have several other joins ahead of it. I’m having difficulty determining where to put the NOT EXIST as the subquery is named as a column – ie blue.color in (select * from …..). Where would I put the NOT EXIST [...]
Answer Question
| February 22, 2007 3:00 PM
MySQL, SQL, SQL Server
Hi - I’m trying to add a not exist subquery in my where statement and have several other joins ahead of it. I’m having difficulty determining where to put the NOT EXIST as the subquery is named as a column – ie blue.color in (select * from …..). Where would I put the NOT EXIST [...]
Answer Question
| February 22, 2007 3:00 PM
MySQL, SQL, SQL Server
Windows Scheduling iSeries Data Transfer
I have 4 data transfers created in IBMs data transfer from iSeries Server programs that I need to schedule using Windows Scheduler. I can make the transfers work by double clicking on the .dtf but when I try and schedule them I get the following errors: filename, directory name, or volume labe syntax is incorrect. [...]
Answer Question
| June 18, 2010 3:40 PM
AS/400, DB2 Universal Database, Desktops, Management, Microsoft Windows, OS, PC/Windows Connectivity, Security, Servers, Software, SQL, SQL Server, Tech support, Web development
I have 4 data transfers created in IBMs data transfer from iSeries Server programs that I need to schedule using Windows Scheduler. I can make the transfers work by double clicking on the .dtf but when I try and schedule them I get the following errors: filename, directory name, or volume labe syntax is incorrect. [...]
Answer Question
| June 18, 2010 3:40 PM
AS/400, DB2 Universal Database, Desktops, Management, Microsoft Windows, OS, PC/Windows Connectivity, Security, Servers, Software, SQL, SQL Server, Tech support, Web development
how to interconnect sql server with remote oracle server
I have sql server on my system and Oracle system on the remote system and I need to fetch the data from the remote oracle on my sql server. please send me the steps of the whole process.
Answer Question
| February 5, 2007 1:00 AM
Database, DB2, Oracle, SQL, SQL Server
I have sql server on my system and Oracle system on the remote system and I need to fetch the data from the remote oracle on my sql server. please send me the steps of the whole process.
Answer Question
| February 5, 2007 1:00 AM
Database, DB2, Oracle, SQL, SQL Server
Email Delivery Errors
Hello All, Someone is having problems sending emails to us which did not exist before. Our email server (Unix based) did not list his domain as spam according to our email technician. Also for troubleshooting purposes i’ve asked him to send to my hotmail account which resulted in the same manor not receiving. After several [...]
Answer Question
| January 31, 2007 4:47 AM
Application security, backdoors, Brightmail, CipherTrust, ClearSwift, Current threats, Database, Encryption, Exchange, Hacking, human factors, Instant Messaging, McAfee, MessageLabs, Postini, Rockliffe, Secure Coding, Security, Spam, SpamAssassin, Spyware, SurfControl, Symantec, TrendMicro, Trojans, Viruses, worms
Hello All, Someone is having problems sending emails to us which did not exist before. Our email server (Unix based) did not list his domain as spam according to our email technician. Also for troubleshooting purposes i’ve asked him to send to my hotmail account which resulted in the same manor not receiving. After several [...]
Answer Question
| January 31, 2007 4:47 AM
Application security, backdoors, Brightmail, CipherTrust, ClearSwift, Current threats, Database, Encryption, Exchange, Hacking, human factors, Instant Messaging, McAfee, MessageLabs, Postini, Rockliffe, Secure Coding, Security, Spam, SpamAssassin, Spyware, SurfControl, Symantec, TrendMicro, Trojans, Viruses, worms
SQL RRN Processing – by Key?
I’m putting together a job that needs to process a large masterfile in a very short period of time. To do this, I’m (sorta) cloning an existing SQLRPGLE application that runs multiple concurrent copies of a program…each processing a range of the file by RRN. The number of copies is dynamic, set by an input [...]
Answer Question
| December 29, 2009 11:27 PM
DB2 Universal Database, RPGLE
I’m putting together a job that needs to process a large masterfile in a very short period of time. To do this, I’m (sorta) cloning an existing SQLRPGLE application that runs multiple concurrent copies of a program…each processing a range of the file by RRN. The number of copies is dynamic, set by an input [...]
Answer Question
| December 29, 2009 11:27 PM
DB2 Universal Database, RPGLE
How can I find on which files a program has been attached as an external trigger?
I have a “generic” rpgle program that can be attached to any physical file as a trigger. And so it has been, many times.. Is there a utility that I can use to find exactly what files have this program attached as a trigger? Or some table where I can look? Thanks! Kevin
Answer Question
| January 24, 2007 5:56 PM
Application development, AS/400, DB2 Universal Database, RPGLE
I have a “generic” rpgle program that can be attached to any physical file as a trigger. And so it has been, many times.. Is there a utility that I can use to find exactly what files have this program attached as a trigger? Or some table where I can look? Thanks! Kevin
Answer Question
| January 24, 2007 5:56 PM
Application development, AS/400, DB2 Universal Database, RPGLE
Windows Server 2003 Web Edition Configuration
I have been out of the web development arena for a few years and decided to brush up on new technology. I installed Windows Server 2003 Web Edition on my home domain and placed the machine in the DMZ. I published a basic page and all works well. I published a standard template forum from [...]
Answer Question
| January 22, 2007 10:44 AM
Database, DataCenter, DB2, Desktops, Development, Interoperability, Management, Microsoft Windows, Oracle, OS, Security, Servers, Software, SQL, SQL Server, Tech support, Web development tools, Web site design & management
I have been out of the web development arena for a few years and decided to brush up on new technology. I installed Windows Server 2003 Web Edition on my home domain and placed the machine in the DMZ. I published a basic page and all works well. I published a standard template forum from [...]
Answer Question
| January 22, 2007 10:44 AM
Database, DataCenter, DB2, Desktops, Development, Interoperability, Management, Microsoft Windows, Oracle, OS, Security, Servers, Software, SQL, SQL Server, Tech support, Web development tools, Web site design & management
Oracle Database Issue
Hi all We have a 10g oracle server but the problem is that it keeps dying out every now and then. we are usind it on red hat. i tried opening the emctl dbconsole for oem . it opens up but the instance status shows the error ORA-12537: TNS:connection closed (DBD ERROR: OCIServerAttach) and on [...]
Answer Question
| January 12, 2007 7:30 PM
Database, DB2, Linux, Oracle
Hi all We have a 10g oracle server but the problem is that it keeps dying out every now and then. we are usind it on red hat. i tried opening the emctl dbconsole for oem . it opens up but the instance status shows the error ORA-12537: TNS:connection closed (DBD ERROR: OCIServerAttach) and on [...]
Answer Question
| January 12, 2007 7:30 PM
Database, DB2, Linux, Oracle
malformed packet alert
I get this message from my router every 2 minuets or so. I tried blocking to ports that it attacks and the IP but the major issue is that, that IP is a broadcast IP, so i don’t know where it is coming from. What my question is, is how do is stop these alerts [...]
Answer Question
| January 10, 2007 1:28 AM
Application security, configuration, Database, Encryption, Exchange, Firewalls, Forensics, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Secure Coding, Security, VPN, vulnerability management, Wireless
I get this message from my router every 2 minuets or so. I tried blocking to ports that it attacks and the IP but the major issue is that, that IP is a broadcast IP, so i don’t know where it is coming from. What my question is, is how do is stop these alerts [...]
Answer Question
| January 10, 2007 1:28 AM
Application security, configuration, Database, Encryption, Exchange, Firewalls, Forensics, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Secure Coding, Security, VPN, vulnerability management, Wireless
FTP from iSeries DB2 to iSeries AIX (Oracle)
I’m taking a FILE and using CPYTOIMPF to either create the flat file pipe delimited to another DB2 File or directly to the IFS as *PCASCII. Using iSeriesNavigator, I have no problem looking at the IFS. No issue with iSeriesNavigator and looking at FILE either. Using FTP, <namefmt 1>, <mode binary>, I’m able to send [...]
Answer Question
| January 1, 2010 3:08 PM
Application development, AS/400, DB2 Universal Database
I’m taking a FILE and using CPYTOIMPF to either create the flat file pipe delimited to another DB2 File or directly to the IFS as *PCASCII. Using iSeriesNavigator, I have no problem looking at the IFS. No issue with iSeriesNavigator and looking at FILE either. Using FTP, <namefmt 1>, <mode binary>, I’m able to send [...]
Answer Question
| January 1, 2010 3:08 PM
Application development, AS/400, DB2 Universal Database
AS400 intreface with other platforms
Can anybody tell me how to interface As/400 with other platforms say windows or linux for example
Answer Question
| December 29, 2009 1:30 AM
Application development, AS/400, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, Printing, Security, Web development
Can anybody tell me how to interface As/400 with other platforms say windows or linux for example
Answer Question
| December 29, 2009 1:30 AM
Application development, AS/400, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, Printing, Security, Web development
GENERATED KEYS…
I want to generate the next avalable key when INSERTing new rows. For an example… Create Table DBALIB/PARENT ( PARKEY BIGINT NOT NULL WITH DEFAULT PRIMARY KEY, PARNAME CHAR (30) NOT NULL WITH DEFAULT); INSERT INTO PARENT ( PARKEY, PARNAME) VALUES ( PARKEY(MAX) + 1), (<=====> just for illustration) ‘BOBBY’)
Answer Question
| January 8, 2007 12:02 PM
DB2 Universal Database
I want to generate the next avalable key when INSERTing new rows. For an example… Create Table DBALIB/PARENT ( PARKEY BIGINT NOT NULL WITH DEFAULT PRIMARY KEY, PARNAME CHAR (30) NOT NULL WITH DEFAULT); INSERT INTO PARENT ( PARKEY, PARNAME) VALUES ( PARKEY(MAX) + 1), (<=====> just for illustration) ‘BOBBY’)
Answer Question
| January 8, 2007 12:02 PM
DB2 Universal Database
Visual Basic 2005
My task is to write a program to take a input from a user which in this case is a name (forename & surname) and create a VB 2005 program to capitalise the first letter of the first name and surname although also ensure that the remainder of the name is lower case. How do [...]
Answer Question
| January 11, 2007 9:27 AM
Database, DB2, Oracle
My task is to write a program to take a input from a user which in this case is a name (forename & surname) and create a VB 2005 program to capitalise the first letter of the first name and surname although also ensure that the remainder of the name is lower case. How do [...]
Answer Question
| January 11, 2007 9:27 AM
Database, DB2, Oracle
Count distinct rows on multiple columns
I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane 010C Cafe- 10.00 Dollars 104 Sarah 010C [...]
Answer Question
| April 19, 2013 8:23 PM
Access, Data/Application Integration, Database, DB2, Desktops, Development, Management, Microsoft Windows, Oracle, Oracle Business Applications, Oracle development, OS, PeopleSoft, Programming Languages, Security, Servers, SQL, SQL Server, T-SQL, Windows
I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane 010C Cafe- 10.00 Dollars 104 Sarah 010C [...]
Answer Question
| April 19, 2013 8:23 PM
Access, Data/Application Integration, Database, DB2, Desktops, Development, Management, Microsoft Windows, Oracle, Oracle Business Applications, Oracle development, OS, PeopleSoft, Programming Languages, Security, Servers, SQL, SQL Server, T-SQL, Windows
using SQL statements…………..
Hi All, I have a problem. I have a string variable STR which contains SQL statements…… Like insert into lib1/fil1 select * from lib2/fil2 variable STR is changable…means I update the values of library and files at run time…in the variable STR.. I want to execute the SQL statements contained in string STR… How can [...]
Answer Question
| December 23, 2010 9:52 AM
CLP, DB2 Universal Database, RPGLE
Hi All, I have a problem. I have a string variable STR which contains SQL statements…… Like insert into lib1/fil1 select * from lib2/fil2 variable STR is changable…means I update the values of library and files at run time…in the variable STR.. I want to execute the SQL statements contained in string STR… How can [...]
Answer Question
| December 23, 2010 9:52 AM
CLP, DB2 Universal Database, RPGLE
database access
how can i connect to a ms access database which resides on other computer in a network using vb6.0
Answer Question
| January 3, 2007 1:18 PM
Database, DB2, Oracle
how can i connect to a ms access database which resides on other computer in a network using vb6.0
Answer Question
| January 3, 2007 1:18 PM
Database, DB2, Oracle
Front End Development for AS400
Hi We have an application in AS400 for which we are thinking of developing a GUI front end for the users. The users will then be able to run the processes from their PC. I have not worked on any such application and so, I do not know anything of that. I have done some [...]
Answer Question
| January 7, 2007 10:39 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, Email, PC/Windows Connectivity, Web development
Hi We have an application in AS400 for which we are thinking of developing a GUI front end for the users. The users will then be able to run the processes from their PC. I have not worked on any such application and so, I do not know anything of that. I have done some [...]
Answer Question
| January 7, 2007 10:39 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, Email, PC/Windows Connectivity, Web development
Using two same files from different libraries in a RPGLE program.
Hi All, Please guide me for the following problem. I got stuck into it. I want to operate same file from two different libraries in a RPGLE program. Remember we are taking the file names at runtime.So we don?t know the structure of files. Like the record format name etc. Again somehow I retrieve the [...]
Answer Question
| December 28, 2009 4:15 AM
CLP, DB2 Universal Database, RPGLE
Hi All, Please guide me for the following problem. I got stuck into it. I want to operate same file from two different libraries in a RPGLE program. Remember we are taking the file names at runtime.So we don?t know the structure of files. Like the record format name etc. Again somehow I retrieve the [...]
Answer Question
| December 28, 2009 4:15 AM
CLP, DB2 Universal Database, RPGLE
