Procedures for a new area.
We are a company where we have expirience on network remote administration and now we have open a new area, The area of security. Now I need to start to make new procedures like when a new customer come to us and ask if we can handle the security for his network… I need to [...]

Answer Question   |  May 28, 2008  10:13 PM
Access control, Application security, backdoors, Biometrics, Browsers, Cabling, Compliance, configuration, CRM, Current threats, Database, DataCenter, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, Hardware, Hubs, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network management software, Network security, Networking, Outsourcing, patching, PEN testing, Platform Security, Policies, Project management, provisioning, Remote management, Risk management, Routers, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, Switches, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms

Select last 3 transactions
Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= ’12345′ order by TransDate desc. I believe there must be a more effcient way of getting [...]

Answer Question   |  May 15, 2008  6:54 AM
Data analysis, Data warehousing applications, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, SQL

URGENT!!! file field decoder generated on AS/400
REALLY URGENT!!!!!!!!!!!!!!!!!!!!! How can i view the contents of a packaged field? I send an example of the chain. I need to visualize the contents of the little squares: 5 1 91010 491997 9801011L 980101 1 1021023 102 103 100 DTO CARULLA DTO CARULLA DTO CARULLA 0 1 0 11 K 1TQ 15% Q TQ [...]

Answer Question   |  May 22, 2007  11:15 PM
Application development, AS/400, DB2 Universal Database

Email Validation Software
We do a lot of bulk email blasts to our Students, in which we get a high percentage of bounced emails. We are looking into purchasing an Email Validation package and was wondering if anyone can recommend a decent package that would either run on the i5 (AS/400) or that can interface (via ODBC, Java, [...]

Answer Question   |  June 13, 2012  3:26 PM
AS/400, CRM, Database, DB2, E-business, Ecommerce applications, Email, Exchange, Oracle, Web services

computer protection with revert
I am looking for a solution wich will allow me to revert computers setting back to original each time computer reboots. Basically on reboot computer will earse all files and configurations made in previous session.

Answer Question   |  May 21, 2007  10:19 AM
Application security, configuration, Database, Development, Encryption, Exchange, Instant Messaging, patching, PEN testing, Platform Security, Secure Coding, Security, vulnerability management

Tracking Changes to Files
Requirement:- To track any changes to Two files A and B and write fields of A and B to an output file C. A is related to B (A.Employee = B.Employee) Could you please suggest a good approach for this? I am currently using the approach of journalling. 1. Both A and B are journalled. [...]

Answer Question   |  August 13, 2007  5:44 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development

outer join issue
Following occurs in a cursor is plsql block: I have 3 tables: Source (name) Lookupmap (name, lookupname) Lookup (lookupname) I have to: 1)outer join Source and LookupMap based on NAME in order to validate that NAME actually exists in Lookupmap. If NAME in LookupMap is null then I have to provide a message. This is [...]

Answer Question   |  May 10, 2007  2:00 PM
Database, DB2, Oracle

Question on LoadAll Subfile.
Hi, How to load more than 9999 records in the case of loadall subfile??? And i don’t want delete previously loaded records. Thanks, Rama Krishna

Answer Question   |  March 3, 2008  1:58 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, RPG, RPGLE

Error in a Group of Called Programs
Hi, I have a CL program, it calls 10 other programs i.e. pgmA, pgmB, pgmC…….so on…10 programs. While running the CL program error occurred in pgmC. I rectified that error. After rectification once again I will run the CL Program. Now my execution must start from pgmC. How do i do this??? Thanks in Advance, [...]

Answer Question   |  April 26, 2007  12:16 PM
Application development, AS/400, Backup & recovery, CLP, DB2 Universal Database, RPG, RPGLE

V5R3 to V5R4
my operating system was just upgraded from V5R3 to V5R4. All my cobol programs are compiled with *none commitment control and a target release of V5R3M0. However after upgrading the operating system while executing the programs -913 errors are being encountered. The same programs are getting executed fine on a separate box which still is [...]

Answer Question   |  January 8, 2010  12:52 PM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, Project management, RPG, RPGLE

media recovery
Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as “need media recovery”. Please Guide [...]

Answer Question   |  April 10, 2007  5:04 AM
7 and earlier, Architecture/Design, Availability, Backup & recovery, BPEL, Business Process Execution Language, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, Service-Oriented Architecture, SOA, SQL, Windows, XML

Optimizing/Indexing to find last transaction
I’m hoping someone can help me out with this. I’m trying to write a query that will return the last transaction for each item in our warehouse. To do this, I’m using 2 files, first our location detail which has a list of all the locations in our warehouse. This file only has about 60,000 [...]

Answer Question   |  January 8, 2010  12:03 PM
Application development, AS/400, Database, DB2, DB2 Universal Database, Oracle, SQL

Problems eliminating HEX 41 character.
I have a number of files on my DB2/400 database that have spaces with a Hex code of 41 instead of 40. This causes a problem when FTP’ing to a PC for integration with a barcode labeling application. Does anyone know how I can change this character to ANYTHING other than Space HEX 41 !! [...]

Answer Question   |  January 5, 2010  9:03 AM
Application development, AS/400, DB2 Universal Database, RPG, RPGLE

Question on Workfile
Hi, Please could any one help me getting answers to these Questions…. What is the diff. between Workfile and PF? How do u create a WorkFile in RPG or CL. What are the advantages of WorkFile over PF? Thanks Rama

Answer Question   |  March 26, 2007  6:01 AM
AS/400, DataCenter, DB2 Universal Database, RPG, RPGLE

Sorting out missing out
I have 2 files. One having 1000 records and the other 1350. I need to sort out the missing records and place them in an excel sheet. Programmatically how to acgieve this???

Answer Question   |  March 19, 2007  1:14 AM
Application development, DB2 Universal Database, RPG

Sorting out missing records.
Suppose i have 2 database files. one with 250 records and another with 350 records. There are some common records in both files. How to get the missing records?? Is this possible with CPYF command. If yes???Please explain me how to get this. or Is there any other to achieve this. Thanks and Regards Rama [...]

Answer Question   |  March 2, 2007  3:51 AM
DB2 Universal Database

Updating one record with a field of another record where two other fields match
I have the following Table: XREF Group Projid id1 id2 —– ——– —– ———– AEEC SOCAL 71 442760 CAG AWPE 71 442780 CAG MONDPL 71 447585 CAG PLANDI 71 442780 CAG SMCECA 71 442780 CAG AWPE 84 442781 CAG MONDPL 84 447588 AEEC MONDP 84 447589 CAG PLANDI 98 288923 CAG SMCECA 98 288923 CAG [...]

Answer Question   |  March 2, 2007  3:53 PM
Data analysis, Database, DB2, Oracle, SQL

Merging of files in AS400
What is the use of merging files in AS400? How do you do this?

Answer Question   |  February 23, 2010  5:22 AM
DB2 Universal Database, RPG, RPGLE

AS400 disk initialize info
Hi All, I am trying to find printable results or logs for a disk that has been initialized successfully by using SST or DST. The procedure normally completes with a single line of “COMLETED SUCCESSFULLY” I need more infomation like model, serial no, sectors or some proof that this particular disk has passed for the [...]

Answer Question   |  January 4, 2010  5:00 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, Printing, RPG, RPGLE, Security

Comparing 2 files .CSV and getting the missing data using AS400.
I have 2 files of .CSV format. I need to compare them and capture the missing data into Excel sheet. How do i do this using AS400???

Answer Question   |  January 3, 2010  6:46 AM
DB2 Universal Database, RPG, RPGLE